filter hirachical dimension

[zeiherj]

Hey,

I have data with hirachical dimension (Continent and Country, see example data attached).

I'm trying to create a filter that allows multiple selections in the Continent dimension, but only one value in the Country dimension. In addition, one value should be selected in the Country dimension when starting the app. If I try this by activating the check box "always one selected value", I can no longer select any fields in the Continent dimension. The Continent dimension only serves to limit the selection of fields in the Country dimension. For example if Albania ist selected in the Country dimension, I stil want to be able to select Asia in the Continent dimension and then the selection in the Country dimension automatically changes to Afghanistan (first in list).

Thanks in advance and best regards!

[Qrishna]

i cannot open this qvf, if possible provide some sample data and expected output her.

[zeiherj]

Sorry, I missed your reply!

Here is some data and a screenshot of the expected solution.

LOAD * Inline [Continent,Country,myField
'South America','Guyana',33
'South America','Venezuela',71
'Africa','Tanzania',44
'South America','Suriname',30
'Oceania','New Zealand',23
'North America','Panama',75
'Africa','Congo',2
'Africa','Cape Verde',57
'South America','Argentina',72
'Asia','Nepal',84
'Africa','Zambia',23
'Europe','Croatia',63
'Asia','Laos',79
'Asia','Pakistan',53
'Asia','Philippines',67
'Asia','Bahrain',78
'Europe','Azerbaijan',31
'Africa','Malawi',90
'Europe','Serbia',90
'Africa','Sao Tome and Principe',88
'Asia','Kuwait',65
'Africa','Niger',58
'Europe','Malta',16
'North America','US',44
'Asia','Lebanon',87
'Africa','Democratic Republic of Congo',9
'Asia','Saudi Arabia',49
'Africa','Chad',61
'Asia','Turkmenistan',43
'Europe','Iceland',45
'Africa','Sierra Leone',8
'Asia','Sri Lanka',90
'Europe','Moldova',20
'Europe','Belgium',18
'Oceania','Samoa',6
'Africa','Senegal',94
'Africa','Benin',75
'Europe','Ireland',77
] ;

[Qrishna]

 1. For a field selection event from field Continent, you need a trigger, unfortunately that is not there in qlik sense yet. 

2. the on sheet open you could do Country = 'Your_Desired_Country_Name'