Set Analysis to be used for multiple KPIs

[Abhi_WP]

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.... 

[Zapparoli]

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-measu...

-Zapparoli

[Abhi_WP]

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])

[Zapparoli]

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.