topic Re: Bar with different colors in QlikView

Bar with different colors

Mon, 14 Jul 2014 05:20:55 GMT

Hello Everyone,

I have created a bar chart of student result status,like below image

but I want show the bar of fail status with red color and remaining with green color,could anyone suggest me how is this possible.

I want output like below image..

Mon, 14 Jul 2014 05:30:29 GMT

You can achieve this by Background color of Expression.

Just goto chart properties-->Expressions

Click on + symbol infront of the Expression-->Background Color

There write your expression like

if((your expr)<35,red(),green())

Mon, 14 Jul 2014 05:31:14 GMT

goto background color under your dimension and say

if (result_status='Fail',Red(), Blue())

Mon, 14 Jul 2014 05:33:11 GMT

Thank you it works.