topic Re: Finding oldest date in script in QlikView

Finding oldest date in script

Fri, 25 May 2012 09:26:30 GMT

Hi,

I have three different fields I have loaded in the script, with each field containing only one date:

Dates:

Date1,

Date2,

Date3

How can I find the the oldest of these dates in the script?

giakoum — Fri, 25 May 2012 09:37:28 GMT

concatenate the 3 fields into one table and field and then :

[test]:

LOAD * INLINE [

2012/05/20

2012/05/10

2012/05/05

];

[test1]:

first 1 LOAD

F1 as F2

Resident [test]

Order By F1 asc;

F2 is your answer