topic Pivot Table Partial Sum Showing Problem in QlikView

Pivot Table Partial Sum Showing Problem

Thu, 27 Aug 2015 04:18:59 GMT

Hi All,

I am using pivot table to show some calculation. Unfortunately, the partial sum function shows incorrect value. I have already found some post in community which are about the showing problem of partial sum function. I tried to use AGGR function into the expression to solve it, but it is failed.

For my case:

There are some dimensions, like region, product name, part name, quarter and month. The partial sum is shown by region.

Also, there are 2 expressions where one of the expressions (QTY) can show correct value, while another expression (AMT) show incorrectly.

The showing problem exists only when I select currency - Base, that means selecting other currencies like JPY, USD shows the partial sum correctly.

The QVW file is attached here.

Please help me on this.

Re: Pivot Table Partial Sum Showing Problem

sunny_talwar — Thu, 27 Aug 2015 04:23:52 GMT

May be try your AMT's expression:

Sum(Aggr(YourExpression, YourChartDimensions))

Re: Pivot Table Partial Sum Showing Problem

Thu, 27 Aug 2015 04:38:18 GMT

Hi Sunny

I tried your suggested expression before, but the value is still incorrect.

Thanks

Re: Pivot Table Partial Sum Showing Problem

sunny_talwar — Thu, 27 Aug 2015 04:45:37 GMT

I am working on a personal edition of QlikView, so I won't be able to open the file you have shared. I hope someone else might be able to help you better

Best,

Sunny

Re: Pivot Table Partial Sum Showing Problem

Thu, 27 Aug 2015 14:24:46 GMT

Can anyone help me on this?