Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
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