topic Re: Bar Chart colour consistency in QlikView

Bar Chart colour consistency

Wed, 08 Apr 2015 11:44:47 GMT

Hi there

How do I assign a specific colour to a specific dimension on my chart ? For some reason they keep on changing. Dont know if it has something to do with the sort order, but the colours keep on swapping out.

Awaiting Information dimension should ALWAYS be white. Danger dimension should always be amber, etc......

Re: Bar Chart colour consistency

Anonymous — Wed, 08 Apr 2015 11:51:02 GMT

On the Colors tab <tick> Persistent Colors

Re: Bar Chart colour consistency

Wed, 08 Apr 2015 11:52:40 GMT

It's checked. Still throws my colours around....

Re: Bar Chart colour consistency

datanibbler — Wed, 08 Apr 2015 11:53:07 GMT

Hi,

the colours are defined on the "Colour" tab of the dialog. However, they are dynamically assigned in sequence, so whenever a new expression comes along or the order of the existing ones is changed, colours change.

There is an alternative: Define a set of colours using the RGB() functions (do that in a qvs file to INCLUDE in all of your apps so it will be consistent), then click on the little cross beside each expression on the "formulas" tab and assign a specific colour to them. That will override the "colours" tab.

HTH

Re: Bar Chart colour consistency

awhitfield — Wed, 08 Apr 2015 11:53:59 GMT

Hi Bradley,

Have you tried changing the background colour for each dimension?

Andy

Re: Bar Chart colour consistency

Wed, 08 Apr 2015 11:57:16 GMT

No. How would I do that?

i know how to change the background all ALL dimensions together, but not individually

Re: Bar Chart colour consistency

awhitfield — Wed, 08 Apr 2015 12:00:17 GMT

In here on the dimensions tab

Re: Bar Chart colour consistency

Wed, 08 Apr 2015 12:02:08 GMT

You mean with an IF statement ?

Re: Bar Chart colour consistency

kavita25 — Wed, 08 Apr 2015 12:12:33 GMT

Hi,

Kindly post a sample application

Re: Bar Chart colour consistency

Wed, 08 Apr 2015 12:29:27 GMT

Find reduced data app attached....

When I check Persistent colours, then everything changes.

Re: Bar Chart colour consistency

ashwanin — Wed, 08 Apr 2015 12:32:37 GMT

Might be you have implemented the Section access in this document. Please remove that.

Else try with the If condition, that will work for you.

Re: Bar Chart colour consistency

Wed, 08 Apr 2015 12:53:20 GMT

Section Access removed now.....

Re: Bar Chart colour consistency

awhitfield — Wed, 08 Apr 2015 13:31:24 GMT

Here you go,

Set sla sort order a-z, switch off persistent colours and set your 1-6 colours the same for each chart

Andy