Bar Chart Colors

Anonymous — Fri, 20 Feb 2015 18:22:24 GMT

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

Re: Bar Chart Colors

maxgro — Fri, 20 Feb 2015 20:03:59 GMT

try with

if(YEAR<=min(TOTAL YEAR)+1,green(),red())

Re: Bar Chart Colors

Anonymous — Sat, 21 Feb 2015 16:48:32 GMT

Thank you that helped alot.@Massimo Grossi

topic Bar Chart Colors in QlikView

Bar Chart Colors

Re: Bar Chart Colors

Re: Bar Chart Colors