Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

lingzhouwu
New 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.

Tags (1)
1 Solution

Accepted Solutions
adityaakshaya
Contributor III

Re: Filter for specific table

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

4 Replies
adityaakshaya
Contributor III

Re: Filter for specific table

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

Ivan_Bozov
Valued Contributor

Re: Filter for specific table

lingzhouwu
New Contributor

Re: Filter for specific table

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
New Contributor

Re: Filter for specific table

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?

Community Browser