topic Re: Autogenerate Random Numbers in QlikView

Autogenerate Random Numbers

siddheshmane — Thu, 02 Apr 2015 09:48:27 GMT

Hi,

I want to generate a list of Random Numbers that are Whole numbers and less than 50. I tried creating numbers but I always get a decimal number.

Can anyone tell me how can I obtain this result?

Thanks.

Re: Autogenerate Random Numbers

Anonymous — Thu, 02 Apr 2015 09:51:00 GMT

Multiply the decimal by 50 and then round it.

Re: Autogenerate Random Numbers

pokassov — Thu, 02 Apr 2015 09:55:49 GMT

Hi!

t1:

Load RecNo( ) as A, round(50*rand( ),1) as B autogenerate(50);

Re: Autogenerate Random Numbers

sunny_talwar — Thu, 02 Apr 2015 09:58:36 GMT

May be this:

LOAD Round(Rand() * 49) as RandNum

AutoGenerate 50;

Best,

Sunny

Re: Autogenerate Random Numbers

siddheshmane — Thu, 02 Apr 2015 10:05:35 GMT

Hi,

Thanks, It worked. I also understood the concept very well.

Thanks.

Re: Autogenerate Random Numbers

rubenmarin — Thu, 02 Apr 2015 10:22:39 GMT

Cepren solution is good one, but if you need equal probabilities between numbers, and from 1 to 50 you should use something a bit different (i generate 500000 to see the difference):

t1:

Load RecNo( ) as A, round(50*rand( ),1, 0.5)+0.5 as B autogenerate(500000);

If you don't add the offset the first and the last number has half the probabilities than other numbers:

I'm a bit idle today

Re: Autogenerate Random Numbers

siddheshmane — Thu, 02 Apr 2015 10:30:36 GMT

Hehe.. thanks for explaining the offset part.. I didn't know that.