topic Re: Grand total and subtotal issue in Pivot table in QlikView

Grand total and subtotal issue in Pivot table

Srinivas — Thu, 28 Jan 2016 10:36:21 GMT

Hi All,

I have small issue in Pivot and Straight table , Pivot table not calculate the exact total value and straight table will give the exact total value ,

Please see below screen shots:

Please find the sample Qvw.

Advance Thanks

Srinivas

Re: Grand total and subtotal issue in Pivot table

sunny_talwar — Thu, 28 Jan 2016 10:40:02 GMT

Try this expression in pivot table:

Sum(Aggr(sum([Sales Quantity])/1000, Country, [Item Number]))

Re: Grand total and subtotal issue in Pivot table

MayilVahanan — Thu, 28 Jan 2016 10:46:01 GMT

Try like this

Pivot table expression

If(Isnull(rowno()), Sum(Aggr(Sum([Sales Quantity])/1000, Country, [Item Number])) , sum([Sales Quantity])/1000)

Re: Grand total and subtotal issue in Pivot table

jonas_rezende — Thu, 28 Jan 2016 10:46:34 GMT

Hi, munnareddy

Utilize aggr() function in Pivot Table for that expression be calculeted of total shape. How Total Mode in Expression Tab is disabled in this object, you need Sum(), different of Straight Table. Follow expression below:

Sum(

Aggr(

sum([Sales Quantity])/1000

,Country

)

Hope this helps!

Re: Grand total and subtotal issue in Pivot table

Srinivas — Thu, 28 Jan 2016 10:50:12 GMT

Hi Sunny,

In my main application have around 25 dimensions, Any other solution without aggr and group by functions.

Regards

Srinivas

Re: Grand total and subtotal issue in Pivot table

sunny_talwar — Thu, 28 Jan 2016 10:52:23 GMT

There might be one, but I am not aware of one