topic Re: Stacked Bar Chart uneven colours in QlikView

Stacked Bar Chart uneven colours

infock12 — Wed, 07 Oct 2015 11:18:54 GMT

Hi All,

I am creating two stacked bar charts (please see attached). I have given the below variables for colours under Expressions > Background Colour.

=if([Rating]>12, RGB(255, 0, 0),
if([Rating] >=8 and [Rating] <=12, RGB(255, 153, 0), RGB(255, 255, 0))

The colours are all over the place. It is working in some bars and not working in others, which is strange. For example, if you select "CFN" under Response list box, it works fine (1 yellow, 1 amber, 1 red). However, if you select "Doc", in spite of giving the right values on the bars, there is a same colour. There seems to be something very simple that is wrong. Please help.

Thanks,

Karthik

Re: Stacked Bar Chart uneven colours

kji — Wed, 07 Oct 2015 11:27:52 GMT

Try using Avg(Rating) instead of just rating.

Also "and [Rating] <=12" is superfluous since you already got rid of the with the first if.

Re: Stacked Bar Chart uneven colours

infock12 — Wed, 07 Oct 2015 12:09:23 GMT

Hi Jodan,

Thanks for the quick reply. I tried

=if(Avg([Risk Rating])>12, vRed,
if(Avg([Risk Rating])>=8, vAmber, vGreen))

and it worked!!