Discussion Board for collaboration related to QlikView App Development.
I have data where a small number of rows can be duplicates except for 1 date field. In these instances, I only want to load the row with the max date. There are other columns in the data, but essentially I'm after the result below.
date(max([ Expiry Date])) as [ Expiry Date]
group by ID;
View solution in original post
WHERE ID <> Previous(ID)
ORDER BY ID, [Expiry Date] DESC
DROP TABLE SourceTable;
Thanks. I used a variation of this
Thanks. I went ahead with the first reply, but I did play around with this and it worked. It's a new technique to me that I may use in the future.