Fill missing dates and use old value

[qlikwiz123]

Hi,

I have dates and values associated as shown below

Date                   Value

07/23/2020 – 1000

07/24/2020 – 1200

07/27/2020 – 800

Is there a way to fill the missing dates and use the same value prior to that? 

For example, generate missing dates 7/25, 7/26 and show the previous value from 7/24, which is 1200

Output:

Date                   Value

07/23/2020 – 1000

07/24/2020 – 1200

07/25/2020 – 1200

7/26/2020    - 1200

7/27/2020   - 800

[qlikwiz123 · Accepted solution]

Hi @Kushal_Chawda , thank you so much.

With a little change in the expression 

from

     If( IsNull(Value),Peek(Value),Value) as Value

to

If(ID = Peek(ID) and Type = Peek(Type) and IsNull(Value), Peek(Value), Value) as Value

I got this working with my actual data. Thanks @sunny_talwar for the expression. Also, @zhadrakas  thank you for all the help. Every bit helped and is highly appreciated.

[Kushal_Chawda]

@qlikwiz123  I don't think you need that expression as I have already sorted table on final load so expression i used should work. but anyways glad that it was helpful