topic Re: Create table with last 12 months from today()? in QlikView

Create table with last 12 months from today()?

Wed, 26 Sep 2012 14:49:51 GMT

Hello,

I have been searching for some way to do this for a while now, but nothing has come up exactly this way...

In my QVW, I basically need to create a separate table where I can have the last 12 months from a date variable I store in the document...

varMyDate = 9/26/2012

RollingCalendar:

9/1/2012

8/1/2012

7/1/2012

6/1/2012

5/1/2012

4/1/2012

3/1/2012

2/1/2012

1/1/2012

12/1/2011

11/1/2011

10/1/2011

It is OK if I need to do this in the load script.. I just cannot figure out how this can be done. Initially it seemed like an inline load would work, but that uses literal values so I cannot use Date functions.

Re: Create table with last 12 months from today()?

whiteline — Wed, 26 Sep 2012 14:58:20 GMT

Hi.

Just two words can help you: autogenerate and rowno()

The first one allows to generate you a tabel with a number of rows, the second gives you the number of current row.

Re: Create table with last 12 months from today()?

swarup_malli — Wed, 26 Sep 2012 16:02:26 GMT

Hi,

Try this link, download the cookbook by Rob wunderlich,

http://robwunderlich.com/downloads/

It has code for creating a master calender.