Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
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.
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
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.