topic Bar chart background color based on value not working as expected in QlikView

Bar chart background color based on value not working as expected

dpduran — Mon, 16 Feb 2015 11:57:42 GMT

Hi all

for some reason when I try to apply a dynamic background color on a bar chart based on a field it simply doesn't work. I can set it up without problems without conditions, but when I try to do it with an if expression it just doesn't change it. It's like condition is not evaluated at all...

See screenshots below:

Bar chart (kind of a gant) with already Status selection to 'Closed' value. Also see my chart properties with colour set to red() for Status='Closed' and not happening at all. (if I put red() in background color it all becomes red without problems)

My Chart properties:

My dimension is the ChangeID (CRQXXXXX) and my expression is duration of this given CRQ (EndTimestamp - StartTimestamp) in hours.
This CRQs have different Status (Closed, Started, etc... ) and I would love to change background colour based on it for each bar. (if status is closed, then bar is red, and so on).

If I use an expression like:

=if (Status='Closed', red(), green()) as Background color for expression all bars become green.

BTW I've already seen lots of examples from QV community and found nothing that worked for me. I'm using QV11.

Any Ideas? Any help would be much appreciated.

Thanks!
Diego.

PS. Also was wondering if it's possible to get bold values on axis based on any other field kind of if status is cancelled the CRQXXX on the axis becomes bold. ¿?

Re: Bar chart background color based on value not working as expected

fred_s — Mon, 16 Feb 2015 16:15:01 GMT

Hi Diego,

First, to solve your problem it would be great for us to have an example file.

Second, I see you've got an expression 'Status'.

Is this Status(=Closed) your expression or is Status a field name?

If it's a field name, you should consider renaming your label for the expression "Status".

Grtz,

Fred..

Re: Bar chart background color based on value not working as expected

dpduran — Mon, 16 Feb 2015 16:20:02 GMT

You know, when you spend so much time trying to do something and you get stuck over and over again trying to solve it.... you pass things like that.

I just changed the Expression label and the condition started being evaluated flawlessly.

I needed a fresh pair of eyes to see this.

Thanks for the quick response Fred.

Re: Bar chart background color based on value not working as expected

fred_s — Mon, 16 Feb 2015 16:25:23 GMT

Anytime 😉