Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
@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