Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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.
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.
Are you using Alternate State ?
Please pass a sample Data ...
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
Hello Marcus,
Thank you so much for your reply? Does a search object also have same property to hide excluded values?
Yes, it have - within the tab presentation the first option.
- Marcus
Hello Marcus,
It does not work when both the filters are in different alternate state.
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
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