Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Why Are My Colors Switching?

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!

1 Solution

Accepted Solutions
sergio0592
Valued Contributor II

Re: Why Are My Colors Switching?

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

6 Replies
jrepucci15
Contributor

Re: Why Are My Colors Switching?

Did you select persistent colors?

Not applicable

Re: Why Are My Colors Switching?

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

sergio0592
Valued Contributor II

Re: Why Are My Colors Switching?

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

];

Not applicable

Re: Why Are My Colors Switching?

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?

sergio0592
Valued Contributor II

Re: Why Are My Colors Switching?

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

Not applicable

Re: Why Are My Colors Switching?

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

Community Browser