topic Re: How to filter KPI's using a button in Integration, Extension & APIs

How to filter KPI's using a button

Tue, 24 Jan 2017 21:25:59 GMT

I am currently using the "Sheet Navigation & Action" button but cannot figure out how to filter my KPI's when I click on the buttons. Each KPI represents some sort of calculation (Amount, count, etc.)

I am trying to give users the ability to focus on two separate date ranges: (Performance Year) and (Calendar Year)

Performance Year is from 10/1/2016 through 9/30/2017

Calendar Year is from 1/1/2017 - 12/31/2017

I already have the fields that define these dates but I want users to be able to click each button and pre populate instead of having to manually choose the time frames.

Can someone please explain the best way to do this. I've tried creating variables and selecting values in fields but I am not sure if I am doing it correctly.

Thanks,

Andrew

Re: How to filter KPI's using a button

ahaahaaha — Wed, 25 Jan 2017 09:11:06 GMT

Hi Andrew,

According to capabilities of this extension (shown below), I do not see possibilities of what you want.

That is, if I understand your idea. Qlik Sense focuses on the selection and not manual input data (today version Qlik Sense).

Regards,

Andrey

Re: How to filter KPI's using a button

Wed, 25 Jan 2017 13:37:51 GMT

I just figured it out..

FYI for anyone interested:

You can use the "Select Value in Field" and set it to the field you want to be the filter. In my instance I used the "Invoice_Date".

In the value section, just add the date range you are wanting it to filter to...

Once you click the button, the filter should adjust to the values you gave it

Re: How to filter KPI's using a button

ahaahaaha — Wed, 25 Jan 2017 14:17:46 GMT

Yes, at the touch of a button will be pre-prescribed selection. But this, apparently, still goes to the user himself hands introduced minimum and maximum date.

If the selections are fixed in advance, it is easier to use bookmarks of Qlik Sense.

Re: How to filter KPI's using a button

ahaahaaha — Thu, 26 Jan 2017 11:05:49 GMT

Hi Andrew,

By the way, if you create a filter on a date field, you can simply write in the search expression for selection

Maybe this will help solve your problem.

Regards,

Andrey

Re: How to filter KPI's using a button

sasqliksense — Wed, 22 Feb 2017 08:19:53 GMT

Hi Andrew,

I am using the same extension, but I am not able to do the filter based on my criteria.

Please help me out the options I need to select. As of now I am doing below steps.

1. Navigation Behavior -> Navigation Action - None

2.Actions->Actions before navigating - Enabled

First Action - Select Value in Field

Field SUBJECT

Value 'English'

Regards

Sas

Re: How to filter KPI's using a button

ahaahaaha — Wed, 22 Feb 2017 08:52:51 GMT

Hi Sasikiran,

I think you'd better ask the author expansion Issues · stefanwalther/sense-navigation · GitHub

In my example, your sequence of actions does not work too.

Actually this topic is discussed here Select value in field doesn't work · Issue #62 · stefanwalther/sense-navigation · GitHub

Regards,

Andrey