topic Re: Why does the legend expression colors disappear when writing code in Background Color? in QlikView

Why does the legend expression colors disappear when writing code in Background Color?

Thu, 28 Jan 2016 13:32:49 GMT

I'm new to qlikview and have a problem with legend for my charts.

As soon as I write statement in the background color for an expression, the legend color for that particular expression disappears (even if the statement is commented). But as soon as I remove all text in the Background Color definition, the color shows in the legend.

I can't figure out why? I'm not sure if this is sufficient information in order to understand the whole problem, let me know if that's the case. Please see screenshots.

Regards

Thomas

Re: Why does the legend expression colors disappear when writing code in Background Color?

swuehl — Thu, 28 Jan 2016 20:27:13 GMT

Could you post a small sample QVW that demonstrates your issue?

Re: Why does the legend expression colors disappear when writing code in Background Color?

Fri, 29 Jan 2016 08:57:35 GMT

Hi swuehl,

Basically the problem is that I use three expressions that I use as stacked. I also want to filter these expression so the chart shows one expression at a time, but in order to keep the same colors that I want when these expressions are stacked, i need to hard code these colors in the Background color for each expression otherwise the Bars will have different colors when filtered.

So when I write my code in the background color for each expression, the legend color disappears for the expressions in the stacked view.

I have provided new screenshots in hope for better understanding of my problem. If this still not is understandable, I wil try to make a smaller QVW sample. Thanks!

When code IS written, legend color disappears.

Image above illustrates how the correct color green is shown in the legend since the Bars also has the same color.

Regards

Thomas

Re: Why does the legend expression colors disappear when writing code in Background Color?

swuehl — Fri, 29 Jan 2016 12:20:27 GMT

I small sample QVW will definitely help.

I think the problem is that the legend colors are evaluated once per chart, in a global context, similar to a text box expression or the expression for your expression header. I assume the background color expression won't render to an unambiguous, distinct value in this context.

Re: Why does the legend expression colors disappear when writing code in Background Color?

jaygarcia — Thu, 07 Apr 2016 13:31:29 GMT

Hi Thomas,

Did you find a solution for this?

Re: Why does the legend expression colors disappear when writing code in Background Color?

Wed, 15 Feb 2017 12:25:36 GMT

I also ran into this problem, but found a solution (with help from the post of swuehl ). The "if" statement in the background color expression must have a value for the "else" condition (third argument in het "if" function). This color will be applied to the legend.