Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I am new to qlikview. I've been exploring for the past couple of days until I got stuck on Bar chart Color Changing. My requirement is as follows. I have a Sales Chart with year on X-Axis. The first two years in the bar chart should always display one color regardless of the year and the rest of the years should display another color. Even if the year values, not the sales values are changed the pattern should remain the same. I have written and expression in Chart properties-> Expressions-> Background Color as if(YEAR<=2012,RGB(0,255,0),RGB(255,0,0)) for which my requirement has met. But I don't want to use the year 2012 or any other year value for that matter
-Thanks in advance
try with
if(YEAR<=min(TOTAL YEAR)+1,green(),red())
Thank you that helped alot.@Massimo Grossi