Conditional Expression (Color Legend-Expression)

demcug82 — Fri, 16 Oct 2015 09:51:55 GMT

Hi All,

i'm a new on Qlikview and I'm having a problem with the color matching between the legend and expressions.

I have a combo chart with Year and Region on X (Axis) and Expense on Y.

I have two expressions:

1) National AVG (line chart)

2) Regional Expense (Bar chart)

- When I select one or + regions have not problems of color matching (expression - legend)

- When I do not pick a region, the color of the line chart is the bar chart <<<<<-----------------------------------------

I also tried to enter a 3rd Expression and make it invisible:

It solves the problem of the color, but put the labels of the Regions (x axis) even when I not select one.

I tried to use the conditional expression, but does not seem to work.

Here screenshots.

If you need, also, the source file

Dem

EDIT:

INSERT the qvw file

Re: Conditional Expression (Color Legend-Expression)

Gysbert_Wassenaar — Fri, 23 Oct 2015 12:34:26 GMT

See attached qvw. Is that what you're looking for?

demcug82 — Fri, 23 Oct 2015 13:52:24 GMT

oooh YESSS TYVM

Now work

What have you changed?

EDIT:

I found what you set.

You have changed this setting.

Now I understand well what use the sheet "Color"

Ty Again