topic Displaying two different results within an expression as different colour bars in QlikView

Displaying two different results within an expression as different colour bars

Mon, 20 Feb 2012 16:01:39 GMT

Folks,

I have a problem which I am sure must be easy to solve, but I'm not entirely sure where to start.

I have attached a sample qvw. I have some data showing mileage lost due to a number of reasons, traffic, road closure, staff dispute etc etc. Some of these reasons are chargeable and some are not, I'm trying to work out the easiest way of showing the difference so red bars for chargeable and blue for non-chargeable. I have tried moving category as the main dimension and then type as the second dimension, which provides me with the split but doesn't give me the consistent colour theme.

Any assistance will be helpful

Thanks

Displaying two different results within an expression as different colour bars

swuehl — Mon, 20 Feb 2012 16:15:27 GMT

try using this as background color expression (open attributes by clicking on the plus next to your expression in expression tab):

if(Category='Chargeable',lightred(),lightblue())

hope this helps,

Stefan

Displaying two different results within an expression as different colour bars

CELAMBARASAN — Tue, 21 Feb 2012 04:56:48 GMT

Hi,

Use persistent colors option in the colors tab which will give you consistent colors.

Celambarasan

Re: Displaying two different results within an expression as different colour bars

jagan — Tue, 21 Feb 2012 05:12:22 GMT

Hi,

Please find the attached document for solution.

I used the Background Color expression as below

=If(Category = 'Chargeable', RGB(255,0,0), RGB(0,0, 255))

Hope this helps you.

Regards,

Jagan.

Displaying two different results within an expression as different colour bars

Tue, 21 Feb 2012 08:53:17 GMT

Thats great Jagan, thanks for your assistance.