Discussion board where members can learn more about Qlik Sense App Development and Usage.
Please help in sorting out one logic.
Out Put Data
Data is doc id and Finished good wise and sorted based on parent child relation ship.
if you look on the levels, you can see the parent child relationship.
we have to start from the lowest level of child for a particular doc id and Finished good combination. So sorting is important
Let's check the i/p data.
for doc id = 1 and finished good = 167, lowest sort order is 8, that means it is the lowest level of child.
Now start calculating Level Delay, if there is no level below , it means it is 0. and total delay will be Delay + Level Delay.
This is for child.
If you move, one level up - you can see level as 2, so it is again child and not parent - so total delay = Delay + Level Delay.
moving one level up , level is 1. So this is parent for below 2 levels. Now for this, Level delay will be maximum of Total delay from it's child.
this way, we have to move up in the calculation.
Any help would be appreciated.
@sunny_talwar , @Anil_Babu_Samineni - Please help