topic PAIRS in QlikView

topic PAIRS in QlikView https://community.qlik.com/t5/QlikView/PAIRS/m-p/1874989#M1216634 <DIV class="topic-subject-wrapper"> <DIV class="lia-message-subject lia-component-message-view-widget-subject"> <DIV class="MessageSubject"> <DIV class="lia-message-subject"> </DIV> </DIV> </DIV> </DIV> <DIV class="MessageInResponseTo lia-component-message-view-widget-in-response-to lia-component-in-response-to"> </DIV> <DIV id="bodyDisplay" class="lia-message-body lia-component-message-view-widget-body lia-component-body-signature-highlight-escalation lia-component-message-view-widget-body-signature-highlight-escalation"> <DIV class="lia-message-body-content"> <P>Hi everyone,<BR />i have the following problem.</P> <P>I would like to make pairs of the following form:</P> <P> </P> <TABLE border="1" width="100%"> <TBODY> <TR> <TD width="33.333333333333336%" height="25px">Arrival</TD> <TD width="33.333333333333336%" height="25px">Stage</TD> <TD width="33.333333333333336%" height="25px">Departure</TD> </TR> <TR> <TD width="33.333333333333336%" height="25px">02/11/2021 13:31:27</TD> <TD width="33.333333333333336%" height="25px">1. Process</TD> <TD width="33.333333333333336%" height="25px">02/11/2021 14:11:38</TD> </TR> <TR> <TD width="33.333333333333336%" height="25px">02/11/2021 14:12:02</TD> <TD width="33.333333333333336%" height="25px">1. Process</TD> <TD width="33.333333333333336%" height="25px">02/11/2021 14:12:03</TD> </TR> <TR> <TD width="33.333333333333336%" height="25px">02/11/2021 14:18:27</TD> <TD width="33.333333333333336%" height="25px">2 Distribucion</TD> <TD width="33.333333333333336%" height="25px">02/11/2021 14:18:28</TD> </TR> <TR> <TD width="33.333333333333336%" height="25px">02/11/2021 14:50:42</TD> <TD width="33.333333333333336%" height="25px">1. Process</TD> <TD width="33.333333333333336%" height="25px">02/11/2021 15:03:51</TD> </TR> <TR> <TD width="33.333333333333336%" height="25px">02/11/2021 15:10:41</TD> <TD width="33.333333333333336%" height="25px">2 Distribucion</TD> <TD width="33.333333333333336%" height="25px">02/11/2021 15:10:42</TD> </TR> </TBODY> </TABLE> <P> </P> <P>There are some pairs that can be like this:</P> <TABLE border="1" width="432px"> <TBODY> <TR> <TD width="220.438px" height="25px">Arrival</TD> <TD width="107.531px" height="25px">Stage</TD> <TD width="103.031px" height="25px">Departure</TD> </TR> <TR> <TD width="220.438px" height="47px">02/11/2021 13:31:27</TD> <TD width="107.531px" height="47px">1. Process</TD> <TD width="103.031px" height="47px">02/11/2021 14:11:38</TD> </TR> <TR> <TD width="220.438px" height="47px">02/11/2021 14:12:02</TD> <TD width="107.531px" height="47px">1. Process</TD> <TD width="103.031px" height="47px">02/11/2021 14:12:03</TD> </TR> <TR> <TD width="220.438px" height="47px">02/11/2021 14:18:27</TD> <TD width="107.531px" height="47px">2 Distribucion</TD> <TD width="103.031px" height="47px">02/11/2021 14:18:28</TD> </TR> <TR> <TD width="220.438px" height="47px">02/11/2021 14:50:42</TD> <TD width="107.531px" height="47px">2. Verification</TD> <TD width="103.031px" height="47px">02/11/2021 15:03:51</TD> </TR> <TR> <TD width="220.438px" height="47px">02/11/2021 15:10:41</TD> <TD width="107.531px" height="47px">3. Proceso</TD> <TD width="103.031px" height="47px">02/11/2021 15:10:42</TD> </TR> <TR> <TD width="220.438px" height="70px"> <PRE id="tw-target-text" class="tw-data-text tw-text-large tw-ta" dir="ltr" data-placeholder="Traducción"><SPAN class="Y2IQFc">These are other stages</SPAN></PRE> </TD> <TD width="107.531px" height="70px">X</TD> <TD width="103.031px" height="70px"> </TD> </TR> <TR> <TD width="220.438px" height="70px"> <PRE id="tw-target-text" class="tw-data-text tw-text-large tw-ta" dir="ltr" data-placeholder="Traducción"><SPAN class="Y2IQFc">These are other stages</SPAN></PRE> </TD> <TD width="107.531px" height="70px">X</TD> <TD width="103.031px" height="70px"> </TD> </TR> <TR> <TD width="220.438px" height="47px">02/11/2021 14:50:42</TD> <TD width="107.531px" height="47px">2. Verification</TD> <TD width="103.031px" height="47px">02/11/2021 15:03:51</TD> </TR> <TR> <TD width="220.438px" height="47px">02/11/2021 15:10:41</TD> <TD width="107.531px" height="47px">3. Proceso</TD> <TD width="103.031px" height="47px">02/11/2021 15:10:42</TD> </TR> </TBODY> </TABLE> <P> </P> <P><SPAN>What I want to do is this:</SPAN></P> <TABLE border="1" width="465px"> <TBODY> <TR> <TD width="220.438px" height="25px">Arrival</TD> <TD width="106.203px" height="25px">Stage</TD> <TD width="85.9844px" height="25px">Departure</TD> <TD width="51.375px">Pair</TD> </TR> <TR> <TD width="220.438px" height="47px">02/11/2021 13:31:27</TD> <TD width="106.203px" height="47px">1. Process</TD> <TD width="85.9844px" height="47px">02/11/2021 14:11:38</TD> <TD width="51.375px">1</TD> </TR> <TR> <TD width="220.438px" height="47px">02/11/2021 14:12:02</TD> <TD width="106.203px" height="47px">1. Process</TD> <TD width="85.9844px" height="47px">02/11/2021 14:12:03</TD> <TD width="51.375px"> </TD> </TR> <TR> <TD width="220.438px" height="47px">02/11/2021 14:18:27</TD> <TD width="106.203px" height="47px">2 Distribucion</TD> <TD width="85.9844px" height="47px">02/11/2021 14:18:28</TD> <TD width="51.375px">2</TD> </TR> <TR> <TD width="220.438px" height="47px">02/11/2021 14:50:42</TD> <TD width="106.203px" height="47px">2. Verification</TD> <TD width="85.9844px" height="47px">02/11/2021 15:03:51</TD> <TD width="51.375px">1</TD> </TR> <TR> <TD width="220.438px" height="47px">02/11/2021 15:10:41</TD> <TD width="106.203px" height="47px">3. Proceso</TD> <TD width="85.9844px" height="47px">02/11/2021 15:10:42</TD> <TD width="51.375px">1</TD> </TR> <TR> <TD width="220.438px" height="70px"> <PRE id="tw-target-text" class="tw-data-text tw-text-large tw-ta" dir="ltr" data-placeholder="Traducción"><SPAN class="Y2IQFc">These are other stages</SPAN></PRE> </TD> <TD width="106.203px" height="70px">X</TD> <TD width="85.9844px" height="70px"> </TD> <TD width="51.375px"> </TD> </TR> <TR> <TD width="220.438px" height="70px"> <PRE id="tw-target-text" class="tw-data-text tw-text-large tw-ta" dir="ltr" data-placeholder="Traducción"><SPAN class="Y2IQFc">These are other stages</SPAN></PRE> </TD> <TD width="106.203px" height="70px">X</TD> <TD width="85.9844px" height="70px"> </TD> <TD width="51.375px"> </TD> </TR> <TR> <TD width="220.438px" height="47px">02/11/2021 14:50:42</TD> <TD width="106.203px" height="47px">2. Verification</TD> <TD width="85.9844px" height="47px">02/11/2021 15:03:51</TD> <TD width="51.375px">2</TD> </TR> <TR> <TD width="220.438px" height="47px">02/11/2021 15:10:41</TD> <TD width="106.203px" height="47px">3. Proceso</TD> <TD width="85.9844px" height="47px">02/11/2021 15:10:42</TD> <TD width="51.375px">2</TD> </TR> </TBODY> </TABLE> <P> </P> <P>Currently she is doing couples but when two stages appear like those of:</P> <P> </P> <TABLE border="1"> <TBODY> <TR> <TD width="220.438px" height="47px">02/11/2021 14:50:42</TD> <TD width="106.203px" height="47px">2. Verification</TD> <TD width="85.9844px" height="47px">02/11/2021 15:03:51</TD> <TD width="51.375px">1</TD> </TR> <TR> <TD width="220.438px" height="47px">02/11/2021 15:10:41</TD> <TD width="106.203px" height="47px">3. Proceso</TD> <TD width="85.9844px" height="47px">02/11/2021 15:10:42</TD> <TD width="51.375px">1</TD> </TR> </TBODY> </TABLE> <P> </P> <TABLE border="1"> <TBODY> <TR> <TD width="220.438px" height="47px">02/11/2021 14:50:42</TD> <TD width="106.203px" height="47px">2. Verification</TD> <TD width="85.9844px" height="47px">02/11/2021 15:03:51</TD> <TD width="51.375px">2</TD> </TR> <TR> <TD width="220.438px" height="47px">02/11/2021 15:10:41</TD> <TD width="106.203px" height="47px">3. Proceso</TD> <TD width="85.9844px" height="47px">02/11/2021 15:10:42</TD> <TD width="51.375px">2</TD> </TR> </TBODY> </TABLE> <P> </P> <P>For these cases, the couple is not performing.</P> <P>Or if it is done but does not separate them with 1 and 2 but takes it as a single pair</P> <P> </P> </DIV> </DIV> Fri, 24 Dec 2021 14:08:24 GMT Aldemarprins4 2021-12-24T14:08:24Z PAIRS https://community.qlik.com/t5/QlikView/PAIRS/m-p/1874989#M1216634 <DIV class="topic-subject-wrapper"> <DIV class="lia-message-subject lia-component-message-view-widget-subject"> <DIV class="MessageSubject"> <DIV class="lia-message-subject"> </DIV> </DIV> </DIV> </DIV> <DIV class="MessageInResponseTo lia-component-message-view-widget-in-response-to lia-component-in-response-to"> </DIV> <DIV id="bodyDisplay" class="lia-message-body lia-component-message-view-widget-body lia-component-body-signature-highlight-escalation lia-component-message-view-widget-body-signature-highlight-escalation"> <DIV class="lia-message-body-content"> <P>Hi everyone,<BR />i have the following problem.</P> <P>I would like to make pairs of the following form:</P> <P> </P> <TABLE border="1" width="100%"> <TBODY> <TR> <TD width="33.333333333333336%" height="25px">Arrival</TD> <TD width="33.333333333333336%" height="25px">Stage</TD> <TD width="33.333333333333336%" height="25px">Departure</TD> </TR> <TR> <TD width="33.333333333333336%" height="25px">02/11/2021 13:31:27</TD> <TD width="33.333333333333336%" height="25px">1. Process</TD> <TD width="33.333333333333336%" height="25px">02/11/2021 14:11:38</TD> </TR> <TR> <TD width="33.333333333333336%" height="25px">02/11/2021 14:12:02</TD> <TD width="33.333333333333336%" height="25px">1. Process</TD> <TD width="33.333333333333336%" height="25px">02/11/2021 14:12:03</TD> </TR> <TR> <TD width="33.333333333333336%" height="25px">02/11/2021 14:18:27</TD> <TD width="33.333333333333336%" height="25px">2 Distribucion</TD> <TD width="33.333333333333336%" height="25px">02/11/2021 14:18:28</TD> </TR> <TR> <TD width="33.333333333333336%" height="25px">02/11/2021 14:50:42</TD> <TD width="33.333333333333336%" height="25px">1. Process</TD> <TD width="33.333333333333336%" height="25px">02/11/2021 15:03:51</TD> </TR> <TR> <TD width="33.333333333333336%" height="25px">02/11/2021 15:10:41</TD> <TD width="33.333333333333336%" height="25px">2 Distribucion</TD> <TD width="33.333333333333336%" height="25px">02/11/2021 15:10:42</TD> </TR> </TBODY> </TABLE> <P> </P> <P>There are some pairs that can be like this:</P> <TABLE border="1" width="432px"> <TBODY> <TR> <TD width="220.438px" height="25px">Arrival</TD> <TD width="107.531px" height="25px">Stage</TD> <TD width="103.031px" height="25px">Departure</TD> </TR> <TR> <TD width="220.438px" height="47px">02/11/2021 13:31:27</TD> <TD width="107.531px" height="47px">1. Process</TD> <TD width="103.031px" height="47px">02/11/2021 14:11:38</TD> </TR> <TR> <TD width="220.438px" height="47px">02/11/2021 14:12:02</TD> <TD width="107.531px" height="47px">1. Process</TD> <TD width="103.031px" height="47px">02/11/2021 14:12:03</TD> </TR> <TR> <TD width="220.438px" height="47px">02/11/2021 14:18:27</TD> <TD width="107.531px" height="47px">2 Distribucion</TD> <TD width="103.031px" height="47px">02/11/2021 14:18:28</TD> </TR> <TR> <TD width="220.438px" height="47px">02/11/2021 14:50:42</TD> <TD width="107.531px" height="47px">2. Verification</TD> <TD width="103.031px" height="47px">02/11/2021 15:03:51</TD> </TR> <TR> <TD width="220.438px" height="47px">02/11/2021 15:10:41</TD> <TD width="107.531px" height="47px">3. Proceso</TD> <TD width="103.031px" height="47px">02/11/2021 15:10:42</TD> </TR> <TR> <TD width="220.438px" height="70px"> <PRE id="tw-target-text" class="tw-data-text tw-text-large tw-ta" dir="ltr" data-placeholder="Traducción"><SPAN class="Y2IQFc">These are other stages</SPAN></PRE> </TD> <TD width="107.531px" height="70px">X</TD> <TD width="103.031px" height="70px"> </TD> </TR> <TR> <TD width="220.438px" height="70px"> <PRE id="tw-target-text" class="tw-data-text tw-text-large tw-ta" dir="ltr" data-placeholder="Traducción"><SPAN class="Y2IQFc">These are other stages</SPAN></PRE> </TD> <TD width="107.531px" height="70px">X</TD> <TD width="103.031px" height="70px"> </TD> </TR> <TR> <TD width="220.438px" height="47px">02/11/2021 14:50:42</TD> <TD width="107.531px" height="47px">2. Verification</TD> <TD width="103.031px" height="47px">02/11/2021 15:03:51</TD> </TR> <TR> <TD width="220.438px" height="47px">02/11/2021 15:10:41</TD> <TD width="107.531px" height="47px">3. Proceso</TD> <TD width="103.031px" height="47px">02/11/2021 15:10:42</TD> </TR> </TBODY> </TABLE> <P> </P> <P><SPAN>What I want to do is this:</SPAN></P> <TABLE border="1" width="465px"> <TBODY> <TR> <TD width="220.438px" height="25px">Arrival</TD> <TD width="106.203px" height="25px">Stage</TD> <TD width="85.9844px" height="25px">Departure</TD> <TD width="51.375px">Pair</TD> </TR> <TR> <TD width="220.438px" height="47px">02/11/2021 13:31:27</TD> <TD width="106.203px" height="47px">1. Process</TD> <TD width="85.9844px" height="47px">02/11/2021 14:11:38</TD> <TD width="51.375px">1</TD> </TR> <TR> <TD width="220.438px" height="47px">02/11/2021 14:12:02</TD> <TD width="106.203px" height="47px">1. Process</TD> <TD width="85.9844px" height="47px">02/11/2021 14:12:03</TD> <TD width="51.375px"> </TD> </TR> <TR> <TD width="220.438px" height="47px">02/11/2021 14:18:27</TD> <TD width="106.203px" height="47px">2 Distribucion</TD> <TD width="85.9844px" height="47px">02/11/2021 14:18:28</TD> <TD width="51.375px">2</TD> </TR> <TR> <TD width="220.438px" height="47px">02/11/2021 14:50:42</TD> <TD width="106.203px" height="47px">2. Verification</TD> <TD width="85.9844px" height="47px">02/11/2021 15:03:51</TD> <TD width="51.375px">1</TD> </TR> <TR> <TD width="220.438px" height="47px">02/11/2021 15:10:41</TD> <TD width="106.203px" height="47px">3. Proceso</TD> <TD width="85.9844px" height="47px">02/11/2021 15:10:42</TD> <TD width="51.375px">1</TD> </TR> <TR> <TD width="220.438px" height="70px"> <PRE id="tw-target-text" class="tw-data-text tw-text-large tw-ta" dir="ltr" data-placeholder="Traducción"><SPAN class="Y2IQFc">These are other stages</SPAN></PRE> </TD> <TD width="106.203px" height="70px">X</TD> <TD width="85.9844px" height="70px"> </TD> <TD width="51.375px"> </TD> </TR> <TR> <TD width="220.438px" height="70px"> <PRE id="tw-target-text" class="tw-data-text tw-text-large tw-ta" dir="ltr" data-placeholder="Traducción"><SPAN class="Y2IQFc">These are other stages</SPAN></PRE> </TD> <TD width="106.203px" height="70px">X</TD> <TD width="85.9844px" height="70px"> </TD> <TD width="51.375px"> </TD> </TR> <TR> <TD width="220.438px" height="47px">02/11/2021 14:50:42</TD> <TD width="106.203px" height="47px">2. Verification</TD> <TD width="85.9844px" height="47px">02/11/2021 15:03:51</TD> <TD width="51.375px">2</TD> </TR> <TR> <TD width="220.438px" height="47px">02/11/2021 15:10:41</TD> <TD width="106.203px" height="47px">3. Proceso</TD> <TD width="85.9844px" height="47px">02/11/2021 15:10:42</TD> <TD width="51.375px">2</TD> </TR> </TBODY> </TABLE> <P> </P> <P>Currently she is doing couples but when two stages appear like those of:</P> <P> </P> <TABLE border="1"> <TBODY> <TR> <TD width="220.438px" height="47px">02/11/2021 14:50:42</TD> <TD width="106.203px" height="47px">2. Verification</TD> <TD width="85.9844px" height="47px">02/11/2021 15:03:51</TD> <TD width="51.375px">1</TD> </TR> <TR> <TD width="220.438px" height="47px">02/11/2021 15:10:41</TD> <TD width="106.203px" height="47px">3. Proceso</TD> <TD width="85.9844px" height="47px">02/11/2021 15:10:42</TD> <TD width="51.375px">1</TD> </TR> </TBODY> </TABLE> <P> </P> <TABLE border="1"> <TBODY> <TR> <TD width="220.438px" height="47px">02/11/2021 14:50:42</TD> <TD width="106.203px" height="47px">2. Verification</TD> <TD width="85.9844px" height="47px">02/11/2021 15:03:51</TD> <TD width="51.375px">2</TD> </TR> <TR> <TD width="220.438px" height="47px">02/11/2021 15:10:41</TD> <TD width="106.203px" height="47px">3. Proceso</TD> <TD width="85.9844px" height="47px">02/11/2021 15:10:42</TD> <TD width="51.375px">2</TD> </TR> </TBODY> </TABLE> <P> </P> <P>For these cases, the couple is not performing.</P> <P>Or if it is done but does not separate them with 1 and 2 but takes it as a single pair</P> <P> </P> </DIV> </DIV> Fri, 24 Dec 2021 14:08:24 GMT https://community.qlik.com/t5/QlikView/PAIRS/m-p/1874989#M1216634 Aldemarprins4 2021-12-24T14:08:24Z