Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
BI & Data Trends 2021. Discover the top 10 trends emerging in today. Join us on Dec. 8th REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Specialist
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