Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
shane_spencer
Valued Contributor

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.

Tags (1)
1 Solution

Accepted Solutions
Partner
Partner

Re: Autogenerate numbers between 2 values

Hi,

Load

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

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

;

1 Reply
Partner
Partner

Re: Autogenerate numbers between 2 values

Hi,

Load

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

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

;