Generate Minus (-) and Positive (+) Numbers

[#1]

Hi Qlik Community Members,

I have to say, i'm really starting to enjoy myself in this new found world of QlikView Goodness!!

I'm still getting used to a lot of the tools and functions coming from a SAS background there is a lot to learn, especially terminology wise.

my issue:

I need to generate a table from my main table that has a £ value number next to it from as much as -£1200 to £500

is this possible?

I Cant seem to find a RANDBETWEEN function like in excel

thanks

[MK_QSL]

You mean to say you want to generate these numbers randomly?

[swuehl · Accepted solution]

RAND() will return a floating point random number between 0 and 1, so just scale the number:

LOAD

     money(round(RAND()*1700,0.01)-1200) AS Amount

Autogenerate 10000;

[ThornOfCrowns]

Try: =-1200+(Rand()*1700)

[#5]

Brilliant answers thank you all.

so on the back of that, whats the logic behind creating random permutations of a letter, Y or N?

again, thanks

[#6]

This works just brilliant, thank you so much James

[swuehl]

Maybe

LOAD

     if(RAND() <=0.5,'Y','N') as RandomLetter

autogenerate 10000;

[#8]

Perfect, thank you again