topic Aggr(NODISTINCT) Function Help in QlikView

Aggr(NODISTINCT) Function Help

riceball — Wed, 10 Apr 2013 09:29:29 GMT

Hi,

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

Re: Aggr(NODISTINCT) Function Help

Gysbert_Wassenaar — Fri, 12 Apr 2013 11:20:49 GMT

You can use these expressions:

date(max(total <Channel,Country> Date),'DD/MM/YYYY')

FirstSortedValue(total <Country,Channel> Name, -Date)

See attached qvw

Re: Aggr(NODISTINCT) Function Help

riceball — Mon, 15 Apr 2013 01:26:13 GMT

It works! Thank you so much for your help!!!!