Calculate metric based on two measures from different tables

florian_kloster — Wed, 29 Nov 2023 11:06:46 GMT

Hi all,

I have a quick question regrading my attempt to combine two metrics into one KPI from different tables.

first metric:
sum(aggr(sum({$<OPPORTUNITY_BUSINESS_UNIT={$(vBusiness_Unit)}>} OPPORTUNITY_TOTAL_OPPORTUNITY_QUANTITY), AGGREGATION_IDENTIFIER, OPPORTUNITY_CREATED_DATE_YEAR)*AGGREGATION_WEIGHTING_POSTAL_CODE)

second metric:
sum(REGISTERED_ELEVATORS_NEW)

What I want to achive:
I want to calculate first metric / second metric and display this as a line chart by a time-dimension.

Problem:
Both metrics are from different tables and therefore have different time related fields. I could calculate the first metric and join it on the second data source, but this would be less preferable since the calculation is relatively complex.

Question:
Is there any way to combine both metrics and show the result in a line chart, even though both have different time related fields?

Thanks,
Florian

Re: Calculate metric based on two measures from different tables

F_B — Tue, 10 Sep 2024 08:16:48 GMT

Hi @florian_kloster ,

you may need to create a common time dimension that can be linked to both tables. You can find many posts about Master Calendar here in the community, like this for example: Solved: How to Create Master Calendar ? - Qlik Community - 103109

Hope this helps

topic Re: Calculate metric based on two measures from different tables in App Development

Calculate metric based on two measures from different tables

Re: Calculate metric based on two measures from different tables