topic Re: Issues with subtotal in pivot table expression columns in QlikView

Issues with subtotal in pivot table expression columns

Fri, 18 Sep 2015 15:35:56 GMT

Hi Everyone,

I'm facing some issues with expressions subtotal using pivot table. Actually there are three expression in my table: columns A, B and C where A and B are a result from a set of data and C is a result from A x B. The subtotal option is set and working nice for A and B (presenting as result a sum of each row from the respective column) , however Column C the result presented in Subtotal, instead of considere a sum from all table rows, the result presented is equal subtotal A X subtotal B (see example below). Does anyone knows how to solve it? I mean, make subtotal from C be equal C rows' sum, instead of be equal subtotal "A" times subtotal "B" ?

thanks in advance,

Fayad

Re: Issues with subtotal in pivot table expression columns

satishkurra — Fri, 18 Sep 2015 15:37:50 GMT

Go to presentation tab, select all the required dimensions and check Show Partial Sum option....

Re: Issues with subtotal in pivot table expression columns

Fri, 18 Sep 2015 16:36:31 GMT

Hi Satish,

this option has already been checked properly. The issue is not a missing values, but the result is assuming the expression's formula from column C (column A x Column B)and not the sum of the rows from column C

Re: Issues with subtotal in pivot table expression columns

hic — Fri, 18 Sep 2015 17:18:38 GMT

Sum(Aggr(<A>*<B>, Dim1, Dim2, Dim3 ))

where <A> and <B> should be the appropriate aggregations, e.g. Sum(x) or whatever you have.

Or you switch to a straight table and change the total mode to "Sum of Rows" (Presentation tab)

HIC

Re: Issues with subtotal in pivot table expression columns

Fri, 18 Sep 2015 17:36:02 GMT

It is perfect.

Thank you !!