topic Re: Why Are My Colors Switching? in QlikView

Why Are My Colors Switching?

Wed, 05 Apr 2017 17:39:21 GMT

I am working on several bar charts in QlikView which are displaying the number of audit findings (this is the expression) in various categories (dimension 1), broken down by judgment (dimension 2). I associated the judgments with specific colors (Critical is red, Major is yellow, and Minor is blue), and I checked off Persistent Colors. The judgment dimension is sorting by Text (Z->A).

For no apparent reason now, the colors associated with Major and Minor have switched, but nothing else has changed. This happened in every chart that we have set up like this. Does anybody know why this might be happening?

Thanks!

Re: Why Are My Colors Switching?

jrepucci15 — Wed, 05 Apr 2017 18:18:43 GMT

Did you select persistent colors?

Re: Why Are My Colors Switching?

Wed, 05 Apr 2017 18:30:26 GMT

Yes, I have it selected in all of the charts.

Re: Why Are My Colors Switching?

sergio0592 — Wed, 05 Apr 2017 18:37:32 GMT

You can try with loading table color:

JudgmentsColors:

LOAD *

,rgb(R,G,B) as JudgColor

INLINE [

Judgments,R,G,B

critcal,255,28,28

major, 255,255,45

minor,0,128,255

];

Re: Why Are My Colors Switching?

Thu, 06 Apr 2017 14:43:08 GMT

The inline color load is working, but setting the background color only appears to work if this is a table chart of some kind. Do you know how to get the colors to appear on the bars in a bar chart instead?

Re: Why Are My Colors Switching?

sergio0592 — Thu, 06 Apr 2017 19:09:53 GMT

It works in bar chart too, but you have to put color in Expression/Background color :

Re: Why Are My Colors Switching?

Thu, 06 Apr 2017 19:13:48 GMT

Thank you, this did work for me, and now the colors won't change back on me!