Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
5,10,15 .....100 create this field in qlik
i wanna create a field which these numbers in qlik any suggestions.
for t=5 to 100 step 5
load $(t) as number
AutoGenerate 1
while $(t)+ IterNo()-1<=100;
next t
i figured it myself
Try like:
Let vOffset=0; Let vInterval=5; Let vLastValue=100; Load $(vOffset)+RowNo()*$(vInterval) as Num AutoGenerate ceil(vLastValue/vInterval);
for t=5 to 100 step 5
load $(t) as number
AutoGenerate 1
while $(t)+ IterNo()-1<=100;
next t
i figured it myself