topic Re: Aggregation with sum and max? in QlikView

Aggregation with sum and max?

olramirez — Wed, 01 Aug 2018 16:02:42 GMT

Hello,

i have a report with a variable for expression but the final total is wrong.

Send my report, the final total should be 170,633,792 but this is 2,265,797,212 !!

Please help me.

Olga

sunny_talwar — Wed, 01 Aug 2018 16:09:31 GMT

Change your variable to this

Sum(Aggr(IF(Max({$<Año=, Mes=, MonthYear={'$(=max(MonthYear))'}>}Precio)=0,

sum(Aggr(Max({$<Año=, Mes=, MonthYear={'$(=max(MonthYear))'}>}Valor),IdFolio)),

Sum({$<Año=, Mes=, MonthYear={'$(=max(MonthYear))'}>}Valor)

), Centro, IdFolio, %FECHA, %ID_ARTICULO))

olramirez — Wed, 01 Aug 2018 16:18:29 GMT

Thanks Sunny