Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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