Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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
Thanks JordyWegman