Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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;
You mean to say you want to generate these numbers randomly?
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;
Try: =-1200+(Rand()*1700)
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
This works just brilliant, thank you so much James
Maybe
LOAD
if(RAND() <=0.5,'Y','N') as RandomLetter
autogenerate 10000;
Perfect, thank you again