topic Total expression not working in QlikView

Total expression not working

pcservicios — Tue, 17 Aug 2021 10:33:00 GMT

Hi.

I've a little problem calculating the total of a straight table.

The expression is

=sum(aggr(Estancias/Trabajadores,Departamento))

But the Total row is not as expected.

I upload a example in .qvw file

The expected total is 200/33 = 6.06

Thaks for your help

Re: Total expression not working

stevejoyce — Tue, 17 Aug 2021 11:51:38 GMT

I can't access your qvw, but your calculation would be first dividing Estancias/Trabajadores for each Departamento, and then summing your percents. I can't tell if you actully need aggr, but im guessing you want to do something like...

=sum(aggr(sum(Estancias)/sum(Trabajadores),Departamento))

Re: Total expression not working

Taoufiq_Zarra — Tue, 17 Aug 2021 12:22:03 GMT

@pcservicios or you can change your measure like

attached qvw file

Re: Total expression not working

pcservicios — Wed, 18 Aug 2021 07:56:06 GMT

Thanks Taoufiq for your help!

Re: Total expression not working

pcservicios — Wed, 18 Aug 2021 07:56:39 GMT

Thanks for your help, but this not work for me 😞