Static Dimension on a chart and ignore the selection from multi box

[Shah1975]

I would like one dimension on chart to be static and should not change based on other selections in the multi-select drop down.

On the chart above irrespective of my selection ‘Product’ the dimension ‘Product’ on the chart should display ‘Loan’ and ‘Lease’ both all the times.

[sunny_talwar]

What is the issue you are running into? Seems like it is working?

[Shah1975]

The multi selection box is used for multiple charts on a dashboard I am trying to built. The Product  selection is required for other chart but not for this one as Product itself is a dimension in this chart and need to stay static irrespective of the selections in box.

[sunny_talwar]

Use set analysis to avoid selection for this particular chart?

[Shah1975]

Sorry I am new to QlikView. Where can I find set analysis on the chart?

[sunny_talwar]

What is your chart expression?

[Shah1975]

My Chart expression is a variable called 'LL_Mix'

[sunny_talwar]

What is the expression... not the label

[Shah1975]

Here's the dimension selected and below is my expression

[sunny_talwar · Accepted solution]

May be change the expression from

LL_Mix

to

Only({<Product>} LL_Mix)