topic Re: How to create Random number within specific range in Qlikview/Qliksense in script ? in QlikView

How to create Random number within specific range in Qlikview/Qliksense in script ?

Fri, 20 Nov 2020 18:02:30 GMT

Hi,

How can we create random number between specific range.

Let us suppose we need to generate random no. between 0.85 to 1.05, how can we do it ?

Thanks in advance.

petter — Sun, 03 May 2015 07:08:18 GMT

[TenRandomNumbers]:

LOAD

Rand() * (1.05-0.85 ) + 0.85 AS myRandomNumber

AUTOGENERATE

10;

If you need it to include 1.05 exactly then add a Round()-function like this

Round( Rand() * (1.05-0.85 ) + 0.85 , 0.01) AS myRandomNumber

Sun, 03 May 2015 07:18:14 GMT

Thanks a lot, it worked.