topic Re: Multiple Totals coming after sorting column in Pivot table. in QlikView

Multiple Totals coming after sorting column in Pivot table.

Anonymous — Wed, 29 May 2013 11:37:22 GMT

Hi all,

I have created a pivot table.

When I sort columns in the table then multiple Totals come on top.

I have used aggr function and also variable in Expressions.

Re: Multiple Totals coming after sorting column in Pivot table.

tresB — Wed, 29 May 2013 11:50:16 GMT

It seems that your table has partial sums enabled at various levels(dimensions). Check that in the presentation tab and uncheck accordingly.

Thanks.

Re: Multiple Totals coming after sorting column in Pivot table.

Anonymous — Wed, 29 May 2013 12:37:07 GMT

Thanks tresesco

I checked at my end and tried solving the problem. First of all what you said works perfect for Pivot Tables. For Straight Tables I found that I had enabled totals at Dimensions as well as Expression totals... By disabling either one I am able to solve the problem

Hope this helps others facing similar problem in future.