5,10,15 .....100 create this field in qlik

[stonecold111]

5,10,15 .....100 create this field in qlik

i wanna create a field which these numbers in qlik any suggestions.

[tresesco]

Try like:

Let vOffset=0;
Let vInterval=5;
Let vLastValue=100;

Load
	$(vOffset)+RowNo()*$(vInterval) as Num
AutoGenerate ceil(vLastValue/vInterval);	

[stonecold111 · Accepted solution]

for t=5 to 100 step 5
load $(t) as number
AutoGenerate 1
while $(t)+ IterNo()-1<=100;
next t

i figured it myself

[stonecold111]

thanks. but we don't need vOffset here.

[bramkn]

can also do something like:
BASE:
LOAD * INLINE [
number
5
];

Table:
LOAD
5*rowno() AS Nmbr
FROM BASE WHILE
Rowno()<100;