Skip to main content
Announcements
Save $600 on Qlik Connect registration! Sign up by Dec. 6 to get an extra $100 off with code CYBERSAVE: REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Rand function.

Hi everyone, if someone were to answer this I'd be really grateful.

Is it possible to generate a limited range using the rand function?

I was thinking about something like this.

RAND() >= 0.75 AND <= 0.95

1 Solution

Accepted Solutions
christophebrault
Specialist
Specialist

hi,

try this expression :

=0.75+rand()/5

Inscrivez vous à ma Newletter Qlik
DoNotMissQlik- Connect with me on Linkedin

View solution in original post

4 Replies
christophebrault
Specialist
Specialist

hi,

try this expression :

=0.75+rand()/5

Inscrivez vous à ma Newletter Qlik
DoNotMissQlik- Connect with me on Linkedin
Not applicable
Author

Might I ask how you came up with your solution?

Not applicable
Author

I don't understaund that

Not applicable
Author

Rand generates a decimal out put between zero and one.

Dividing the range by 5 will mean the output will be between 0 and 0.20.

So overall range will be 0.75+0 to 0.75+0.20.