Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
vvvvvvizard
Partner - Specialist
Partner - Specialist

Fill in rows from above to missing cells

Good day , please view the screenshot to view the output 

 

This is my code , for some reason the peek only fills in one cell below and not the rest . 

I want to to fill in all missing cells from above value to below 

 

Freeze:
Load Date,
Start_Freeze,
If(len(Start_Freeze)>0,Start_Freeze,peek('Start_Freeze')) as Start_Freeze1,
len(Start_Freeze) as Length
Resident T_WorkDay;

0 Replies