How to filter the latest time in Qlik sense

[aminqlik]

Hello:

   Need your help. I have initial QVD file format as below shows.

But I would like to get the output QVD file that only show the latest 'D Time' by 'Pdn name'.

Expected result:

Thanks your help.....

[rubenmarin · Accepted solution]

Hi, load incial qvd and do an inner join with the max date for each pdn to keep only those files, somewhat like:

Data:
LOAD * From [Path\qvdname.qvd](qvd);

Inner Join (Data)
LOAD [Pdn name],
  max([D Time) as [D Time]
resident Data
Group By [Pdn name];

Store Data into ReducedQvdName.qvd(qvd);

[aminqlik]

Hi Rubenmarin:

      Thank you very much for solution. 

Regards,

aminqlik