Create Random Negative and Positive Values

[alec1982]

hi,

Need to create random values -15% to +25% of sales Column, Anyone knows how?

[Anonymous]

Please try the 'rand()' function. Below is an example from Qlik help.

rand( )

Example:

This example script creates a table of 1000 records with randomly selected upper case characters, that is, characters in the range 65 to 91 (65+26).

Load Chr( Floor(rand() * 26) + 65) as UCaseChar, RecNo() as ID Autogenerate 1000;

[nagaiank · Accepted solution]

rand()*40-15

[fkeuroglian]

Hi, use the rand() function

Fernando K.