topic Re: Fill previous value where there is blank in QlikView

Fill previous value where there is blank

gauravgg — Mon, 26 Jan 2026 18:19:17 GMT

Hi All

I have the following table

Currency

Date

Value

USD

01/01/2017

USD

02/01/2017

AED

01/01/2017

AED

02/01/2017

AED

03/01/2017

AED

04/01/2017

I want the following output

Currency

Date

Value

USD

01/01/2017

USD

02/01/2017

AED

01/01/2017

AED

02/01/2017

AED

03/01/2017

AED

04/01/2017

ie where ever there is null value in the Value field ,i want to put previous value in that field

can anyone help me

Thanks in advance

Re: Fill previous value where there is blank

tresB — Wed, 05 Jul 2017 06:18:07 GMT

Try like:

Load

Currency,

Date,

If(Len(Trim(Value))=0, peek(Value), Value) as Value

From <>:

Note: Your loading sort order might have to be defined using Order By clause;.

Re: Fill previous value where there is blank

gauravgg — Wed, 05 Jul 2017 06:26:57 GMT

Hi Thanks for reply

But it is not working.

is there any other way ?

Re: Fill previous value where there is blank

tresB — Wed, 05 Jul 2017 06:33:39 GMT

Could post a qvw with sample data set showing that is not working?

Re: Fill previous value where there is blank

Anonymous — Wed, 05 Jul 2017 07:32:30 GMT

Try like:

Load

          Currency,

          Date,

          If(Len(Trim(Value))=0, peek(Value), Value) as Value

From <>:

Note: Your loading sort order might have to be defined using Order By clause;

try with peek('Value') instead

Re: Fill previous value where there is blank

tresB — Wed, 05 Jul 2017 07:37:41 GMT

It works even without quotes.

Re: Fill previous value where there is blank

Anonymous — Wed, 05 Jul 2017 07:42:42 GMT

that's new for me... but ok

Re: Fill previous value where there is blank

ahmar811 — Wed, 05 Jul 2017 08:20:21 GMT

Gaurav

Please find the attached file for your output

Regards

Ahmar