Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
It works in bar chart too, but you have to put color in Expression/Background color :
Did you select persistent colors?
Yes, I have it selected in all of the charts.
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
];
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?
It works in bar chart too, but you have to put color in Expression/Background color :
Thank you, this did work for me, and now the colors won't change back on me!