Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
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
Honored Contributor

Re: From Script to Front End

Hi Carla

Try

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


Regards,

Andrey

Not applicable

Re: From Script to Front End

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