How to create context filters?

[#1]

I have 2 filters Continent and Country.

My data is like this:

Continent          Country

Asia                    China

Asia                    Japan

Asia                    Malaysia

Europe               Germany

Europe               Netherlands    

I am creating filters as list boxes but when i apply first filter of Continent, I want country filter to only give option of the countries which are in that particular continent, eg: If Asia is selected then Country filter should not have option of Germany and Netherlands.

[ziadm]

if these two field in the same table  or related table by a Country as key then selecting Continent will filter only countries in in the selected continent.  This is the associative experience of Qlik.  

[#3]

Hello Ziad,

Thank you so much for your reply. The problem I am facing is that both the filters are in different states. So, they are not filtering that way.

[ziadm]

Are you using Alternate State ?

Please pass a sample Data ...

[marcus_sommer]

There is an option within the listbox properties in tab general to hide excluded values. Another possibility would be to use a listbox-expression like: aggr(only(Country),Country).

- Marcus

[#6]

Hello Marcus,

Thank you so much for your reply? Does a search object also have same property to hide excluded values?

[marcus_sommer]

Yes, it have - within the tab presentation the first option.

- Marcus

[#8]

Hello Marcus,

It does not work when both the filters are in different alternate state.

[marcus_sommer]

I'm not sure if you could connect a search-box within different states with this excluding option but by a listbox-expression like above mentioned you could add a set analysis to the only() function which synchonized the states whereby I couldn't give you the right syntax for it because I don't use this feature and aren't familar enough to it. But I think if you searched for set analysis and alternate sates you will find various hints and examples.

- Marcus

[Anil_Babu_Samineni]

May be this for your list box expression

Aggr(Country, Country) should work

marcus_sommer‌ -- Can i know why do we require Only() function here