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

Announcements
Save $650 on Qlik Connect, Dec 1 - 7, our lowest price of the year. Register with code CYBERWEEK: Register
cancel
Showing results for 
Search instead for 
Did you mean: 
Paula1
Creator
Creator

How to fill the blanks with the previous Value

How to create a script in the bank for me to fill in the last value and date equal to the previous one.
Prod Store Date Hour
5 50 30/09/2011 12:57
5 0  
5 51 30/09/2011 13:36
6 85 30/09/2011 22:06
6 0  
6 89 03/10/2011 14:45

 

result i need
Prod Store Date Hour
5 50 30/09/2011 12:57
5 50 30/09/2011 12:57
5 51 30/09/2011 13:36
6 85 30/09/2011 22:06
6 85 30/09/2011 22:06
6 89 03/10/2011 14:45

 

Paula Santos
vitória - ES
2 Solutions
2 Replies