Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
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
Hi Jon,
As far as I get it, you have two solutions:
G.
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'
Hi Jon, I have the same problem as yours, do you manage to figure it out?
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
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
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
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