topic Rand and Peek in QlikView

Rand and Peek

qlikviewwizard — Thu, 09 Apr 2015 08:50:25 GMT

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 — Thu, 09 Apr 2015 08:55:06 GMT

Hi!

It's selection random CustomerID

First expression selects random row in customer

Second expression selects CustomerID for selected row above

jsanchezh — Thu, 09 Apr 2015 09:06:25 GMT

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