topic Generating a inline table with last date of each month of a year in QlikView

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

Fri, 28 Jun 2013 07:56:54 GMT

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

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

stephencredmond — Fri, 28 Jun 2013 09:17:39 GMT

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

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

Mon, 01 Jul 2013 06:11:00 GMT

Just what i needed Thanks a lot !