[CLOSED] Multiple when condition for a single formatting row
Hi
can i Use multiple WHEN condition in my stylesheet. I need to put two condition together
WHEN=A EQ B AND WHEN =C EQ 'abc'
is there any solution to use two condition together. I tried to use TYPE=DATA,COLUMN=P1,FOCEXEC=joe,WHEN=A EQ 1,$ TYPE=DATA,COLUMN=P1,FOCEXEC=frank,WHEN=B EQ 2,$
but it not applies both condition togetherThis message has been edited. Last edited by: <Kathryn Henning>,
If something is not working for you, I'd suggest that you post your code (just the relevant pieces) for us to take a look. Better yet, try and replicate the issue using a TABLE FILE CAR statement and post it here.
Just a question, are you declaring the "control" field in a COMPUTE or DEFINE statement? If DEFINE, make sure to add the field to your TABLE FILE request using NOPRINT.
Now, try also to declare your control field using an alpha type instead of numbers, the reason being that if you declare it in a DEFINE but you're using a SUM verb, your field will be aggregated and therefore your WHEN=ctrl EQ 0 clause may never be true.
SET BYDISPLAY=ON
TABLE FILE CAR
SUM
SALES
COMPUTE CONDITION1/A10 =
IF COUNTRY EQ 'JAPAN' THEN '1'
ELSE IF MODEL EQ 'TR7' THEN '2'
ELSE '3'; NOPRINT
BY COUNTRY
BY MODEL
ON TABLE SET STYLE *
TYPE=DATA,COLUMN=P1,FOCEXEC=JOE,WHEN=CONDITION1 EQ '1', $
TYPE=DATA,COLUMN=P1,FOCEXEC=FRANK,WHEN=CONDITION1 EQ '2', $
ENDSTYLE
END
Francis
Give me code, or give me retirement. In FOCUS since 1991
Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server