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.

[#2]

Hello Anil,

Thank you for your reply but is there an option where I can get a drop down in a list box and hide the selection name if all are selected?

[Anil_Babu_Samineni]

1) You can create a Multi-box with a single field that will replicate a drop-down listbox. then remove label and Caption if you want

2) Which section name you want to hide if selection for all? Do you mean Title / Caption??

[#4]

Anil,

1)I want it to display All if no filter is applied

2)Also is there any way to remove the green dot that appears alongside the filed name, I would like to remove that whole part of the multibox.

3)Where do i have to insert the expression we discussed above.

Thanks in advance.

[Anil_Babu_Samineni]

1) This will deserve default in Qlikview

2) Didn't get it(Share image)

3) In List Box -> Expression and copy paste with your fieldname

[#6]

[#7]

I want to create a box similar to one on the right

[Anil_Babu_Samineni]

Then, Go to Simple Search Object and then Select fields and use simple Country then work on it as per your need.

[#9]

I am not able to add expression In Search Object, and my two filters are in alternate states, so cant do without writing an expression.

[Anil_Babu_Samineni]

This? If so, Write expression in Search option from Presentation tab

=Concat({1}Aggr(Country1, Country1),',')

Note: Please mark as helpful if it comes to you so then we can thru from there

[vijetas42]

hi,

for this type of scenario, you can use expression in listbox country like, aggr(only(Country),Country)