Get last available value if NULL

[sarasmonu]

Hi Team,

I have list of dates with corresponding information(value) in a table in Qliksense.

If the value is NULL i want to list the last available value in my table

example: Input

Date               Value

1/2/2018          2

2/2/2018          -

3/3/2018          -

4/8/2018          10

10/8/2018         -

12/8/2018          -

Output:

Date               Value

1/2/2018          2

2/2/2018          2

3/3/2018          2

4/8/2018          10

10/8/2018         10

12/8/2018          10

Thanks,

Monu

[vamsee]

Try

LOAD
Date,
IF(Len(Trim(Value))<1,Peek(Value), Value) as Value;