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

Announcements
Posting on Qlik Community is temporarily paused for some users. Thank you for patience and we'll update you soon!
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