topic Qlikview - peek problems in QlikView

Qlikview - peek problems

alexandermllr — Tue, 05 Jun 2018 13:50:59 GMT

Hello,

I'm trying to fill up the null values with peek:

I need this table:

That is my script:

load

Key,

Timestamp,

if(len(trim(New_Field)) = '0' and peek(Key) = Key, peek(New_Field),New_Field) as New_Field

resident Table

order by Key, Timestamp;

The table I get is:

It's not working for all fields.

Can someone please help me?

sunny_talwar — Tue, 05 Jun 2018 13:53:51 GMT

Try this

LOAD Key,

Timestamp,

New_Field,

If(Len(Trim(New_Field)) = '0' and Peek(Key) = Key, Peek('New_Field1'), New_Field) as New_Field1

Resident Table

Order By Key, Timestamp;

DROP Table Table;

DROP Field New_Field;

RENAME Field New_Field1 to New_Field;

alexandermllr — Wed, 06 Jun 2018 08:00:03 GMT

That works perfect!

Thank you very much!