topic Help me to get the latest records in script level. in QlikView

Help me to get the latest records in script level.

durgabhavani — Tue, 10 Jul 2018 14:20:03 GMT

Hi All,

Please help me to get the latest record by writing the code in script level.

Sample data:

Expected output:

Please advice.

Thanks,

Durga

marcelviegas — Tue, 10 Jul 2018 14:34:29 GMT

table_Sanple:

load

CUSTID,DATE,DESC,CUSTID&'|'&DATE as key

from table;

inner join

load CUSTID&'|'&max(DATE) as key

resident table_Sanple

group by CUSTID:

mayankraoka — Tue, 10 Jul 2018 15:30:15 GMT

Hi,

Check attached QVW for solution

Regards,

Mayank