topic Problem with total/Aggr in QlikView

Problem with total/Aggr

Wed, 25 Nov 2020 16:16:04 GMT

Hi !

I'm having some trouble with my calculation. See the exemple below :

It's calculated this way :

[NbPlaces]/([NbRelevés]/[NbRue])=[TotalPlaces]

([NbRelevés]/[NbRue]) = [Coeff] by the way

The problem is that the total shouldn't be like it is right there. For 2014, [TotalPlaces] should be :

951+2552+842= 4345 and not 127 247/(9065/283).

What's the way to do that ?

Thanks you very much in advance.

Antonin

Ce message a été modifié par : Antonin Ramet

sunny_talwar — Mon, 04 Jul 2016 13:37:36 GMT

Would you be able to share a sample to look at?

vinieme12 — Mon, 04 Jul 2016 14:41:19 GMT

Hi ,

Aggregate your calculations by Zone as below.

example for nb places / nb releve

sum(aggr(sum({<flag_place={'OK'}>}Nb_places)/(count(ID_Date)/count(distinct Impl_compl)) / count({<flag_montant={'OK'}>}DISTINCT ID_Date),Zone))

Encapsulate your calculations between this

SUM( AGGR ( yourcalculation , ZONE) )

Cheers

Mon, 04 Jul 2016 14:50:05 GMT

You can find an exemple attached to the first post!

sunny_talwar — Mon, 04 Jul 2016 20:38:38 GMT

May be this as your expression:

=If($(=GetCurrentField(Géographie)) = 'Rue',

Sum(

Aggr(

Sum({<flag_place={'OK'}>}Nb_places)/(Count(ID_Date)/Count(DISTINCT Impl_compl)),

$(='[' & GetCurrentField([Géographie]) & ']'), Impl_compl, $(='[' & GetCurrentField([Temps]) & ']'))),

Sum(

Aggr(

Sum({<flag_place={'OK'}>}Nb_places)/(Count(ID_Date)/Count(DISTINCT Impl_compl)),

$(='[' & GetCurrentField([Géographie]) & ']'), $(='[' & GetCurrentField([Temps]) & ']'))))

tyagishaila — Tue, 05 Jul 2016 04:15:06 GMT

Go to expression TAB --> Total Mode -->Click on 3rd option and select Sum of Rows

Tue, 05 Jul 2016 07:52:58 GMT

This works like a charm, thanks !!