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

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Aldemarprins4
Contributor III
Contributor III
‎2021-12-24 09:08 AM

PAIRS

 
 

Hi everyone,
i have the following problem.

I would like to make pairs of the following form:

 

Arrival Stage Departure
02/11/2021 13:31:27 1. Process 02/11/2021 14:11:38
02/11/2021 14:12:02 1. Process 02/11/2021 14:12:03
02/11/2021 14:18:27 2 Distribucion 02/11/2021 14:18:28
02/11/2021 14:50:42 1. Process 02/11/2021 15:03:51
02/11/2021 15:10:41 2 Distribucion 02/11/2021 15:10:42

 

There are some pairs that can be like this:

Arrival Stage Departure
02/11/2021 13:31:27 1. Process 02/11/2021 14:11:38
02/11/2021 14:12:02 1. Process 02/11/2021 14:12:03
02/11/2021 14:18:27 2 Distribucion 02/11/2021 14:18:28
02/11/2021 14:50:42 2. Verification 02/11/2021 15:03:51
02/11/2021 15:10:41 3. Proceso 02/11/2021 15:10:42 
These are other stages
 X   
These are other stages
 X  
02/11/2021 14:50:42 2. Verification 02/11/2021 15:03:51
02/11/2021 15:10:41 3. Proceso 02/11/2021 15:10:42

 

What I want to do is this:

Arrival Stage Departure Pair
02/11/2021 13:31:27 1. Process 02/11/2021 14:11:38 1
02/11/2021 14:12:02 1. Process 02/11/2021 14:12:03  
02/11/2021 14:18:27 2 Distribucion 02/11/2021 14:18:28 2
02/11/2021 14:50:42 2. Verification 02/11/2021 15:03:51 1
02/11/2021 15:10:41 3. Proceso 02/11/2021 15:10:42 1 
These are other stages
 X     
These are other stages
 X    
02/11/2021 14:50:42 2. Verification 02/11/2021 15:03:51 2
02/11/2021 15:10:41 3. Proceso 02/11/2021 15:10:42 2

 

Currently she is doing couples but when two stages appear like those of:

 

02/11/2021 14:50:42 2. Verification 02/11/2021 15:03:51 1
02/11/2021 15:10:41 3. Proceso 02/11/2021 15:10:42 1

 

02/11/2021 14:50:42 2. Verification 02/11/2021 15:03:51 2
02/11/2021 15:10:41 3. Proceso 02/11/2021 15:10:42 2

 

For these cases, the couple is not performing.

Or if it is done but does not separate them with 1 and 2 but takes it as a single pair

 

326 Views
0 Likes
0 Replies