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

Announcements
ALERT: QlikView server communication interruptions following Microsoft Windows Domain Controller security updates
cancel
Showing results for 
Search instead for 
Did you mean: 
Aldemarprins4
Contributor III
Contributor III

Where with this condition

Hi, I have the following table:

DATE STAGE DEPARTURE DATE NEWSTAGE
03/02/2022 12:04:29 1. Process 03/02/2022  
03/02/2022 13:17:24 1. Process 03/02/2022  
03/02/2022 13:20:00 1. Process 03/02/2022  
03/02/2022  13:25:00 -------   1.4 Process
03/02/2022  13:27:00 1. Process    

 

And I would like to do a where so that it looks like this:

 

DATE STAGE DEPARTURE DATE NEWSTAGE
03/02/2022 12:04:29 1. Process 03/02/2022  
03/02/2022 13:17:24 1. Process 03/02/2022  
03/02/2022 13:20:00 1. Process 03/02/2022  
03/02/2022  13:25:00 -------   1.4 Process

 

Every time a 1.4 Process stage is found, it keeps the previous information

 

0 Replies