topic Re: Changing the color of data points on a line chart for the current year in QlikView

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

Anonymous — Thu, 15 Mar 2018 06:53:32 GMT

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

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

bhavyagrb — Thu, 27 Aug 2020 12:06:01 GMT

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.

Regards,

Bhavya

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

Kushal_Chawda — Thu, 27 Aug 2020 13:14:42 GMT

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