topic distinct value with max date in QlikView

distinct value with max date

Thu, 03 Sep 2015 21:31:31 GMT

Hi all,

I am trying to solve a problem. I have the following table.

Now, I would like to have only distinct serialnumbers with max date associated with them like shown below:

Any help is appreciated.

Thank you,

Parth

maxgro — Thu, 03 Sep 2015 21:45:07 GMT

in script

SET DateFormat='M/D/YYYY';

load * inline [

SerialNumber, Date

abcd,6/5/2014

efgh,7/15/2015

xyz,3/2/2013

pqr,4/16/2015

abcd,9/2/2015

xyz,5/15/2015

pqr,9/3/2015

];

inner Join (a)

load

SerialNumber, date(max(Date)) as Date

Resident a

Group By SerialNumber;

or if you want in chart

dimension SerialNumber

expression max(Date)

Fri, 04 Sep 2015 02:01:26 GMT

Thank you very much Massimo. This helped me.

Have a good one

Regards,

Parth