Generating a inline table with last date of each month of a year

[#1]

Hi,

I want to generate an inline table using qv script such that  the table contains     field  Year ,  Month, LastDayMonth,

here is an example

Year	Month	LastDayMonth
2012	Jan	31-01-2012
2012	Feb	29-02-2012
2012	Mar	31-03-2012
2012	Apr	30-03-2012
2012	May	31-03-2012
2012	Jun	30-03-2012
2012	Jul	31-03-2012
2012	Aug	30-03-2012
2012	Sep	31-03-2012
2012	Oct	30-03-2012
2012	Nov	31-03-2012
2012	Dec	31-03-2012

Year can be from 2000 till 2020

can anyone help me out with this.:)

Regards,

Tushar 

[stephencredmond · Accepted solution]

Hi,

I would do a loop like this:

For y=2000 to 2020
          For m=1 to 12
                    Calendar:
                    Load
                              $(y) As Year,
                              Dual(SubField('$(MonthNames)', ';', $(m)), $(m)) As Month,
                              Date(Floor(MonthEnd(MakeDate($(y), $(m))))) As MonthEndDate
                    AutoGenerate(1);
          Next
Next

Regards,

Stephen

Stephen Redmond is author of QlikView for Developer's Cookbook

He is CTO of CapricornVentis a QlikView Elite Partner. We are always looking for the right people to join our team.

Follow me on Twitter: @stephencredmond

[#3]

Just what i needed Thanks a lot !