Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Read about the latest Qlik Community enhancements on the Community News blog!
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?