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 numbers given periods

Dear All,

I have two range start and end , I need to generate numbers between that given range.

example: start : 5 and end :10

generate numbers : 5,6,7,8,9,10

Please suggest any function for generation above numbers.

Thanks & Regards,

Aruensh Kumar

1 Reply
Not applicable
Author

Hi,

try something like this:

Load

5 + RecNo() -1 as numbers

Autogenerate (6);

As a second step us variables.

Let vStart = 5;

Let vEnd = 10;

Let vSteps = $(vEnd) - $(vStart) +1;

Load

$(vStart) + RecNo() -1 as numbers

Autogenerate $(vSteps);

Good luck!

Rainer