Rand and Peek

[qlikviewwizard]

Hi All,

Please help to explain the two expressions.

Let vRnd = Floor(Rand() * $(vCustCount));   //( vCustCount=FieldValueCount('CustomerID');)
Let vCID = Peek('CustomerID', $(vRnd), 'Customer');

CustomerID:

1001

1002

1003

1004

1005

1006

1007

Thanks in advance.

[pokassov · Accepted solution]

Hi!

It's selection random CustomerID

First expression selects random row in customer

Second expression selects CustomerID for selected row above

[jsanchezh]

The first expression selects a row number from the CustomerID field and the second one selects a CustomerID based on the row number calculated before

Greetings