Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
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