topic How to get Accumulate for Show Partial Sum in Pivot Table in QlikView

How to get Accumulate for Show Partial Sum in Pivot Table

Sokkorn — Thu, 09 Feb 2012 04:05:03 GMT

Hi All,

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

***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

How to get Accumulate for Show Partial Sum in Pivot Table

Sokkorn — Thu, 09 Feb 2012 09:07:26 GMT

Hi,

Any one please me on this.

Regards,

Sokkorn Cheav

How to get Accumulate for Show Partial Sum in Pivot Table

jagan — Thu, 09 Feb 2012 13:36:06 GMT

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.

How to get Accumulate for Show Partial Sum in Pivot Table

Sokkorn — Thu, 09 Feb 2012 14:15:59 GMT

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

How to get Accumulate for Show Partial Sum in Pivot Table

jagan — Thu, 09 Feb 2012 14:37:08 GMT

Hi,

Try this expression.

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

Regards,

Jagan.

How to get Accumulate for Show Partial Sum in Pivot Table

Sokkorn — Fri, 10 Feb 2012 01:00:51 GMT

Hi Jagan,

Thanks once again for your help.

Regards,

Sokkorn Cheav