Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

crichter14
New Contributor II

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!

Tags (1)
10 Replies
bwisealiahmad
Valued Contributor

Re: Using KPI as a Filter in Qlik Sense

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
New Contributor II

Re: Using KPI as a Filter in Qlik Sense

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
Contributor

Re: Using KPI as a Filter in Qlik Sense

‌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
New Contributor II

Re: Using KPI as a Filter in Qlik Sense

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
New Contributor II

Re: Using KPI as a Filter in Qlik Sense

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

crichter14
New Contributor II

Re: Using KPI as a Filter in Qlik Sense

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
Contributor

Re: Using KPI as a Filter in Qlik Sense

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
New Contributor II

Re: Using KPI as a Filter in Qlik Sense

Thank you Steve. This works!

rachellu
New Contributor

Re: Using KPI as a Filter in Qlik Sense

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?