topic Re: To Calculate Sum of Rows with aggregated expression in QlikView

To Calculate Sum of Rows with aggregated expression

Wed, 16 Jan 2013 00:02:24 GMT

I want to calculate the Total sum by Región of [PDM X Región 2] Field

I have this:

[PDM x Región 2] = [PDM x Cemento] * [Volumen %]

And I want to get the total sum = 2.47

My [PDM x Región 2] Expression is: [PDM X Cemento]* Sum(Volumen)/Sum( DISTINCT TOTAL <Región> Volumen)

I've tried using the sum(aggr(sum [PDM x Región 2] , Región, Gerencia)) and doesn't work

Can anyone help me, please

Thanks a lot

swuehl — Wed, 16 Jan 2013 00:18:23 GMT

Hi BR,

if [PDM X Cemento] is a field name, try

sum(aggr( [PDM X Cemento]* Sum(Volumen)/Sum( DISTINCT TOTAL <Región> Volumen), Región, Gerencia))

Wed, 16 Jan 2013 00:34:20 GMT

You R a Genius!!! Thanx