Set Analysis to be used for multiple KPIs

Abhi_WP — Fri, 28 Jul 2023 12:52:52 GMT

I have a calculation which needs to be applied based on user selection in 8 different KPIs in the app. How can I re-use it so that any change needs to be done can be done in one place and it will reflect in all KPIs.

KPI - Total Distance Travelled

if(match(Selection_Period,'Current Year'),sum({$<[Current Year Flag]={"Yes"}>} [Distance Travelled per day(kms)]),

if(match(Selection_Period,'Last Year'),sum({$<[Last Year Flag]={"Yes"}>}[Distance Travelled per day(kms)]),

if(match(Selection_Period,'Current Month'),sum({$<[Current Month Flag]={"Yes"}>}[Distance Travelled per day(kms)]),

if(match(Selection_Period,'Last Month'),sum({$<[Last Month Flag]={"Yes"}>}[Distance Travelled per day(kms)]),

if(match(Selection_Period,'Last 3 Months'),sum({$<[Last 3 Months Flag]={"Yes"}>}[Distance Travelled per day(kms)]),

if(match(Selection_Period,'Last 6 Months'),sum({$<[Last 6 Months Flag]={"Yes"}>}[Distance Travelled per day(kms)]),

if(match(Selection_Period,'Current Financial Year'),sum({$<[Current FY Flag]={"Yes"}>}[Distance Travelled per day(kms)]),

if(match(Selection_Period,'Last Financial Year'),sum({$<[Last FY Flag]={"Yes"}>}[Distance Travelled per day(kms)]),

Sum([Distance Travelled per day(kms)])

))))))))

KPI - Total Time Travelled

if(match(Selection_Period,'Current Year'),sum({$<[Current Year Flag]={"Yes"}>} [Time Travelled per day(kms)]),

if(match(Selection_Period,'Last Year'),sum({$<[Last Year Flag]={"Yes"}>}[Time Travelled per day(kms)]),

if(match(Selection_Period,'Current Month'),sum({$<[Current Month Flag]={"Yes"}>}[Time Travelled per day(kms)]),

if(match(Selection_Period,'Last Month'),sum({$<[Last Month Flag]={"Yes"}>}[Time Travelled per day(kms)]),

if(match(Selection_Period,'Last 3 Months'),sum({$<[Last 3 Months Flag]={"Yes"}>}[Time Travelled per day(kms)]),

if(match(Selection_Period,'Last 6 Months'),sum({$<[Last 6 Months Flag]={"Yes"}>}[Time Travelled per day(kms)]),

if(match(Selection_Period,'Current Financial Year'),sum({$<[Current FY Flag]={"Yes"}>}[Time Travelled per day(kms)]),

if(match(Selection_Period,'Last Financial Year'),sum({$<[Last FY Flag]={"Yes"}>}[Time Travelled per day(kms)]),

Sum([Time Travelled per day(kms)])

))))))))

and so on....

Re: Set Analysis to be used for multiple KPIs

Zapparoli — Fri, 28 Jul 2023 12:56:46 GMT

Hi @Abhi_WP

You can create a master item with this measure and reuse it anywhere you want, that way, if you change the master item, all KPI's will change as well.

Take a look at this link: https://help.qlik.com/en-US/sense/May2023/Subsystems/Hub/Content/Sense_Hub/Measures/use-master-measures-expressions.htm

-Zapparoli

Re: Set Analysis to be used for multiple KPIs

Abhi_WP — Fri, 28 Jul 2023 13:02:15 GMT

Thanks Zapparoli. My challenge is, each KPI has different measure

example

Sum([Distance Travelled per day(kms)]

Sum([Time Travelled per day(kms)]

Sum([Time Spent at Location])

Re: Set Analysis to be used for multiple KPIs

Zapparoli — Fri, 28 Jul 2023 13:53:29 GMT

In this case you will need to create a master item for each of those measures.

So, one master item for "Sum([Distance Travelled per day(kms)]", the other for "Sum([Time Travelled per day(kms)]" and so on...

Or you could use your whole expression in the master item, including all those "if(match)".

Let me know if I understood your question correctly.

topic Re: Set Analysis to be used for multiple KPIs in App Development

Set Analysis to be used for multiple KPIs

Re: Set Analysis to be used for multiple KPIs

Re: Set Analysis to be used for multiple KPIs

Re: Set Analysis to be used for multiple KPIs