Discussion board where members can get started with QlikView.
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.
Go to Solution.
Rand() * (1.05-0.85 ) + 0.85 AS myRandomNumber
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
View solution in original post
Thanks a lot, it worked.