Restricting Filter values based on dimension selection

[M_Jay]

Hi,

I have two (dimension) filters.

1) The company filter has 4 different values - A, B, C, and D

2) The country filter has 2 different values - US and CA

My goal is when I select the the company A,B, and C the users get an option to select the countries from the country filter.

But when the company D is selected I want to lock/hide/deactivate the values in the Country filter.

How do I do this? Thanks in advance for any solution.

How do 

[JordyWegman · Accepted solution]

Hi Jay,

In your country filter you could say:

IF(GetFieldSelections(Company) = 'D',null(),Country)

Though an advise.. Qlik is designed to show you all relations between the data. If D is not connected to one of the countries, then it will automatically show dark gray. The color of no relation..

Jordy

Climber

[M_Jay]

Thanks JordyWegman