Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Abhi_WP
Contributor III
Contributor III

Set Analysis to be used for multiple KPIs

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

 

Labels (1)
3 Replies
Zapparoli
Creator II
Creator II

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

Check my Youtube Channel for more Qlik Content
https://www.youtube.com/@ZappaAnalytics

Abhi_WP
Contributor III
Contributor III
Author

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
Creator II
Creator II

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.

Check my Youtube Channel for more Qlik Content
https://www.youtube.com/@ZappaAnalytics