Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

From Script to Front End

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

2 Replies
ahaahaaha
Partner - Master
Partner - Master

Hi Carla

Try

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


Regards,

Andrey

Not applicable
Author

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