Calculation wave - challenge

oddgeir — Fri, 03 May 2024 07:40:04 GMT

In case some of you smart guys out there have a solution to this.

I am trying to build an app where I try to move cost of a team over to the teams they support, so ultimately the teams supporting customer/market knows the real cost of their underlying structure.

The challenge here is that the cost to distribute is based on the consumption cost from underlying teams, so the answer from one calculation is input to the next.

It works well in Excel, however with a risk of creating loops, because there calculation is done one by one. I'm not sure if this is possible to do in Qlik since I guess the modelling needs to eliminate loops/shortcuts, but since there are a many clever heads out there, and many things I still don't know about Qlik, I share it with you.

Team initial cost: Team 1 1.000.000,00 Team 2 1.000.000,00 Team 3 1.000.000,00 Team 4 1.000.000,00 Team 5 1.000.000,00 Team 6 1.000.000,00

This cost is then distributed to the other teams by a defined share

Provider Load share To supported team Team 1 30 % Team 2 Team 1 70 % Team 3 Team 2 80 % Team 3 Team 2 20 % Team 4 Team 3 80 % Team 5 Team 3 20 % Team 6 Team 4 70 % Team 5 Team 4 30 % Team 6

Which ends up in the following end result

Team	Initial cost	Consumption cost	Total cost	Distributed cost	Remaining cost
Team 1	1.000.000,00	-	1.000.000,00	1.000.000	-
Team 2	1.000.000,00	300.000,00	1.300.000,00	1.300.000	-
Team 3	1.000.000,00	1.740.000,00	2.740.000,00	2.740.000	-
Team 4	1.000.000,00	260.000,00	1.260.000,00	1.260.000	-
Team 5	1.000.000,00	3.074.000,00	4.074.000,00	-	4.074.000
Team 6	1.000.000,00	926.000,00	1.926.000,00	-	1.926.000

This should of course be scalable to more than 6 teams, and the relationship between the teams doesn't follow a predefined pattern.

Is it then possible to generate a model giving expected output based on the two types of input?

topic Calculation wave - challenge in App Development

Calculation wave - challenge