Qlik Community

New to Qlik Sense

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

Announcements
Tell us which business and trade publications you read most regularly: RESPOND NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
ihardouin
Contributor
Contributor

Can I apply separate filters for each sheet in a QlikSense app?

Is it possible to create an app with multiple sheets in Qlik Sense Business # where each sheet has its own set of filters that apply only to items on that sheet? I want to create an app with views across multiple sheets, each of which would show slightly different views of the data based on chosen parameters, and would much rather have this all in 1 app instead of separate apps for each set of conditions.

Thanks for any and all assistance!

6 Replies
rwunderlich

Yes, you can do this easily using the Alternate States feature. 

https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/Visualizations/alternate...

Place each sheet in a different Alternate State and then each sheet will operate independently. 

-Rob
http://masterssummit.com
http://qlikviewcookbook.com
http://www.easyqlik.com

ihardouin
Contributor
Contributor
Author

Thanks. Is there a way to control so that Alternate States that I select for certain sheets show up with those sheets only? That is the main issue I have encountered with the Alternate States function.  For example, I have created 2 separate alternate states that have different values from the same field. In Qliksense, I have the ability to toggle between them in any sheet within the app, and not just in certain sheets where I have assigned a specific alternate state. 

ihardouin_0-1630459205598.png

And when I navigate around Qliksense, it automatically uses the last alternate state I deployed for a certain sheet, not defaulting to the state I assigned for specific sheets.

Ultimately, I'm trying to find if there is a way to deploy an app with specific filters applied to each sheet in the app for ease of use in navigation by the end user. Yes, I understand that Qlik's approach is to apply a uniform filter across all views in an app, and have the user control what they want to filter. However, in this specific case, the users (senior managers) know the information and know what and how it should be set up, and don't want to have to worry about toggling filters on and off for values between sheets.

rwunderlich

Selections in all alternate states will show up in the selections bar.  But that does not mean they have any effect on the contents of the sheet.   Is your issue that you want the current selections bar to only reflect states relevant to the current sheet?

-Rob

ihardouin
Contributor
Contributor
Author

Thank you, yes, that is ultimately this issue. Can this be done in Qliksense?

rwunderlich

To my knowledge you cannot do this with native Qlik Sense. But you can with an add-on such as VizLib.

-Rob

LauraMorris
Contributor II
Contributor II

Could you set up alternate sheets with a series set of filters preset on a spare sheet and then bookmark this.