Discussion Board for collaboration on QlikView Scripting.
I'm trying to fill up the null values with peek:
I need this table:
That is my script:
if(len(trim(New_Field)) = '0' and peek(Key) = Key, peek(New_Field),New_Field) as New_Field
order by Key, Timestamp;
The table I get is:
It's not working for all fields.
Can someone please help me?
Go to Solution.
If(Len(Trim(New_Field)) = '0' and Peek(Key) = Key, Peek('New_Field1'), New_Field) as New_Field1
Order By Key, Timestamp;
DROP Table Table;
DROP Field New_Field;
RENAME Field New_Field1 to New_Field;
That works perfect!
Thank you very much!