Date when Quantity is max as Set Analysis with aggr or firstshortvalue

Near — Fri, 11 Feb 2022 12:04:55 GMT

i have an expression like this :

aggr(max(aggr(sum(NB_PLATEAUX),Date,UNITE)),UNITE)

And it's work : i have the max qty (NB_PLATEAUX) per day for the selection

Now i want the date when qty is max, with a set analysis but i don't know how write it...

Regards

Re: Date when Quantity is max as Set Analysis with aggr or firstshortvalue

rubenmarin — Sat, 12 Feb 2022 12:23:00 GMT

Hi,I haven't tested but maybe:

Concat(Date(Aggr(If(sum(NB_PLATEAUX)=aggr(max(aggr(sum(NB_PLATEAUX),Date,UNITE)),UNITE), Date)

,Date)))

Concat is only in case there are more than one date with max sales.

If doesnt works you can also test adding a TOTAL:

Concat(Date(Aggr(If(sum(NB_PLATEAUX)=aggr(max(TOTAL aggr(sum(NB_PLATEAUX),Date,UNITE)),UNITE), Date)

,Date)))