topic Re: Dimension Legend Color Based on Expression Value in QlikView

Dimension Legend Color Based on Expression Value

Anonymous — Mon, 13 Feb 2017 16:15:28 GMT

I have a stacked bar chart with four expressions (we can call them 'Exp1' through 'Exp4' for purposes of example.

The dimension is a date in the form 'MMM YY'.

I want to change the color of the dimension legend for any month/year where Exp3 is less than 0.

I tried the following (which is the contents of Exp3), but the legend remains black:

=IF(SUM(Total_Capacity)-SUM(Total_Enrolled) < 0, RED(), BLACK())

Re: Dimension Legend Color Based on Expression Value

sunny_talwar — Mon, 13 Feb 2017 16:25:10 GMT

Would you be able to share a sample to see the issue?

Re: Dimension Legend Color Based on Expression Value

Anonymous — Mon, 13 Feb 2017 16:29:23 GMT

It would honestly take me too long to build a sample for you.

I tried to change the TextColor of the dimension with the IF statement above.

Re: Dimension Legend Color Based on Expression Value

pipuindia99 — Mon, 13 Feb 2017 17:05:02 GMT

Did you wrote the above said expression in the option called Background expression for colors in dimension field?

Re: Dimension Legend Color Based on Expression Value

pipuindia99 — Mon, 13 Feb 2017 17:06:58 GMT

Give a try in Visual clues tab present in the properties of a chart...

Re: Dimension Legend Color Based on Expression Value

Anonymous — Tue, 14 Feb 2017 12:39:33 GMT

I put it in the Text Color option for the dimension.

Re: Dimension Legend Color Based on Expression Value

Anonymous — Tue, 14 Feb 2017 12:42:07 GMT

Where would I find this tab? It's not in the properties form for the chart.

Re: Dimension Legend Color Based on Expression Value

stabben23 — Tue, 14 Feb 2017 12:52:33 GMT

Hi,

use column() to get Your Expression, in this case column(3) is where you have made Your Exp3. This is for background, do the same for Text Color.

Re: Dimension Legend Color Based on Expression Value

pipuindia99 — Tue, 14 Feb 2017 13:39:08 GMT

What Staffan said is the one which i meant, and if it is not working with this approach, do check the option called Visual clues as you could see in the screenshot of Staffan next to presentation and before Style tab.

Re: Dimension Legend Color Based on Expression Value

stabben23 — Tue, 14 Feb 2017 13:52:59 GMT

There is no settings for Dimensions in Visual cues, this is only for Expression.