topic Re: generate a table of dates in QlikView

generate a table of dates

ali_hijazi — Fri, 20 May 2011 12:05:49 GMT

Hello

I want to generate a table of dates that start from today and goes back until the first date of a year specified by number of years to go back

this number is to be taken from an input box on a sheet

thank you

erichshiino — Fri, 20 May 2011 12:32:41 GMT

Hi,

I used the following script:

Table:

load date( makedate($(vStartYear))+rowno()-1) as Date

AutoGenerate( today()-makedate($(vStartYear))) ;

vStartYear is a variable available on an input box.

You can also check the attachment.

Hope it helps,

Erich

kaushiknsolanki — Fri, 20 May 2011 12:32:52 GMT

HI,

I am here by uploading an example.

I hope this is what you are looking.

Regards,

Kaushik Solanki