topic Re: Bar chart color doesnt work in QlikView

Bar chart color doesnt work

Sat, 05 Jul 2014 12:34:08 GMT

Hello everyone,

I have a calculated dimension in a bar chart and an expression where I have set a condition in the background tab in order to get the bars in different colors. However, it doesn't work, it only works if I go to another sheet and make a selection there which includes some values of my dimension and then go back to the chart. Does someone know the problem?

Re: Bar chart color doesnt work

hic — Sat, 05 Jul 2014 12:47:16 GMT

What does your color expression look like?

HCI

Re: Bar chart color doesnt work

Sat, 05 Jul 2014 13:00:09 GMT

The calculated dimension is if(account=42 or if(account=44, 'School', if(account=43 or if(account=45, 'Office'))))

And then I have an expression like Sum(Costs) and the color expression I tried both:
=If('School', Red(), if('Office', Green())) and also tried

=if(account=42 or if(account=44, 'Red(), if(account=43 or if(account=45, Blue()))))

Re: Bar chart color doesnt work

hic — Sat, 05 Jul 2014 13:13:15 GMT

The first expression will not work since you don't have any field references in it.

The second could work - if you have "account" as dimension, but I assume that you don't. If you don't, "account" will evaluate to NULL - since there are several possible accounts. It could even be that you have school accounts and office accounts on the same line. Hence, you need to add an aggregation function.

Read more here: Use Aggregation Functions!

HIC

Re: Bar chart color doesnt work

Sat, 05 Jul 2014 13:42:48 GMT

Thank you Henric, I included the only function and it works!