AGGR() on Only ()

sibrulotte — Wed, 01 Mar 2017 23:10:13 GMT

Hi,

I have this set analysis

=aggr((only({< Année = {'2016','2017'}, [Statut de la commande] -={'4'}>}[Quantité requise]) - only({< Année = {'2016','2017'}, [Statut de la commande] -={'4'}>}[Quantité reçue])) *

only({< Année = {'2016','2017'}, [Statut de la commande] -={'4'}>}[Prix unitaire réception]), Nom, [Description du bon de commande], ld)

Basically:

For a Supplier (Nom), that has an order (Description du bon de commande), there are items (ld).

For each item I want to substract what I have received to what I ordered, and multiply that by unit price.

I thought AGGR would return the sum for the supplyer. But that only works if there are item per order...

What should I be doing?

I don't want to rework the model right now.

Re: AGGR() on Only ()

sibrulotte — Wed, 01 Mar 2017 23:16:23 GMT

AH HELL NO...

I just added a sum in front to get what I wanted ... never mind...

topic Re: AGGR() on Only () in QlikView

AGGR() on Only ()

Re: AGGR() on Only ()