Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
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
amartinez35
Partner
Partner

Hi,

Load

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

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

;

View solution in original post

1 Reply
amartinez35
Partner
Partner

Hi,

Load

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

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

;

View solution in original post