topic Re: Qlik Sense KPI to sheet & open on value in App Development

Qlik Sense KPI to sheet & open on value

joeybird — Wed, 13 Jan 2016 19:20:05 GMT

i have a kpi, which shows how many customers (customersID) order a breaching 7 days of being delivered, and another that shows exactly the same but 14 days.

e.g March 2014... 3 customers 7 day breach, and 6 customers 14 day breach.

there is set analysis that is behind the kpi are fixed, that count (customersID) based on two conditions... e.g OrderOrigin {"Overseas"}, and Department {"Catering"}

i have enabled the functionality to click on kpi and it opens on a data sheet table "sheet"

i want it however pass the value through

so on the 7 day kpi, when you click to data sheet "Sheet" you only see the 3 customersID's and details.

1. is there code that can be added to the kpi for this to happen?

2. i did find a qlik branch object, but i can only find one that will on pass one value e.g OrderOrigin {"Overseas"}....but i need two variables

OrderOrigin {"Overseas"}, and Department {"Catering"}

is there a link too a branch extension button i can use to pass two variables

please help

Re: Qlik Sense KPI to sheet & open on value

ogster1974 — Wed, 13 Jan 2016 22:03:37 GMT

‌there isn't? but having found one that can pass a parameterA possible solution presents itself. could you create an additional field in your data model that concatenates the 2 variable values together so you can pass in one parameter like you did generateing your section access key?

Re: Qlik Sense KPI to sheet & open on value

reddy-s — Sat, 16 Jan 2016 22:06:42 GMT

Hi Joanna,

Andy's reply should have helped you solve the issue. Just adding to it, You can even replicate the extension with functionality of passing two variables to fit your requirement.

Re: Qlik Sense KPI to sheet & open on value

praveen1108 — Tue, 26 Jan 2016 22:24:00 GMT

Hello Joanna,

How are you doing? Can you please name the extension with which you were able to pass one variable as you mentioned in your post in 2nd point.

I would appreciate for your help.

Regards,

Re: Qlik Sense KPI to sheet & open on value

ogster1974 — Tue, 26 Jan 2016 22:31:00 GMT

‌If there is not an extension built concatenate your 2 fields into one to pass as a parameter will solve your requirement

Re: Qlik Sense KPI to sheet & open on value

praveen1108 — Tue, 26 Jan 2016 22:35:11 GMT

Hello Andy,

Thanks for the quick reply and can you please elaborate the steps.

Regards,