QlikSense - sheet specific filtering

[jonbmorrison]

In my app I'd like to be able to have the user select his/her parameters based on years on sheet 1 and have the information presented for the current month on sheet 2.  I'd also like to give the user the ability to chose (filter) for a different month on sheet 2.

There may be additional parameters that could vary between sheet 1 and sheet 2 as users perform data exploration.

I know this is basic (or think it should be) - but after a day plus of looking - figure I'm wasting more energy than just asking.

Apologies as I'm new to Sense and Qlik.  I tried searching for a simple answers.

I found information on how this might be accomplished with Sets - but my next question would be how to change the parameters so the user him/herself could change the period used in the set parameters.

I found information that might work using load scripting - but again was trying to keep it simple and flexible in case additional questions arose when interrogating the data

I found several QlikView specific answers which don't seem applicable to Sense.

Tried to find the right video to watch with the easy answer - no joy (yet).

I know I've seen something that had how to make this work, but can't seem to re-locate it.

I'm using Qlik Sense Desktop at this time.

[Anonymous]

HI Jon,

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

Thanks

[undergrinder]

Hi Jon,

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.

G.

[jonbmorrison]

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'

[#5]

Hi Jon, I have the same problem as yours, do you manage to figure it out?

[jonbmorrison]

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

[#7 · Accepted solution]

Hi Jon,

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.

http://branch.qlik.com/#!/project/5693cd6715f524dc43e7ec37

Also check the video on how to use the extension.

Qlik Sense Alternate States - The Full Set - YouTube

Regards,

Rohan

[jonbmorrison]

Rohan

I also found this based on your reply

Re: Alternate state, Detach & Unliking object

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.

Many thanks

[#9]

Hi Jon,

Well, there is no direct option in QlikSense to detach a chart.

But you can use Alternate states for that.

Another option would be to use {1} in the expression.

E.g.: Sum({1}[Sales])

This will detach your chart i.e. any user selection will not have any impact on the chart.

Regards,

Rohan