Hi
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?
