Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Qlik Sense specific answers please.
I've read through the forum and get the feeling this isn't possible. I've created three KPI's using Set Analysis to get groupings of
100%+
80-99%
Under 80%
User loves this, but now wants to click on the KPI result and have the sheet objects filter on that result. Anyone ever get this to work?
Any suggestions on how to 'fake it'? Any extensions that might help?
I know a filter or a table would work, but that's definitely not what they want. I know you can click on a text object to take you to a specific sheet, I was hoping there was something similar to pull out the KPI criteria into a filter.
Any suggestions would be appreciated.
Thank you!
Cheryl
...you guys have been so helpful! If I've forgotten to thank anyone, please don't think I'm not grateful...still absorbing everything in!
There are some extensions that mimic Actions and other that work as buttons. A button could be configured to maybe have a label that is the KPI and when you click it this has an action or a variable to it that you use somewhere else?
Thanks Ali! I am looking at Sheet Navigation + Actions for Qlik Sense. If that works, I'll make sure to post the details back here. I was thinking if I could trigger a bookmark, that might work, except the KPI's are dynamic and we're using filters that start with the application (current season, US only) as a default. We have other seasons and other countries so I'm not sure about the bookmark option. I'll keep you posted.
I have done something very similar, but as Ali stated you will need to use extensions. I used the Climher KPI extension since it provided lots of KPI visual options and provided the ability to make selections and navigate to a sheet.
EXTENSION LINK: Qlik Branch
Well the Sheet Navigations + Actions for Qlik Sense didn't help. I can use buttons but I can't customize their appearance to mimic the KPI. Bummer. Checking on Climber next. So far not so good. It doesn't seem to like a calculation(measure) in the List field. I miss the 'button' feature from QlikView so much now!
opps we have Climber Selection Bar...let's try that again!
Climber KPI certainly gives nice graph options, but is there an "ACTION" feature? If I qlik on this KPI I want it to update the current filters to include those in the KPI. Make sense? If so how do I go about that?
Add a navigation (to go to the sheet you want) then apply the action.
See 1:45 in this video: The Climber KPI Extension for Qlik Sense | Michael Nordström - YouTube
Thank you Steve. This works!
This is a helpful start. Are there resources on how to use the "Action before navigation" options? "Select value in field" is pretty straightforward, but I'm having trouble with the syntax for "Select values in field" and "set variable." Using Cheryl's original question as an example, how would we get the navigation to select '80-99%' AND 'Under 80%'?
Additionally, is it possible to navigate to select more than 1 filter?