topic Selecting 'Last' Record in QlikView

Selecting 'Last' Record

Dayna — Fri, 11 Dec 2009 19:42:10 GMT

Hello,

How do you select the 'Last' record, as in the most recent one according to a date?

Kind Regards,

Dayna

Selecting 'Last' Record

Fri, 11 Dec 2009 19:50:54 GMT

Not quite sure what you mean but there are functions such as 'previous' that might suit. You could also work out the most recent date in the script using max in the load statement:

Load [Contract No],
date(max([Last Income])) as [Last Income]
resident [tLast Income]
group by [Contract No];

Regards,

Gordon

Selecting 'Last' Record

Dayna — Fri, 11 Dec 2009 20:08:18 GMT

Hello,

What I am trying to achieve, is within a gauge chart, show the last record in the system. So all my records have a date, but not all nessessary are from yesterday, or a week ago, the recent one might from a year ago... But I want to pick the most 'recent' record, just not sure how to go about it.

Kind Regards,
Dayna