topic Year between 2 dates in QlikView

Year between 2 dates

Thu, 28 Apr 2011 18:32:41 GMT

I have q requirement to find year between 2 dates

M:
LOAD * INLINE [
Document, StartDate, EndDate
350003428, 12/15/2005, 12/14/2011
];

I am exepecting to see the result

2005,2006,2007,2008,2009,2010,2011 for the Document 350003428

I tried

Yearstart(addyears((year(StartDate), IterNo()-1)) <= year(EndDate);

Advance thanks for your help.

Anonymous — Thu, 28 Apr 2011 20:09:46 GMT

[Docs]:

LOAD * INLINE [

Document, StartDate, EndDate

350003428, 12/15/2005, 12/14/2011

];

[NewDoc]:

Load Document,

year(StartDate) + IterNo() as Year

resident Docs

while IterNo() <= (year(EndDate) - year(StartDate));

New Straight Table:

In the expression use : concat(Year,',')

Anonymous — Thu, 28 Apr 2011 20:11:15 GMT

Example attached

Thu, 28 Apr 2011 21:04:02 GMT

Great help. . Thank you for quick update.