Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have a bar chart that has a cycle group and an expression. The "Show Total" option has been enabled (in the presentation tab) and a bar shows the Total. However, when I change the dimension using the cycle group, the color of the Total bar changes. However, I want the Total bar to always display the same Color. Is there some way I could do this?
Thanks,
Neeraj
Have you tried chart properties>colors>Persistent colors option?
Hi Daniel,
I have tried that option, but using Persistent Colors maintains the same color for values in a particular field. Whereas here I am using a cyle group and I want the Total to have the same color. QlikView always tends to use the last available color for the Total. If one can change it to the first available color the problem can be solved.
Sorry, not sure, can you post a sample? are you using the "Show total (Label)" option? because it's using the first color for me.
Hi Daniel,
In my case it is the last color. Is there any way I can fix it ?
Thanks,
Neeraj
Don't know sorry, are you sure you don't have the "repeat last color" option selected in the graph>color settings?
Yes Daniel,
The 'repeat last color' option has been unchecked . It still shows the last available color for the total.
Thanks,
Neeraj
Neeraj – I would load the color values within Load Script.This way your color RGB values are linked with the fields. And you can alsohide these fields using ‘HidePrefix’ keyword with the pattern.
Something like this...
Set HidePrefix = ‘%’;
Hope this helps!
Cheers - DV
Hi, also trying to set a fixed color for the Total bar.
Already tried if(Dimensionality()=0, LightRed()) on the Expression -> Background Color but it doesn't work.
Really simple on a table but not working on the chart.
Any ideas?
Solution on another post: