Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
crichter14
Creator
Creator

Using KPI as a Filter in Qlik Sense

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!

10 Replies
bwisealiahmad
Partner - Specialist
Partner - Specialist

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?

Qlik Branch

crichter14
Creator
Creator
Author

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.

SteveNewman
Employee
Employee

‌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

crichter14
Creator
Creator
Author

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!

crichter14
Creator
Creator
Author

opps we have Climber Selection Bar...let's try that again!

crichter14
Creator
Creator
Author

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?

SteveNewman
Employee
Employee

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

crichter14
Creator
Creator
Author

Thank you Steve. This works!

Anonymous
Not applicable

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?