topic Re: Pivot Table Partial Sum Problem in QlikView

Pivot Table Partial Sum Problem

rohitians — Fri, 14 Jun 2013 11:11:52 GMT

Hello,

I have this Pivot chart where in i have Quantity rate and Value,

Value=Quantity*Rate Row wise the values are right i.e for 100 kgs of rate rate 10 i am getting value 1000

But when I am taking partial sum product wise the total value doesnt matches.to the total sum which i get

when i export that report in excel..

And can i show only total sum of value and hide quantity and rate???

Thanks and Regards,

Rohit

Re: Pivot Table Partial Sum Problem

Anonymous — Fri, 14 Jun 2013 13:20:29 GMT

Rohit,

The totals in pivot table are always "expression total". Totals in excel are always "sum of rows". Often it is the same but sometimes it is not. It is correct in QV and is wrong in excel, because excel doesn't eliminate duplicates as the "expression total" does.

As for the eliminating totals for some expressions - it is possible. Make your expressions for quatntity and rate conditional, something like this:

if(Dimensionality()>0, <your expression>, '')

It could be SecondaryDimensionality(), depending on your table layout.

Regards,
Michael

Re: Re: Pivot Table Partial Sum Problem

Tue, 20 May 2014 13:13:12 GMT

Hi Michael,

I am facing the same issue.

I tried your solution but it does not work.

Neither dimensionality nor seconddimensionality worked.

PFA a sample excel sheet which consists of 2 dimensions.

Kindly request you to please help.

Also one doubt, How the totals can be right in QV ?

In my case, I manually added the numbers and the totals in the excel are right. Please explain.

Similarly I have another table with 5 dimensions as well where I am facing the same issue.

Thanks in advance

Thanks & Regards,

Sarang M. Mehta

Re: Pivot Table Partial Sum Problem

Anonymous — Wed, 21 May 2014 18:38:38 GMT

Sarang Mehta,

It's not a good idea to add a question to another post, especially the closed one - almost nobody will read it, and I could be too busy to answer. Recommendations:
1. Open a new questions, so there will be dozens new readers willing to help you.

2. Upload qvw rather than excel file. From this file, it's not possible to guess what is going on.

Regards,

Michael
PS: Calculations are always right in QV because it cannot calculate it wrong. The question is if the expressions we use are correct