topic Generate table of dates in QlikView

Generate table of dates

Wed, 25 Nov 2020 16:16:04 GMT

Hello, i want create a table of Years and Months in the LOAD SCRIPT.

I think i can do like this :

LET NbMois = 12;
LET NumAnnée = 2030;

for i = 2008 to NumAnnée

An = i;
for y = 1 to NbMois

M = y;

Load * Inline [

Année, Mois

An,M

];

Please correct my syntax if it's wrong ( i think it is x) )

Thanks, have a nice day

Re: Generate table of dates

tamilarasu — Thu, 04 May 2017 08:28:53 GMT

Hi Alexandre,

Here is the corrected script. Have a good day!!

LET NbMois = 12;
LET NumAnnée = 2030;
for i = 2008 to NumAnnée
   Let An = i;
    for y = 1 to NbMois
     Let   M = y;
     Load * Inline [
     Année, Mois
     $(An),$(M)
     ];
    Next
Next

Re: Generate table of dates

Thu, 04 May 2017 08:30:06 GMT

thank you !

Re: Generate table of dates

tamilarasu — Thu, 04 May 2017 08:30:52 GMT

You are welcome .