topic Re: Rand Function in QlikView

Rand Function

fkeuroglian — Fri, 08 Aug 2014 00:22:23 GMT

Hi, experts, i would like to know if there is a way to use the rand function but i pass the posible value, not only 1 or 0

i want to create random data but i provide the possible numbers, only create rando using that list of numbers

thank you a lot

Fernando

Re: Rand Function

rwunderlich — Fri, 08 Aug 2014 00:32:37 GMT

Rand() only returns a numbers between 0 and 1. You can use the result of rand to select from a list of numbers using various arithmetic and rounding operations. Some examples:

=ceil(rand()*1000,100) // Generate a number between 100 and 1000 in multiples of 100

=pick(ceil(rand()*5), '12', '15', '27', '3', '44') // Picks randomly from these 5 values.

-Rob

Re: Rand Function

simenkg — Fri, 08 Aug 2014 00:35:30 GMT

I suppose you can do something like this.

mapNumbers:

mapping load * inline [

ID, Number

1, 3333

2, 5555

3, 1337

4, 5433

5, 11

6, 5432

7, 1223

8, 332

];

let vNoOfNumbers = NoOfRows('MapNumbers');

Fact:

load
applymap('mapNumbers',ceil(rand()*'$(vNoOfNumbers)'),null()) as RandomSelectedNumber

From

If you want to read the possible numbers from a file you would do:

mapNumbers:

mapping load rowno() as ID, Number from File.