topic Fill empty field with the last value in QlikView

Fill empty field with the last value

Anonymous — Fri, 19 Aug 2011 10:06:31 GMT

Dear specilialist,

I need to fill fields without value with the previous value in that field

So :

25 A

778

77 B

12 C

Needs to become:

25 A

778 A

44 A

55 A

77 B

44 B

12 B

12 C

33 C

I tried to use Peek() and Previous() but that doesn't work. Maybe I am using it wrong.

Please take a look at the atteched files.

PS my orginal data is not in Excal so I can not use the fill function in the wizard

swuehl — Fri, 19 Aug 2011 10:27:54 GMT

Hi you just need to reference your renamed field A2 in peek function:

LOAD If (ISNULL(A), Peek(A2) , A) as A2,

B as B2

FROM

Schedule.xlsx

(ooxml, no labels);

Regards,

Stefan

Anonymous — Fri, 19 Aug 2011 10:38:58 GMT

Yes that's it. I overlooked that.

Thanks!