topic Re: Differences Rangesum Above in QlikView

Differences Rangesum Above

Anonymous — Wed, 26 Jul 2017 14:27:36 GMT

Hi guys,

I have a query, I have 2 qvw files that have the same formula (cumulative sums) and but in one it comes out correctly, and in the other it comes out differently I have searched the root of the problem even ordering my table for the accumulated sum But still goes wrong. I hope you can help me.

Thank you so much.

Correct graphic:

Incorrect graphic:

Re: Differences Rangesum Above

sunny_talwar — Wed, 26 Jul 2017 15:16:07 GMT

I think the problem here is the sort order of Fecha EM... If you have QV12, you can use this

=fabs(sum({<[MSEG.Clase de movimiento_BWART]={'201','221','261'}>} num(MSEG.Cantidad_MENGE)))

avg(

aggr(

rangesum( above( sum({$<[Año EM],[Mes EM]>} num(MSEG.Cantidad_MENGE)),0,RowNo())),

[Material EM],([Fecha EM], (NUMERIC))

)

or you will have to fix the load order in the script to make this work

Re: Differences Rangesum Above

Anonymous — Wed, 26 Jul 2017 15:40:50 GMT

Thank you so much!!