Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
lalitkgehlot89
Creator II
Creator II

Logic to generate number from 50.00 to 99.99.

Hi,

Please provide the logic to generate numbers from 50.00 to 99.99.

6 Replies
olivierrobin
Specialist III
Specialist III

hello

something like

for i=5000 to 9999

let nb=i/100;

next i

adapt it to your need

devyanshu_gupta
Partner - Contributor III
Partner - Contributor III

Hi you can use rand() function it gives random values between 0 and 1.

You can write    

50+Rand()*50


Regards,

Devyanshu

ogautier62
Specialist II
Specialist II

Hi,

to generate random numbers ?

if so :

50 + rand()*50

regards

avkeep01
Partner - Specialist
Partner - Specialist

LOAD

50000+RECNO() AS Nr

AutoGenerate(10000-5000);

Anil_Babu_Samineni

What purpose you used this? May be like

LOAD Num(RowNo() + 49.00,'##.00') as Field

AutoGenerate 50;

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
tresesco
MVP
MVP

That depends on your number step. Try the below code where you can even set your step:

Let vStep=0.1;

Load

       (RowNo()-1)*$(vStep)+50 as Num

AutoGenerate (99.99-50)/$(vStep);

Capture.JPG