Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

cancel
Showing results for 
Search instead for 
Did you mean: 
lingzhouwu
Contributor
Contributor

Filter for specific table

Hi all,

I currently have a table that I want to filter. I could make a filter pane but the filter pane selection would apply to the table and everything else in the sheet which I don't want. Is it possible to filter only the data in the table?

I learnt to use set analysis a bit which allows me to exclude tables from selections, but this isn't optimal as I want to apply filters to them as well.

Thanks in advance.

1 Solution

Accepted Solutions
adityaakshaya
Creator III
Creator III

Hi Lingzhou,

You can use Alternate States in Qliksense and this can help you to achieve what you are looking for.

You can put Filter and Table into one state.

Alternate states in Qliksense can be achieved using extension.

Link for alternate State - Qlik Branch

Regards,

Akshaya

View solution in original post

4 Replies
adityaakshaya
Creator III
Creator III

Hi Lingzhou,

You can use Alternate States in Qliksense and this can help you to achieve what you are looking for.

You can put Filter and Table into one state.

Alternate states in Qliksense can be achieved using extension.

Link for alternate State - Qlik Branch

Regards,

Akshaya

View solution in original post

Ivan_Bozov
Luminary
Luminary

lingzhouwu
Contributor
Contributor
Author

TypeSub typeData
A165
A142
A138
A123
A182
A239
A269
A257
A222
A258
B367
B393
B33
B392
B311
B490
B459
B482
B489
B485

Above I've added some dummy data to clarify the format of my data.

What I want to display in Qlik Sense based on this data are two tables.

Table one would have all the data with Type = A and be filterable for Sub type 1 or 2.

Table two would have all the data with Type = B and be filterable for Sub type 3 or 4.

lingzhouwu
Contributor
Contributor
Author

I tried using that extension but it doesn't seem to be working. Maybe I'm using it wrong but is there an example of how to use it?