Solved: How to fill the blanks with the previous Value - Qlik Community

alvinford · ‎2016-04-19

Hi All,

I have my data as below, need to fill the gaps using the previous value. Used the following formula

if(Len(Step)>0,Step,Peek(Step)) as Step2 but it is only filling the next row not all the rows. Request your help to achieve this.

Need to achieve this using script.

Please refer the attachment for data.

Thank You in Advance...

sunny_talwar · ‎2016-04-19

Try this:

If(Len(Step)>0,Step,Peek('Step2')) as Step2

Script for your sample:

Table:

LOAD Step,

StepCode,

Date,

StepCount,

If(Len(Step)>0,Step,Peek('Step2')) as Step2

FROM

[Example (3).xlsx]

(ooxml, embedded labels, table is Sheet2);

View solution in original post

sunny_talwar · ‎2016-04-19

Try this:

If(Len(Step)>0,Step,Peek('Step2')) as Step2

Script for your sample:

Table:

LOAD Step,

StepCode,

Date,

StepCount,

If(Len(Step)>0,Step,Peek('Step2')) as Step2

FROM

[Example (3).xlsx]

(ooxml, embedded labels, table is Sheet2);

alvinford · ‎2016-04-19

Thank You Sunny ...

Cheers !!

Regards,

Alvin.

Amit_Kakkad_PD · ‎2023-10-27

That is an amazing answer @sunny_talwar . Genius! Thank you so much!