Hi All,
Is there a way to give OR or AND condition using the WHEN in the styling...

Example: TYPE=DATA,COLUMN=COUNTRY,WHEN=COUNTRY EQ ITALY AND DEALER_COST GT 1000,$

Regards,
Majid

This message has been edited. Last edited by: Kerry,

No, there isn't. But what you can do is evaluate your conditions in a separate field and do your styling according to it.

DEFINE FILE CAR
RED_IND/A1 = IF COUNTRY EQ 'JAPAN' OR SALES FROM 3000 TO 5000 THEN 'Y' ELSE 'N';
END
TABLE FILE CAR
PRINT MODEL
      SALES
      RED_IND  NOPRINT
BY CAR
BY COUNTRY
ON TABLE SET STYLE *
TYPE=DATA, COLOR='RED', WHEN=RED_IND EQ 'Y', $
ENDSTYLE
END

Hope that helps!
- Neftali.

Here's an example of mutliple colors for one field:

 
TYPE=DATA, FIELD=QTYPCT02, COLOR='BLACK', $
TYPE=DATA, FIELD=QTYPCT02, COLOR='GREEN', WHEN=QTYPCT02 GT 5, $
TYPE=DATA, FIELD=QTYPCT02, COLOR='RED',   WHEN=QTYPCT02 LT -5, $