Calculate metric based on two measures from different tables

[florian_kloster]

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

[F_B]

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