Conditional Formatting

[pw]

Hi Folks,

i tried to create a variable (string values) which should be able to color a column in a crosstab, which can have about 5 different values.
The Data-Item can have values 50,40,30,20,10. I have build up the variable C_CLUSTER with those 5 values. But how can i transfer the values from the Data-Item into the values of the variable, so that the color coding works? Well, i hope this is understandable ;)

THanks in advance,
Cheers
PW

[bdybldr]

pw,
I'm not sure I understand your question.  How did you define the C_CLUSTER variable?
I would define it as:

CASE [DataItem]
    WHEN ('50') THEN ('Red')
    WHEN ('40') THEN ('Blue')
    WHEN ...
   
    ELSE ('Purple')
END

Something like that.  Good luck

[mrcool]

Hi...if u r using that data item in the variable and the values u r giving r constant...instead of giving values as 1 2 .....giv 50,40 n wat ever u need....in conditional explorer under the variable u created u can find the values as 50,40..etc...

Thanks,
mrkwel

[mrcool]

Hi...Plz update the topic....