topic Re: Logic of filter data in QlikView

Logic of filter data

vanderson009 — Tue, 02 Dec 2014 10:37:59 GMT

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

Re: Logic of filter data

maleksafa — Tue, 02 Dec 2014 10:42:58 GMT

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

Re: Logic of filter data

jpenuliar — Tue, 02 Dec 2014 11:17:23 GMT

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.

Re: Logic of filter data

vanderson009 — Tue, 02 Dec 2014 11:38:22 GMT

Hi Malek,

Which action i need to add for button

-- Thanks,

Villyee

Re: Logic of filter data

maleksafa — Tue, 02 Dec 2014 13:10:13 GMT

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'

Re: Logic of filter data

its_anandrjs — Tue, 02 Dec 2014 13:34:50 GMT

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