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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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