topic Re: Generate random value in QlikView

Generate random value

francoiscave — Wed, 14 Jan 2015 16:33:15 GMT

Hi community,

I want to use the rand() function to generate some value at random between 0 and 255.

How can I do that ?

François

alexandros17 — Wed, 14 Jan 2015 16:38:09 GMT

try with

=Floor(rand()*255)

let me know

Colin-Albert — Wed, 14 Jan 2015 16:38:10 GMT

FLOOR(RAND() * 255)

Anonymous — Wed, 14 Jan 2015 16:38:53 GMT

Try something like this:
ceil(rand()*255)

consenit — Wed, 14 Jan 2015 16:40:27 GMT

Hi there.

Try:

TEST:

LOAD FLOOR(Rand()*256) as RandomValue autogenerate 1000;

Kind regards,

Ernesto.

MarcoWedel — Wed, 14 Jan 2015 16:42:20 GMT

actually it's

Floor(Rand()*256)

hope this helps

regards

Marco

MarcoWedel — Wed, 14 Jan 2015 16:45:55 GMT

Ceil(Rand()*n)

delivers values from 1 to n, while

Floor(Rand()*n)

delivers values from 0 to n-1.

hope this helps

regards

Marco

marchoctober — Wed, 14 Jan 2015 16:46:01 GMT

Hi!

Go to Ctnrl+E, there Insert > Test Script.

It generates very interesting things, so using it logic you could adopt for your solution.