topic Re: Sum Issue in QlikView

Sum Issue

jyothish8807 — Fri, 09 Jan 2015 07:53:54 GMT

Hello All,

I have a pivot table, when I am trying to take the sum I am getting 25, but in actual it should be 50.

I tried the same in straight chart also, but the output is the same.

Any help?

Regards

sunilkumarqv — Fri, 09 Jan 2015 07:57:42 GMT

try this

Sum(aggr(sum (total value),Dimension))

kavita25 — Fri, 09 Jan 2015 07:58:49 GMT

Hi,

In Straight Table under expression tab, in total mode click on sum of rows by default it is expression total.

In pivot table use aggr function.

for e.g sum(aggr(sum(Sales),Dim1,dim2,dim3))

Regards,

Kavita

tyagishaila — Fri, 09 Jan 2015 08:09:29 GMT

Plz share qvw file.. its really strange I want to see it.

Is this Total(50) come from show partial sum?

jyothish8807 — Fri, 09 Jan 2015 08:12:19 GMT

thanks a lot, I was missing the outer sum part.

Regards

PrashantSangle — Fri, 09 Jan 2015 08:12:35 GMT

Hi,

Use Sum(aggr(Sum(Distinct Sales),Dimension))

Regards