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: 
Sokkorn
Master
Master

How to get Accumulate for Show Partial Sum in Pivot Table

Hi All,

I face one problem with Pivot Table for sum accumulate data. Let see the pictureCummu2.jpg

***For Pivot Table have

    4 dimensions : Transaction, Type, Codes and Weeks

    1 expression : SUM(Cash)

***The dimension <Weeks> is need to drag from vertical to horizontal

**For TOTAL in <Type> dimension

+ Incomming Cash

    - Total in W07-2012 = $36,440.91

    - Total in W08-2012 = $36,440.91 + $15,386.79 = $51,827.70

    - Total in W09-2012 = $36,440.91 + $15,386.79 + $16,322.32 = $68,150.02

    - And so on...

+ Outgoing Cash

    - Total in W07-2012 = ($1,416.21)

    - Total in W08-2012 = ($1,416.21) + 0 = ($1,416.21)

    - Total in W09-2012 = ($1,416.21) + 0 + 0 = ($1,416.21)

    - And so on...

**For TOTAL in <Transaction> dimension

    - Total in W07-2012 = $36,440.91 + ($1,416.21) = $35,024.70

    - Total in W08-2012 = $51,827.70 + ($1,416.21) = $50,411.49

    - Total in W09-2012 = $68,150.02 + ($1,416.21) = $66,733.81

    - And so on...

Please help to guide me how to get this done like picture2.


Many thanks for your help.


Enclosure

Pivot Cumm.qvw


Regards,

Sokkorn Cheav

Please help to guide me how to get this done like picture2.

Many thanks for your help.

Enclosure

Pivot Cumm.qvw

Regards,

Sokkorn Cheav

1 Solution

Accepted Solutions
jagan
Luminary Alumni
Luminary Alumni

Hi,

Try this expression.

=RangeSum(Before(TOTAL Sum(Cash), 0, ColumnNo(TOTAL)))

Regards,

Jagan.

View solution in original post

5 Replies
Sokkorn
Master
Master
Author

Hi,

Any one please me on this.

Regards,

Sokkorn Cheav

jagan
Luminary Alumni
Luminary Alumni

Hi,

I think it is not possible to change the Parital Sum alone, you can try this by using Above()/Before() methods but this would the individual values also along with Partial Sum.  You cannot manipulate the Partial sum values alone.

Regards,

Jagan.

Sokkorn
Master
Master
Author

Hi Jagan,

Many thanks for your reply.

Actually I get luck with: RangeSum(Above(TOTAL Sum(Cash), 0, RowNo(TOTAL)))

But this one working when the dimension <Weeks> is in vertical. Any idea if dimension <Weeks> is in horizontal?

Regards,

Sokkorn Cheav

jagan
Luminary Alumni
Luminary Alumni

Hi,

Try this expression.

=RangeSum(Before(TOTAL Sum(Cash), 0, ColumnNo(TOTAL)))

Regards,

Jagan.

Sokkorn
Master
Master
Author

Hi Jagan,

Thanks once again for your help.

Regards,

Sokkorn Cheav