Discussion Board for collaboration related to Creating Analytics for QlikView.
I've encountered one problem when trying to use aggr() function. As shown in the attached, my expression for current product name doesn't seems to work.
Only (IF(Date(aggr(NODISTINCT MAX(Date),Channel,Country))=Date(Date),Name))
Instead of having "-", i would like my result to look like this (please see highlighted cells).This column will reflect my latest product name based on the latest date, group by channel (A/B):
Please advise. Appreciate your help on this
Go to Solution.
You can use these expressions:
date(max(total <Channel,Country> Date),'DD/MM/YYYY')
FirstSortedValue(total <Country,Channel> Name, -Date)
See attached qvw
It works! Thank you so much for your help!!!!