Need quantity per product for latest (Max(DelDate)) delivery but Aggr gives results only for first Row (despite Nodistinct)

[desertmatt]

Hello All,

need your help please.

Checked already all relevant posts here for similar issues (also HICs guidelines on Aggr etc.) but can't get this to work 😞

I just need the total quantities for each product for the latest delivery date

Data Excel and qvw attached - would appreciate if somebody could point me in the right direction please.

Thank you very much

Matt

[desertmatt · Accepted solution]

Ok All good - I kept searching and found this solution from Sunny:

https://community.qlik.com/t5/QlikView-App-Dev/Sum-of-multiple-values-per-max-aggr-date/td-p/1547742

which I converted to this:

=Sum(Aggr(if(DelDate= Max(TOTAL <Product> DelDate),Sum (Pcs)),Product,DelDate))

Thank you all who looked at this