topic Re: Change Chart Background Colour Based on Variable Value in QlikView

Change Chart Background Colour Based on Variable Value

Tue, 22 Jan 2013 11:02:46 GMT

Hi All,

How do I do this. I want to change a single bar chart colour when the value of that bar chart is equal to a variable value. The variable value is an expression!

Please help

Thanks,

Byron

Re: Change Chart Background Colour Based on Variable Value

Tue, 22 Jan 2013 11:10:11 GMT

By the way, this is the expression and it does not work, =if([Monthly Cost]='$(vChart1MaxString)',red(),green())

Re: Change Chart Background Colour Based on Variable Value

Tue, 22 Jan 2013 11:14:09 GMT

Hi,

you can change bar color by changing expresion backgroung color conditionally.

see attachement.

Niranjan M.

Re: Change Chart Background Colour Based on Variable Value

jagan — Tue, 22 Jan 2013 13:05:39 GMT

Hi,

PFA file for solution.

Regards,

Jagan.

Re: Change Chart Background Colour Based on Variable Value

Tue, 22 Jan 2013 13:20:55 GMT

Hi Jagan,

Please could you take a screen shot. Unfortunately I'm using a personal edition now.

@Niranjan, yes that works if I explicitly define the value, but if I use a variable where the value is exactly the same, it does not work. I want to define the condition dynamically

Thanks,

Byron

Re: Change Chart Background Colour Based on Variable Value

jagan — Tue, 22 Jan 2013 13:53:03 GMT

Hi,

PFA screenshot.

Regards,

Jagan.