Skip to main content
Announcements
Marching toward a simplified navigation! READ ON
cancel
Showing results for 
Search instead for 
Did you mean: 
mbrdenmark
Contributor III
Contributor III

Legend Color when using BG color expressions in bar chart

Hi Qlik Community

I have a bar chart with sales by month, with two expressions; this year (Flag_TY=1) and last year (Flag_LY=1). This works.

However I also have an additional flag field for a fiscal year: Flag_FY. I want to indicate this in the chart by fading the color for months without Flag_FY=1.

By using expressions in the background color for the expressions this works now, but I simply can't figure out how the legend color is determined?

I want the legend to follow the "base" color from the color tab and not the faded version I apply by expression - see following screenshot:

Capture.PNG

If I change the sorting of the Dimension - the legend color becomes correct. I would prefer it sorted like the above. And I would really like to understand why the sorting has an effect.


So it must evaluate the background color expression somehow to create the legend? Maybe someone can suggest a workaround?


I tried to create a copy of both expressions and let one pair be NULL for Flag_FY=1 and the other pair be NULL for Flag_FY=0. Unfortunately this creates a lot of empty white space in the chart and 4 expressions in the legend, so it is also a poor workaround.


I attached a QlikView document with the dummy data demonstrating my issue.


My QV version is 11.20 SR12.


Thank you in advance.

1 Solution

Accepted Solutions
sunny_talwar

Here are few work arounds... they are not perfect, but you can try them out....

Capture.PNG

View solution in original post

4 Replies
sunny_talwar

Here are few work arounds... they are not perfect, but you can try them out....

Capture.PNG

johnw
Champion III
Champion III

I don't think it's evaluating the expression at all. Rather, I think it's taking the color of whatever the leftmost dimension value in your chart happens to be. That's why sorting or selecting can affect the color.

Another imperfect workaround is to create a simple second chart, remove everything but the legend from it, remove the legend from your original chart, and put the new chart on top of the old. See attached.

Or you can build a legend from four text boxes. I've resorted to that at least once before.

mbrdenmark
Contributor III
Contributor III
Author

It works! For some reason when I open your attached document, I don't see those black lines in chart 1 + 2. So they are perfect.

I tried with NULL expression to create something like this, but Qlik just hide legends.

mbrdenmark
Contributor III
Contributor III
Author

That is a clever use of multiple charts.

I have had some other legend layout issues before, where this could have solved it.