Discussion Board for collaboration related to QlikView App Development.
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
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
Do you have a single dimension in line chart or two?