topic Re: Partial Sum Wrong in a 2 Dimensional Pivot Table in QlikView

Partial Sum Wrong in a 2 Dimensional Pivot Table

Anonymous — Thu, 10 Dec 2015 19:59:20 GMT

Hi Everyone,

I've taken many tries at getting this pivot table to display the total column correctly with partial sum checked on the FiscalMonth field. I'm sure it involves an AGGR(). I even tried a sum(aggr(count())). Can anybody please help me to get the rows to total correctly on the right of the chart? I've attached a sample QVW.

The two expressions that are wrong appear to be just "Units" and "Total Claims".

Thanks a lot!

Re: Partial Sum Wrong in a 2 Dimensional Pivot Table

sinanozdemir — Thu, 10 Dec 2015 20:27:56 GMT

Hi,

What I tried was the below expression for the count() functions:

I only checked two rows so let me know if it is working for you.

Thanks

Re: Partial Sum Wrong in a 2 Dimensional Pivot Table

Anonymous — Thu, 10 Dec 2015 20:35:46 GMT

That did it. I was pretty close with something like that, but i didnt add the 2nd dimension in the AGGR() 😕

Thank you!

Re: Partial Sum Wrong in a 2 Dimensional Pivot Table

sinanozdemir — Thu, 10 Dec 2015 20:40:10 GMT

You are welcome. I am glad I was able to help.