topic Re: MAX Date in QlikView

MAX Date

dseelam — Wed, 15 Feb 2017 16:42:25 GMT

hello all,

I don't know how to put this in to question, please check the attachments first

results needed in QVW - I want to see only one A in the column test with max date as 1/2/2017

thanks,

sunny_talwar — Wed, 15 Feb 2017 16:46:16 GMT

Try this:

test:

LOAD test,

[receipt date],

sales

FROM

[TEST*.xlsx]

(ooxml, embedded labels, table is Sheet1);

Right Join (test)

load test,

Max([receipt date]) as [receipt date]

Resident test

Group By test;

dseelam — Wed, 15 Feb 2017 16:51:25 GMT

Sunny, thanks you for the reply

I just want to see max date on front end view, I don't want to avoid data coming in to data model bcoz I need history

sunny_talwar — Wed, 15 Feb 2017 16:53:43 GMT

Then use a left join with a flag