topic peek function? in QlikView

peek function?

Thu, 13 Feb 2014 16:44:25 GMT

Load Field, Value,

A1, 12

B1, 13

C1 14

how can i use the peek function to get the value for c1 even if i move c1 up to the first row in the data sheet..

Thu, 13 Feb 2014 16:47:43 GMT

Not sure why we need to use Peek() here. Once the table is reloaded C1 will always be associated with 14. Maybe you can elaborate a little.

Thanks

Nicole-Smith — Thu, 13 Feb 2014 16:47:47 GMT

You'll want to use the lookup() function instead:

lookup('Value', 'Field', 'C1', 'TableName')

vikasmahajan — Fri, 14 Feb 2014 09:30:29 GMT

PFA sample with data.

Vikas

Sokkorn — Fri, 14 Feb 2014 09:39:15 GMT

Hi,

Alter load script, you can try in text object with this expression =Only({<Field = {'C1'}>} Value)

Regards,

Sokkorn