Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

cancel
Showing results for 
Search instead for 
Did you mean: 
ankita_arvind1
Contributor II
Contributor II

Changing the color of data points on a line chart for the current year

Hi All,

I have a requirement where I need to change the color of the data points on line chart only for the current year. The line chart is showing values for 5 Years. Can someone help me on this. Thanks in advance.

Regards,

Ankita Arvind

2 Replies
bhavyagrb
Partner
Partner

Hi Ankita,

With the help of my sample dataset, I tried to change color of current year datapoints in linechart by choosing the custom option in Colors & Legend panel and giving expression:

if(sum({<Year={$(=max(Year))}>}Sales),yellow(),red()).

Pls have a look in the below attached image.

Line Graph.png

 

Regards,

Bhavya

Kushal_Chawda

Do you have a single dimension in line chart or two?