Discussion board where members can learn more about Qlik Sense App Development and Usage.
I have several orders with a cumulative duration. Now I want to calculate the single duration per step.
I have tried this with
If(Order = previous(Order), Previous(cumulated)-cumulated, 0) as single
Now the single time is shifted by one row.
How do I achieve that it's not shifted anymore?
Thank you very much for your support.
Hello @rohi__ ,
I don't know if I got it right... See
In load editor:
load order, cumulated, If(order = previous(order), cumulated - previous(cumulated), 0) as single inline [
Hi @Ezir ,
I had to order the data properly...
In the App it showed me the correct sequence but when i looked up the Data Model Viewer it was all messed up.
Thanks for your Reply!