Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
hi,
Find the screen shot and expression also mentioned, it will give your result
Ksrinivasan