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

Announcements
Posting on Qlik Community is temporarily paused for some users. Thank you for patience and we'll update you soon!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

For Loop and Autogenerate

Hello guys,

I have a column with value as 12 . So I want to this value to be  injected every month upto 4 months .

So basically i need to auto generate value 12 four times. And create a For loop for 36 months . 

 

M1M2M3M4M5
F3F3F3F3F3
M1        12.67         12.67         12.67         12.67
M2        12.67         12.67         12.67         12.67
M3        12.67         12.67         12.67
…
M36

//  For loop for 1 to 36 months


Data1:

Load

'12' as Value

           AutoGenerate 4;

  Next i

I need something like this . Could u please rectify my script.

I need to plot this in a line chart . Kindly let me know how do I do this .

Thanks,

Ravi

0 Replies