choose a rendom rows but less then expected

Thu, 02 Jul 2015 09:27:18 GMT

Hi ,

I attached the example I have , using with this calculation :

='('&Concat(ceil(RAND()*$(vRowNum)),'|', ValueLoop(1,$(X)))&')'

if X = 10 then it will show me on the table the random 10 rows.

the problem is that there are collisions in value generation, sometimes it choose me only 9 rows.

how do I make sure he will choose me exactly 10 random row not more or less, and on each choose the rows data will be different.

thanks,

Moni

Re: choose a rendom rows but less then expected

Gysbert_Wassenaar — Thu, 02 Jul 2015 16:50:39 GMT

Qlikview doesn't have a function for that. Perhaps you can use a site like random.org. The url below will return a comma separated series of 10 random non-repeating numbers between 1 and 100

https://www.random.org/integer-sets/?sets=1&num=10&min=1&max=100&seqnos=on&commas=on&sort=on&order=index&format=plain&rn…

topic choose a rendom rows but less then expected in QlikView

choose a rendom rows but less then expected

Re: choose a rendom rows but less then expected