topic different total in pivot table in QlikView

different total in pivot table

Anonymous — Wed, 22 Feb 2012 15:54:25 GMT

Hi,

My problem is that in a pivot table that I have 5 amounts of 9,000,000 in an expression, but the total seems 16,000,000.

I no have idea how to change.

I hope you can help me.

different total in pivot table

swuehl — Wed, 22 Feb 2012 15:59:30 GMT

In a pivot, the total is calculated as expression total.

Depending on your data and expression, the result differ from a sum-of-rows.

To get a sum-of-rows, use advanced aggregation:

sum( aggr( YOUREXPRESSION, YOURTABLEDIMENSIONS))

and please have a look at the Help, search for sum-of-rows in pivot tables.

Hope this helps,

Stefan

different total in pivot table

Anonymous — Wed, 22 Feb 2012 16:58:26 GMT

but the problem I have is that the sum of columns (expressions) is not the total, as shown in the image attach, the problem is not the sum of the rows.

thanks for helping

different total in pivot table

Wed, 22 Feb 2012 17:02:01 GMT

Can you upload a sample?

different total in pivot table

swuehl — Wed, 22 Feb 2012 17:07:57 GMT

Maybe I miss your point, I only see one column and a total for that, so I assumed that's the total over the rows.

What value do you expect as total? As Federico said, could you upload a sample or at least state your expressions / dimensions used?

different total in pivot table

Anonymous — Wed, 22 Feb 2012 17:14:39 GMT

ok, I have this expression

if( MaxString({$<Reporte= {[Balance]} >} Rubro1)= 'Total de Activo',

If( Dimensionality()<=Max( {$< $(vSetModoVista) /*La variable incluye coma*/

$(vSetMTDHist),

Reporte = {[Balance]}

>} Dimensionality

Sum ( {$< $(vSetModoVista) /*La variable incluye coma*/

$(vSetMTDHist),

Reporte = {[Balance]}

(([$ Importe ML (Original)]*Signo) * Factor)/Divisor

)

If( Dimensionality()<=Max( {$< $(vSetModoVista) /*La variable incluye coma*/

$(vSetMTDHist),

Reporte = {[Balance]}

>} Dimensionality

Sum ( {$< $(vSetModoVista) /*La variable incluye coma*/

$(vSetMTDHist),

Reporte = {[Balance]}

(([$ Importe ML (Original)]*Signo*(-1)) * Factor)/Divisor

)

I'll try to post an example