topic Need to create a button as Filter in QlikView

Need to create a button as Filter

nandhaadjame200 — Tue, 06 Nov 2018 16:16:26 GMT

Hi There

Need your help to create a list of buttons as filters. I'm new to this.

So, I've a table with field as "Country" and it contains so many countries, here i need to group a specific list of country as a button filter as "APAC".

Under APAC Button i should have the following countries ('INDIA', 'JAPAN', 'KOREA'), when i click on APAC button, the table in same sheet should filter the countries mentioned previously.

Please help to create this.

Thanks in advance.

Thanks

Nandhakumar

Re: Need to create a button as Filter

Anonymous — Tue, 06 Nov 2018 16:25:40 GMT

you may define an Action in your button with set field Country and Search String

('INDIA'|'JAPAN'|'KOREA')

Re: Need to create a button as Filter

vamsee — Tue, 06 Nov 2018 16:27:04 GMT

A better way to handle this is to create an Inline Table and link it to source based on country.

LOAD * INLINE [

COUNTRY, REGION

INDIA, APAC

AUSTRALIA, APAC

UNITED KINGDOM, EMEA

];

Then either, create a list box to select the region or a button with an action to select in field

Re: Need to create a button as Filter

nandhaadjame200 — Tue, 06 Nov 2018 16:33:53 GMT

Hi Rudolf

Thanks for Quick Turnaround.

Actually i'm very new to Qlik Sense. Can you please guide me step by step from scratch or Share any related document.

Thanks

Nandhakumar

Re: Need to create a button as Filter

nandhaadjame200 — Tue, 06 Nov 2018 16:38:26 GMT

Hi Vamsee

I need to go with button with action option & Need to filter table records. I hope you understood my requirement.

Please guide me with steps from beginning & appreciate if any relevant documents.

Thanks

Nandhakumar

Re: Need to create a button as Filter

vamsee — Tue, 06 Nov 2018 18:28:40 GMT

Maybe this will help

Sheet navigation and actions button in Qlik Sense - Qlik Tuesday Tips and Tricks - YouTube

see the part of select in the field and choose region dimension as mentioned above.

Re: Need to create a button as Filter

MarcoWedel — Tue, 06 Nov 2018 21:46:27 GMT

why does it have to be a button?

Re: Need to create a button as Filter

nandhaadjame200 — Wed, 07 Nov 2018 06:29:17 GMT

Hi Marco

Actually there is no grouping in data level for my requirement, so need to create custom group of filters may be with variables and on one click my entire dashboard should get filtered.

I hope my requirements is clear. Please help to suggest any best methods to achieve this.

Thanks

Nandhakumar

Re: Need to create a button as Filter

nandhaadjame200 — Wed, 07 Nov 2018 06:30:20 GMT

Thanks Vamsee, Let me check and try to implement.