How can I differentiate line curve for different categories in Qlikview?

datavisualization
qlikview

#1

Hi,

I’m creating a line chart over years. Here I want to change the color of line if it related with a specific year. I have seen this representation in one of the Qlikview dashboard example. Can you please help me to solve this?

Thanks,
Satish


#2

@Satish,

This can be done using expression building for background color. You can write expressions for background color, text color, text format, line style and more. You can access these by clicking on ‘+’ sign on expression.

Above, you can write conditional expression for “Background Color” of bar charts. For this visualization, you can write expression as:

=if(Year=2009,RGB (210, 210, 210),
if(Year=2010,RGB (150, 150, 150),
if(Year=2011,RGB (110, 110, 110),
if(Year=2012,RGB (60, 60, 60),
if(Year=2013,RGB (255, 0, 0))))))

Hope this helps!

Regards,
Sunil