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

[samsbor]

Hi,

How can we create random number between specific range.

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

Thanks in advance.

[samsbor]

Hi,

How can we create random number between specific range.

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

Thanks in advance.

[hic · Accepted solution]

100000 + Floor(900000*Rand())

[samsbor]

Thanks! It worked.