Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Generate table of dates

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

1 Solution

Accepted Solutions
tamilarasu
Champion
Champion

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

View solution in original post

3 Replies
tamilarasu
Champion
Champion

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

Not applicable
Author

thank you !

tamilarasu
Champion
Champion

You are welcome .