topic Re: Peek giving me problems in QlikView

Peek giving me problems

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Currently trying to get the Peek function to update a null value in a table based on the same customer having a value on another line, as below, I thought the following code in script would work, but it is not updating it, so just wondering if I am missing anything.

The field name in the script of 'UserField3' is the field in the source database which I have changed the name to 'Their Comment' within the dimensions in Qlikview

Load

MasterID,
UserField3,

if(isnull(UserField3), peek(UserField3, - 1), 'UserField3'),
if(isnull(UserField3), peek(UserField3, 1), 'UserField3'),

Re: Peek giving me problems

sasiparupudi1 — Thu, 29 Mar 2018 14:32:44 GMT

Try like below

Load

MasterID,
UserField3,

if(Len(Trim((UserField3))=0, peek(UserField3), UserField3') AS MissingUserField3

Resident YourTable

Order By MasterID,UserField3

Re: Peek giving me problems

sunny_talwar — Thu, 29 Mar 2018 14:34:37 GMT

Or you doing order by statement? Also, advice you to check If MasterID = Previous(MasterID)...

Re: Peek giving me problems

olivierrobin — Thu, 29 Mar 2018 14:36:22 GMT

the syntax is :

Peek() finds the value of a field in a table for a row that has already been loaded or that exists in internal

Peek (fieldname [ , row [ , tablename ] ]

so for you,

peek(UserField3, - 1,table name)