Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
shane_spencer
Specialist
Specialist

Autogenerate numbers between 2 values

Hi folks,

I need to generate field / table with sequential numbers from X to Y (where X and Y are two variables such as X=666 and Y=2121) .

What's the easiest way to do this?

My end goal is to join another table to this so I can easily see where a record is missing, as I'll have data with records from 666 to 2121 for example but some will be missing... by joining the two I'll be easily able to filter the "missing" records so I can go away and look as to why they are not there.

1 Solution

Accepted Solutions
Aurelien_Martinez
Partner - Specialist II
Partner - Specialist II

Hi,

Load

  RecNo() + $(X) -1 as field

AutoGenerate ($(Y) - $(X) +1)

;

Help users find answers! Don't forget to mark a solution that worked for you!

View solution in original post

1 Reply
Aurelien_Martinez
Partner - Specialist II
Partner - Specialist II

Hi,

Load

  RecNo() + $(X) -1 as field

AutoGenerate ($(Y) - $(X) +1)

;

Help users find answers! Don't forget to mark a solution that worked for you!