Conditional Expression (Color Legend-Expression)

[demcug82]

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

[Gysbert_Wassenaar · Accepted solution]

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

[demcug82]

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