If I understood you requirement correctly you want your user to choose Year and/Or Month and other information from the first sheet and when they go to the next sheet the selections should be there and if you want you should be able to change it.. So all these things can be done. I am attaching a sample app.. Please have a look and come back with any specific questions you have..
As far as I get it, you have two solutions:
- Smash your data model into pieces, eg.: The filter connected to data model, filtering the same column, will be filtered every associated dimension/measure. If you create an underlying table for sheet 1 and an other to sheet 2 (same data, but different columnname), the filters won't affect each other.
- There is an extension at Qlik Branch , associated to sheet navigaton, and with it possible to define trigger, when press the button e.g. clear filters. If it setted, all selection will be cleared.
Thanks Chandrasheker and Undergrinder.
I don't want the selections on Sheet 1 to carry through to Sheet 2. Nor do I want to blow away all the filtered selections and have to re-select from ground 0.
So if on S1 the user has selected 2015 and 2016, s/he could select May 2014 on sheet 2 and not impact the charts / graphs on sheet 1 and sheet 1s selections not impact Sheet 2. I even thought that it was possible to isolate a particular graph chart within a single sheet from using the 'global' filtering.
Loading the same data onto two distinct tables - creative - but is that the only alternative? Seems like there s/b something 'easier'
It seems like Set Analysis is the way to go for this.
Tableau has a much easier way to get to the same answer.
I know my less sophisticated end users are not going to want to (or have time to) learn set analysis - so some of the capabilities I was hoping were 'self service' will not be. Not to say they can't do the brute force method and unselect everything and re-select just the parameters they want for the second analysis - they just won't be able to see that by just switching tabs.
I'm trying now to
a) figure out if there is a way I can have a user input/select the parameters to go into filtering the set analysis and
b) struggling with dates in driving the set analysis. I'll update in about a week
This should be possible by using alternate states.
Although it is a functionality in QlikView, but it can be implemented in QlikSense as well.
For more on what alternate states are , check this link. There is more on the community about it.
There is an extension for alternate states in QlikSense.
Give one state to all the objects Sheet1 and another state to all the objects in Sheet2.
Here is the extension link.
Also check the video on how to use the extension.
I also found this based on your reply
Is 'Detach' a feature available in Sense? I'm still green so I may have not yet found it - but this was actually what I thought I was looking to do- now I'm thinking Alternate (Altered ) States is more likely what I need.