Discussion board where members can get started with Qlik Sense.
I have an expression that works perfectly in Qlik Sense Script:
If(PN_tot= Previous(PN_tot), rangesum(Qty_Tot, peek(Cumulative)),Qty_Tot) as Cumulative order by PN_tot, Data asc
Now I need to create a "cumulative" measure in a graph that can do exactly the same thing, how can I do?
From the script I keep having PN_tot, Qty_Tot and Data as Field.
RANGESUM(ABOVE(TOTAL Sum(Qty_Tot),0, ROWNO(TOTAL)))
thanks for the reply, rearranging Above and using Total as
if(PN_tot=above(total PN_tot),rangesum(Qty_Tot, above(total Qty_Tot)),Qty_Tot)
I could get the right output