topic Re: Changing bar colour when using a calculated dimension in QlikView

Changing bar colour when using a calculated dimension

Tue, 13 May 2014 16:28:12 GMT

Hi guys,

I've created a bar chart using a calculated dimension (which has 6, custom-made bars).

I want to change the colour of SOME of these bars, and not others. How do I do this?

For instance, I'd like

Calculated Bar 1 - Red

Calculated Bar 1 - Blue

Calculated Bar 1 - Red

Thanks!

Re: Changing bar colour when using a calculated dimension

Tue, 13 May 2014 19:53:41 GMT

Hi O G,

do you have 6 expressions in this chart?

regards

Darek

Re: Changing bar colour when using a calculated dimension

Tue, 13 May 2014 20:22:54 GMT

Hi,

I have one expression, which is simply a count of the variable I have sorted based on the custom dimension.

As an example, the custom dimension seperates values in to groups of values, i.e. 1-50, 51-100, 101-200 etc.

Re: Re: Changing bar colour when using a calculated dimension

Tue, 13 May 2014 20:36:59 GMT

Hello,

find my example.

You can use conditional expression in backgroud color (under your expression).

regards

Darek

Re: Re: Changing bar colour when using a calculated dimension

Wed, 14 May 2014 09:56:44 GMT

Hi Dariusz,

Thanks for your responce, however this does not seem to be working.

I'm grouping the dimension as discussed above, so the dataset looks something like this:

etc...

Then i'm grouping these using a calculated dimension to 1-50, 51-100, 101-200 categories, and THEN counting how many of each there are, so the bar chart has the three categories above, with a count for each as the expression.

I want to be able to change the colour of the '1-50' only.

Any ideas? Unable to post a QVW as working with sensitive data. Thanks.

Re: Re: Changing bar colour when using a calculated dimension

Wed, 14 May 2014 10:10:22 GMT

Get color expression from my example and change condition. It should work. If not - prepare qvd with few rows or you may scramble your sensitive data.

regards

Darek

Re: Changing bar colour when using a calculated dimension

jsingh71 — Wed, 14 May 2014 10:38:04 GMT

Share your sample qvw file.

Re: Changing bar colour when using a calculated dimension

maleksafa — Wed, 14 May 2014 11:13:15 GMT

in your dimension tab, under used dimensions, you can expand the dimension that you want and then go to background color and there you can use the built in color functions or use the RGB function to put your color.