topic Re: max(month) by year in QlikView

max(month) by year

Thu, 16 May 2013 06:52:36 GMT

Hi,

I am trying to do a max month, by year.

but how can i do that in LOAD?

It should return only 2011 DEC and 2012 FEB.

sounds simple, but i'm stuck...

2011 MAR

2011 DEC

2012 JAN

2012 FEB

Thanks.

swuehl — Thu, 16 May 2013 07:10:35 GMT

NPUT:

LOAD Date#(FIELD,'YYYY MMM') as YearMonth INLINE [

FIELD

2011 MAR

2011 DEC

2012 JAN

2012 FEB

];

LOAD FirstValue(YearMonth) as MaxYearMonth

Resident INPUT

group by year(YearMonth)

order by YearMonth desc;

sushil353 — Thu, 16 May 2013 07:14:05 GMT

try this:

T1:

load * Inline

[

year,month

2011,MAR

2011,DEC

2012,JAN

2012,FEB

];

tab2:

LOAD

year,

max(date(date#(month,'MMM'),'MMM'))

Resident T1

Group By year;