Filter values change based on the button selection in Qlik Sense

[sat_tok52]

Hi All,

I have a States filter and I have three buttons in my report.

If I selected INDIA button , the filter display only IND related States values Show in the dropdown filter. 

If I selected USA button , the filter display only USA  related States values show in the dropdown filter.

If I selected ALL button , the filter display ALL States values show in the dropdown filter.

Any help, How to achieve this.

[Ponkaviyarasu]

Hello,

You're almost done as per your screenshot. There're few ways to achieve the above scenario. Sharing one of the method to achieve this scenario.

Step1: Make sure your data looks like below structure

Country,States
India,Bangalore
India,Delhi
India,Hyderabad
USA,Florida
USA,Houston
USA,NewYork

#2: Select Filter pane add col 'States' as dimension. [Note: Use this expression "=aggr(States,States)" to show only possible values ]

#3: Add 3 button objects named as 'IND', 'USA' & 'ALL' respectively.

#4: In 'IND' button, go to Action choose 'Select value in field'  --> Field as 'Country' and type value as 'India'.

#5: Repeat step#4 for 'USA' button respectively. (type value as 'USA')

#6: In 'ALL' button, go to Action choose 'Clear Selections in field'  --> Field as 'Country'.

Hope! This will fulfill.

Thanks! 

[sat_tok52]

Hi  Ponkaviyarasu,

Thanks for your response. Could you please share qvf

Thanks,

[Ponkaviyarasu]

File attached.

Thanks.