Focal Point
Conditional styling in Bar Graph

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/6151034542

September 05, 2007, 10:40 AM
Shankar
Conditional 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.


WF 8.1.04,Windows 7,
DataBase: Oracle 11g,Output :Excel,PDF,HTML
September 06, 2007, 01:44 PM
Kerry
Hi 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. Smiler

Cheers,

Kerry


Kerry Zhan
Focal Point Moderator
Information Builders, Inc.