topic Re: Using Peek() to fill empty rows - but how can I limit it to matching ID? in App Development

Using Peek() to fill empty rows - but how can I limit it to matching ID?

Perus_Pena — Sat, 16 Nov 2024 05:39:03 GMT

Hello,

I can't figure out how to limit this to only for for same ID. Currently my issue is that this peeks from previous ID untill the correct ID has it's first value. I also have calendar here so the first value does not appear on the first date for that ID.

Final:

NoConcatenate

Load

ID,

date,

If(Len(Trim(status)) = 0, Peek('status'), status) as status

Resident Temp

order by date, ID asc;

I tried a for loop but that seems overly complicated.

Cheers,

Pena

Re: Using Peek() to fill empty rows - but how can I limit it to matching ID?

anushree1 — Thu, 06 Jun 2019 10:37:06 GMT

Please try:

If(ID =peek(ID) and Len(Trim(status)) = 0, Peek('status'), status) as status

Re: Using Peek() to fill empty rows - but how can I limit it to matching ID?

Vegar — Thu, 06 Jun 2019 10:42:33 GMT

Try to use @anushree1 solution, but didn't the order of your order by like this.

Final:
NoConcatenate
Load
ID,
date,
If(ID =peek(ID) and Len(Trim(status)) = 0, Peek('status'), status) as status
Resident Temp
order by ID, date;

Re: Using Peek() to fill empty rows - but how can I limit it to matching ID?

Perus_Pena — Thu, 06 Jun 2019 11:00:01 GMT

This seems to work as it leaves the early calendar empty, but I still need to check things.

How does the peek(ID) and Peek('status') "Connect"? I mean how does the ID=Peek(ID) know that it should peek the same row that the later peek does?

Re: Using Peek() to fill empty rows - but how can I limit it to matching ID?

anushree1 — Thu, 06 Jun 2019 11:05:04 GMT

Hi ,

Peek works row by row ,so on each row it applies the peek which eventually leads to the right result and yes as mentioned by @Vegar please order the data using order by clause for the rows to appear properly , also check https://help.qlik.com/en-US/sense/April2019/Subsystems/Hub/Content/Sense_Hub/Scripting/InterRecordFunctions/Peek.htm

for better understanding on peek function

Re: Using Peek() to fill empty rows - but how can I limit it to matching ID?

Perus_Pena — Thu, 06 Jun 2019 11:12:53 GMT

Thanks @Vegar @anushree1 !