Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
cancel
Showing results for 
Search instead for 
Did you mean: 
nandhaadjame200
Contributor II
Contributor II

Need to create a button as Filter

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

8 Replies
Anonymous
Not applicable

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

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

vamsee
Specialist
Specialist

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

nandhaadjame200
Contributor II
Contributor II
Author

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

nandhaadjame200
Contributor II
Contributor II
Author

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

vamsee
Specialist
Specialist

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.

MarcoWedel

why does it have to be a button?

nandhaadjame200
Contributor II
Contributor II
Author

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

nandhaadjame200
Contributor II
Contributor II
Author

Thanks Vamsee, Let me check and try to implement.