topic Re: Total come wrong in Pivot in QlikView

Total come wrong in Pivot

prma7799 — Tue, 15 Sep 2015 05:37:11 GMT

Hi All,

I have pivot table in that i my totals is not coming properly.

PFA of excel which is taking from pivot table.

Thanks

Re: Total come wrong in Pivot

Tue, 15 Sep 2015 05:39:59 GMT

Hi,

In this excel which and all fields you are considering for total in your pivot table.

Re: Total come wrong in Pivot

prma7799 — Tue, 15 Sep 2015 05:42:55 GMT

Hi,

I am taking this output from my pivot table. And i got wrong figure for last three column.

Thanks

Re: Total come wrong in Pivot

Kushal_Chawda — Tue, 15 Sep 2015 05:43:54 GMT

try aggr function ,

sum(aggr( YourExpression), Country, Customer))

Re: Total come wrong in Pivot

prma7799 — Tue, 15 Sep 2015 05:48:42 GMT

Hi Kush,

I tried your expression i got my expected output also but can you please tell me why this happened.

Thanks

Re: Total come wrong in Pivot

Kushal_Chawda — Tue, 15 Sep 2015 05:52:03 GMT

as in pivot table we don't have some of rows option, total is by default expression total. So to make pivot total to sum of rows we use aggr fucntion to aggragate all the values with respect to each dimension to get the correct total

Re: Total come wrong in Pivot

prma7799 — Tue, 15 Sep 2015 05:55:30 GMT

Kush141087‌

So every time we need to take expression with aggr in Pivot table?

But in my pivot table am taking at least 12 dimension then why we take on first to like country and customer.

Please give some suggestion.

Re: Total come wrong in Pivot

nagarjuna_kotha — Tue, 15 Sep 2015 06:02:01 GMT

PFA....

Re: Total come wrong in Pivot

Kushal_Chawda — Tue, 15 Sep 2015 06:08:17 GMT

It's not always the case.IF your data model is perfect and no duplicates and expression is simple you will get the correct total. if you have any If condition or you have bit more complex expression you need to use aggr