Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

rpayn01215
Contributor

Partial Sum Wrong in a 2 Dimensional Pivot Table

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!

1 Solution

Accepted Solutions
sinanozdemir
Valued Contributor III

Re: Partial Sum Wrong in a 2 Dimensional Pivot Table

Hi,

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

Capture.PNG

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

Thanks

3 Replies
sinanozdemir
Valued Contributor III

Re: Partial Sum Wrong in a 2 Dimensional Pivot Table

Hi,

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

Capture.PNG

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

Thanks

rpayn01215
Contributor

Re: Partial Sum Wrong in a 2 Dimensional Pivot Table

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

Thank you!

sinanozdemir
Valued Contributor III

Re: Partial Sum Wrong in a 2 Dimensional Pivot Table

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

Community Browser