Previous dates values

[Gowtham174]

qHi team,

I need to give the previous dates values when dates are missing need to consider previous dates which is available,

Please see the below input and output values, 

Raw data:

Name	values	date
a	1	1/1/2021
b	2	1/1/2021
c	3	1/1/2021
c	6	1/2/2021
a	7	1/3/2021
b	8	1/3/2021
c	9	1/3/2021

Expected output in Qlik straight table

Name	Current values	Previous Value
a	7	1
b	8	2
c	9	6

I tried with below expression

sum({<date={'$(=Date(Aggr(Max({$<date={"<=$(=Date(Max(date)))"}>}
date,2),Name)))'}>}values)

 Thanks,

Gowtham

[Ksrinivasan]

hi,

Find the screen shot and expression also mentioned, it will give your result

Ksrinivasan