topic Re: Need Help?? in QlikView

Need Help??

paulwalker — Tue, 17 Mar 2015 04:17:24 GMT

Hi,

How to calculate cumulative count/sum in pivot table...

Cumulative it should be 1200, 1200+2300, 1200+2300+2100, 1200+2300+2100+3200

PFA,

Thanks in Advance.........

Tue, 17 Mar 2015 04:25:57 GMT

Try this code :

RangeSum(Before(Sum(Cost),0,ColumnNo()))

PFA

Regards

Lathaa

sagarkharpude — Tue, 17 Mar 2015 04:29:03 GMT

Hi,

PFA

jagan — Tue, 17 Mar 2015 04:30:29 GMT

Hi Paul,

You misplaced the Bracket '(' in your expression use this expression below

=RangeSum(before(sum(Cost),0,ColumnNo()))

Hope this helps you.

Regards,

Jagan.

amit_saini — Tue, 17 Mar 2015 04:34:33 GMT

Hi Paul,

Backend Script (For example purpose):

LOAD * INLINE [
Month ,Sales
Jan ,1000
Feb ,1500
Mar ,2000
Apr,2500
May ,3000
Jun,3500
Jul,4000
Aug ,4500
Sep,5000
Oct,5500
Nov ,6000
Dec,6500

];

Front End Solution:

Call Months and Sale as Dimension on straight table and below as expression to see Cumm result .

=rangesum(above(total sum(Sales),0,Rowno(TOTAL)))

Tue, 17 Mar 2015 06:12:14 GMT

Hi,

See this qvw.