From Script to Front End

[#1]

Hi,

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.

Thanks,

Carla

[ahaahaaha]

Hi Carla

Try

RANGESUM(ABOVE(TOTAL Sum(Qty_Tot),0, ROWNO(TOTAL)))

Regards,

Andrey

[#3]

Hi Andrey,

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

Thanks,

Regards

Carla