using conditional palette in a line chart...

[karthik_b]

I have a case where we have to dynamically change the color of the line depending upon a condition and by using conditional palette in the chart options I have created a string variable so that based on the variable from the query my color of the line should vary but I am unable to get the correct colors which I specified using this string variable in the conditional variable. please help me with this.

Thanks in advance.

[cognostechie]

Did you also add values for different colors for that variable? You have to associate different values with different colors

[karthik_b]

Did you also add values for different colors for that variable? You have to associate different values with different colors

I have done that as well.

In my report, I have three columns (RTS, ETR, OTS) and then next to it is a line chart and actually I want the line chart to dynamically change its color for some conditions like

case
when (RTS is not null) then 'a'                                       /* one color*/
when ( substring(timestamp2string (ETR),1,1)='D') then 'b'  /* second color */
else 'c'                                                                       /* third color */
end

Thanks in advance.