Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Join “Do More With Qlik” with Mike Tarallo to get a first-hand look at the New Authoring Experience, June 29th: REGISTER HERE
cancel
Showing results for 
Search instead for 
Did you mean: 
sat_tok52
Creator
Creator

Filter values change based on the button selection in Qlik Sense

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. 

sat_tok52_0-1623949644655.png

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

sat_tok52_1-1623949725534.png

 

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

sat_tok52_2-1623949789740.png

 

Any help, How to achieve this.

Labels (1)
3 Replies
Ponkaviyarasu
Partner
Partner

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'.

 

Ponkaviyarasu_0-1624019698834.png

 

 

Hope! This will fulfill.

Thanks! 

sat_tok52
Creator
Creator
Author

Hi  Ponkaviyarasu,

Thanks for your response. Could you please share qvf

Thanks,

 

 

 

Ponkaviyarasu
Partner
Partner

File attached.

Thanks.