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
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
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
Hi...Plz update the topic....