topic How to fill the blanks with the previous Value in QlikView

How to fill the blanks with the previous Value

alvinford — Wed, 20 Apr 2016 00:13:35 GMT

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 — Wed, 20 Apr 2016 00:16:06 GMT

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 — Wed, 20 Apr 2016 02:08:51 GMT

Thank You Sunny ...

Cheers !!

Regards,

Alvin.

Amit_Kakkad_PD — Fri, 27 Oct 2023 11:51:55 GMT

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