topic Re: Max date & min date in QlikView

Max date & min date

Anonymous — Wed, 17 Sep 2014 04:13:22 GMT

Hi Qlickers,

I have a doubt on max & min date

My data is like

ID	Date
4073	25-07-2013
4073	03-04-2014
4073	01-08-2014
17	14-04-2012
17	13-04-2014
17	01-08-2012

from this data I want to find the min & max date based on the ID

Ex:

case 1:

when I select the ID as 4073 ,min date:25-07-2013 ,Max date:01-08-2014

please help me .........

Re: Max date & min date

Wed, 17 Sep 2014 04:18:12 GMT

load

ID,

max(Date) as maxdate,

min(Date) as minDate

From tablename

group by ID;

Re: Max date & min date

PrashantSangle — Wed, 17 Sep 2014 04:20:48 GMT

Hi,

Try it in script

Load max(date) as maxDate

min(date) as minDate,

From tableName

Group By ID;

Regards

Re: Max date & min date

Wed, 17 Sep 2014 04:24:11 GMT

Tab1:

LOAD * INLINE [

ID, Date

4073, 25-07-2013

4073, 03-04-2014

4073, 01-08-2014

17, 14-04-2012

17, 13-04-2014

17, 01-08-2012

];

LOAD

ID,

max(date(date#(Date,'DD-MM-YYYY'),'DD-MM-YYYY')) as maxdate,

min(date(date#(Date,'DD-MM-YYYY'),'DD-MM-YYYY')) as mindate

Resident Tab1

Group By ID;

DROP Table Tab1;

Re: Max date & min date

Wed, 17 Sep 2014 04:29:14 GMT

you can also try according to this

LOAD

ID,

FirstSortedValue(date(date#(Date,'DD-MM-YYYY'),'DD-MM-YYYY'),-date(date#(Date,'DD-MM-YYYY'),'DD-MM-YYYY')) as maxdate,

FirstSortedValue(date(date#(Date,'DD-MM-YYYY'),'DD-MM-YYYY'),date(date#(Date,'DD-MM-YYYY'),'DD-MM-YYYY')) as mindate

Group by ID;

Tab1:

LOAD * INLINE [

ID, Date

4073, 25-07-2013

4073, 03-04-2014

4073, 01-08-2014

17, 14-04-2012

17, 13-04-2014

17, 01-08-2012

];

Re: Max date & min date

anbu1984 — Wed, 17 Sep 2014 05:43:47 GMT

Check this

Re: Max date & min date

Anonymous — Wed, 17 Sep 2014 06:52:43 GMT

Hi All,

Thanks for your valuable replies.........