September 05, 2007, 10:40 AM
ShankarConditional styling in Bar Graph
Hi,
I am working on a bar graph where in I want to do some conditional styling.
Say the graph is like- Production of cars across car models
Here I am DEFINING a field for styling, which takes values depending on the car model
E.g MODEL_VAL/A1 = IF CAR EQ 'MERC' THEN 'M'
ELSE IF CAR EQ 'BMW' THEN 'B';
I want another styling to be done which is again dependent on car model, plus production amount.
E.g PROD_VAL/A2 = IF CAR EQ 'MERC' AND PRODUCTION GT 1000 THEN 'P1'
ELSE IF CAR EQ 'BMW' AND PRODUCTION GT 500 THEN 'P2';
Both these fields are mutually exclusive.
MODEL_VAL will always have a value.
But when any condition in PROD_VAL also is satisfied, the styling done by MODEL_VAL does not reflect in the graph.
Please suggest if the above method is correct and how I should tackle this issue.
Thanks.
September 06, 2007, 01:44 PM
KerryHi Shankar,
Before getting someone to help on this, can you please paste a sample code that you are currently using? You may want to repro the issue using the most favorite CAR file or some other IBI sample data. Or, please share with us a screenshot of what you have, which will be of more help.
Thank you in advance for sharing with all.
Cheers,
Kerry