Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Now accepting applications for the Qlik Luminary and Partner Ambassador Programs: Apply by July 6!
cancel
Showing results for 
Search instead for 
Did you mean: 
lcclcc
Contributor II
Contributor II

filter one sheet only

I have two sheets. both use same data load editor query. I want a default filter on one sheet. 

When I do actions filter selection, it applies to both sheets.

how can I default filter one sheet only

 

 

Labels (2)
1 Solution

Accepted Solutions
lcclcc
Contributor II
Contributor II
Author

I have a solution.

I created a master item alternate state

I applied the master item alternate state to my second sheet. I applied it to the sheet property and the sheet objects like KPI and table

I then created a sheet action to select values in field. IE where terminal ind = N

These steps applied the filter to only the second sheet

however when I went from the second sheet back to the first sheet, the green filter card was at the top of the first sheet which was misleading. So I added an action to the first sheet to clear all selections.

 

View solution in original post

3 Replies
vighnesh_gawad
Partner - Creator II
Partner - Creator II

Selections in Qlik are global and will affect all sheets. If you need a filter to apply only to one sheet, use an Alternate State.

Create an Alternate State, assign it to all objects on the target sheet, and apply the filter within that state. This keeps the selection isolated from the rest of the app.

 

 

Regards, Vighnesh Gawad
Connect with me on LinkedIn | GitHub
lcclcc
Contributor II
Contributor II
Author

I've been trying to play with alternate states but I don't understand at what point the filter equals the value.

 

I created a master item alternate state called "Terminal N"

 

I applied the alternate state to my KPI and table. But I don't understand where to specify the field called Term_Ind = N is applied

lcclcc
Contributor II
Contributor II
Author

I have a solution.

I created a master item alternate state

I applied the master item alternate state to my second sheet. I applied it to the sheet property and the sheet objects like KPI and table

I then created a sheet action to select values in field. IE where terminal ind = N

These steps applied the filter to only the second sheet

however when I went from the second sheet back to the first sheet, the green filter card was at the top of the first sheet which was misleading. So I added an action to the first sheet to clear all selections.