Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Wrong Total in a Pivote Table, Why????

Hi Guys, I just don´t understand why my totals in this pivote table is wrong, please does any body have any idea???

I attached the app, Thank you Guys!!

1 Solution

Accepted Solutions
Not applicable

Re: Wrong Total in a Pivote Table, Why????

Hi Jason, Thanks foe your Reply, I found the solution, we can do it using set analisys, I attached the app.

Thank you I appreciate your time and reply.

BG.

3 Replies
jason_michaelid
Honored Contributor II

Re: Wrong Total in a Pivote Table, Why????

This is a classic issue and is to do with your use of Avg().  The "Total" is not a sum of all the other totals but the average across all dimension values.  With an average this will most likely be different.  In the attached file I have copied the pivot table as a straight table for you and added the same expression, but this time selected "Sum of rows" for the total (you can't do this in a pivot table).

Hope this explains it!

Jason

Not applicable

Re: Wrong Total in a Pivote Table, Why????

Hi Jason, Thanks foe your Reply, I found the solution, we can do it using set analisys, I attached the app.

Thank you I appreciate your time and reply.

BG.

jason_michaelid
Honored Contributor II

Re: Wrong Total in a Pivote Table, Why????

Please mark your own answer as correct so the thread looks answered.

Cheers,

Jason

Community Browser