Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

LATEST DATE

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.

3 Replies
alexpanjhc
Specialist
Specialist

load max(date)

resident yourtable

Not applicable
Author

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.

alexpanjhc
Specialist
Specialist

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;