topic Re: Autogenerate numbers between 2 values in QlikView https://community.qlik.com/t5/QlikView/Autogenerate-numbers-between-2-values/m-p/95252#M15291 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Load</P><P>&nbsp; RecNo() + $(X) -1 as field</P><P>AutoGenerate ($(Y) - $(X) +1)</P><P>;</P></BODY></HTML> Wed, 31 Oct 2018 11:18:05 GMT Aurelien_Martinez 2018-10-31T11:18:05Z Autogenerate numbers between 2 values https://community.qlik.com/t5/QlikView/Autogenerate-numbers-between-2-values/m-p/95251#M15290 <HTML><HEAD></HEAD><BODY><P>Hi folks, </P><P></P><P>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) .</P><P></P><P>What's the easiest way to do this?</P><P></P><P></P><P>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.</P></BODY></HTML> Wed, 31 Oct 2018 11:10:44 GMT https://community.qlik.com/t5/QlikView/Autogenerate-numbers-between-2-values/m-p/95251#M15290 shane_spencer 2018-10-31T11:10:44Z Re: Autogenerate numbers between 2 values https://community.qlik.com/t5/QlikView/Autogenerate-numbers-between-2-values/m-p/95252#M15291 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Load</P><P>&nbsp; RecNo() + $(X) -1 as field</P><P>AutoGenerate ($(Y) - $(X) +1)</P><P>;</P></BODY></HTML> Wed, 31 Oct 2018 11:18:05 GMT https://community.qlik.com/t5/QlikView/Autogenerate-numbers-between-2-values/m-p/95252#M15291 Aurelien_Martinez 2018-10-31T11:18:05Z