Discussion board where members can get started with QlikView.
Please provide the logic to generate numbers from 50.00 to 99.99.
for i=5000 to 9999
adapt it to your need
Hi you can use rand() function it gives random values between 0 and 1.
You can write
to generate random numbers ?
if so :
50 + rand()*50
50000+RECNO() AS Nr
What purpose you used this? May be like
LOAD Num(RowNo() + 49.00,'##.00') as Field
That depends on your number step. Try the below code where you can even set your step:
(RowNo()-1)*$(vStep)+50 as Num