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

Announcements
Now accepting applications for the Qlik Luminary and Partner Ambassador Programs: Apply by July 6!
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