topic Generate Minus (-) and Positive (+) Numbers in QlikView

Generate Minus (-) and Positive (+) Numbers

Fri, 02 May 2014 09:06:17 GMT

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 — Fri, 02 May 2014 09:08:36 GMT

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

swuehl — Fri, 02 May 2014 09:10:20 GMT

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 — Fri, 02 May 2014 09:12:11 GMT

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

Fri, 02 May 2014 09:25:30 GMT

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

Fri, 02 May 2014 09:25:58 GMT

This works just brilliant, thank you so much James

swuehl — Fri, 02 May 2014 09:27:06 GMT

Maybe

LOAD

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

autogenerate 10000;

Fri, 02 May 2014 09:54:19 GMT

Perfect, thank you again