Hi there,
I have a situation where i have one expeditionID that is related related to multiple orders.
I want to calculate the time when the the latest expedition for a particular order is finished, based on the sum of the amount and the earliest date.
So i want to calcultate the amount, when this amount is reached, i want to know what timestamp is related to this (timehandled) when the amount is reached.
this timestamp needs to be added to the order with the lowest timeprocessed date.
Then i want to continue calculating the sum of the amount for the next order, but starting from next timeHandled timestamp.
I wanted to loop trough the amount and check when the amount is reached, but i do not know exactly how to do this
Are there any suggestions how i could implement this in the Qliksense script?
Thanks in advance!