Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
vanderson009
Creator III
Creator III

Logic of filter data

Hi Community,

I have Country and City columns.

for Country, i have three country data and city column contains respective cities.

For that three country i have created 3 buttons, as India, Pak, Sri lanka.

If i click on India then ListBox for City column only display Indian Cities with white background and same for other 2 countries.

-- Thanks and Regards,

Villyee Anderson

5 Replies
maleksafa
Specialist
Specialist

for each button add an action, select in field which select the respective country and therefore it will show only the related cities.

jpenuliar
Partner - Specialist III
Partner - Specialist III

you can have a list box with country as field, you can go to Presentation property>>Selection Style Override and use "Windows Checkboxes". this saves you time in coding actions and using 3 buttons.

you can always hide caption and make background transparent and put behind it whatever background you want.

vanderson009
Creator III
Creator III
Author

Hi Malek,

Which action i need to add for button

-- Thanks,

Villyee

maleksafa
Specialist
Specialist

add a button, go to properties, actions, add, selection, select in Field:

in the Field Put your dimension country and in the search string put the value.

example

Field: Country

value: 'India'

its_anandrjs
Champion III
Champion III

Hi,

Go to Botton properties >> Actions >> Select in Field >> Add Field Country

                                                                               and Search String India

Do this for Srilanka Button also Actions >> Select in Field >> Add Field Country

                                                                               and Search String Sri Lanka

And then

Do this for Pak Button also Actions >> Select in Field >> Add Field Country

                                                                               and Search String Pak

Regards

Anand