Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
lalitkgehlot89
Partner - Creator II
Partner - 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;

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
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