Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
kazi
Contributor
Contributor

How to get previous value

Hi,

I have a table like this 

kazi_0-1619537450854.png

I want the result like this

kazi_1-1619537647387.png

If Value is empty then I have to show previous value there. 

i am writing like this 

kazi_2-1619538085856.png

but it is not working. Any suggestion please. Please see the attached file.

Thanking You

Kazi

Labels (1)
1 Solution

Accepted Solutions
edwin
Master II
Master II

4 Replies
edwin
Master II
Master II

use Peek instead of previous in your load script

kazi
Contributor
Contributor
Author

Hi Edwin, Peek or previous , Result is same for both. 

kazi_0-1619551282673.png

 

edwin
Master II
Master II

edwin_0-1619554351806.png

 

edwin
Master II
Master II

edwin_1-1619558419713.png