topic Re: LATEST DATE in QlikView

LATEST DATE

Fri, 31 May 2013 14:02:22 GMT

I've got a spreadsheet, that is records that are dated with a status and am looking for the most recent dated record to be in a display.

What is the best way to select that in the desktop version of the product?

I'm using the free download version of the product to evaluate it so, I've only done the free online training.

Any help is greatly appreciated.

Re: LATEST DATE

alexpanjhc — Fri, 31 May 2013 15:20:00 GMT

load max(date)

resident yourtable

Re: LATEST DATE

Fri, 31 May 2013 15:31:35 GMT

I want to have the other rows load so I can do trending on the data too. So I need some method for screening when I produce a chart. The latest date represents the most current status, the other rows (records) represent history for trending and point in time type analysis.

Re: LATEST DATE

alexpanjhc — Fri, 31 May 2013 16:07:34 GMT

you can load as many times as you want. You can load the entire table and/or only the max date

tablemaxdate:

load max(date)

from yourtable;

Maintable:

load * from yourtable;