choose a rendom rows but less then expected

[#1]

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

[Gysbert_Wassenaar]

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=i...