topic Bar Chart Color Corresponding to Dimension Value in QlikView

Bar Chart Color Corresponding to Dimension Value

richardpayne — Thu, 04 Mar 2010 23:49:39 GMT

I am attempting to create a bar chart where the color of the bar is permanently attributed to the value of a dimension.

I have orders with a given status: late, early, or on time. For each month, there are three bars for each of these values.

I want the "early" bar to be yellow, "late" to be red, and "on time" to be green. I have tried checking the "persistent colors", but this doesn't work. Eventually, as the data changes, the colors swap. Any ideas?

Bar Chart Color Corresponding to Dimension Value

Oleg_Troyansky — Thu, 04 Mar 2010 23:52:59 GMT

Use "Background Color" attribute of the expression and determine your color based on the Dimension Value:

If (Dim1 = 'Late', red()) etc...

cheers,

Bar Chart Color Corresponding to Dimension Value

richardpayne — Fri, 05 Mar 2010 00:05:29 GMT

Oh, wow. The background color worked. I was concentrating on the color tab.

Thanks!

Bar Chart Color Corresponding to Dimension Value

Tue, 29 Jun 2010 18:30:17 GMT

and how do I do the same for the value on the bar. I want negatives to be red, positives to be blue.

Bar Chart Color Corresponding to Dimension Value

Tue, 29 Jun 2010 18:42:28 GMT

Nevermind, just found out.

Bar Chart Color Corresponding to Dimension Value

Tue, 12 Oct 2010 10:51:44 GMT

Hello,

In additional, is it possible to attribute an image (like flag) corresponding to dimension value?

See joined file for example.

Thanks for your help

Laurent