https://community.qlik.com/t5/App-Development/Display-Latest-Cycle/m-p/1807931#M65772 <P>Hi,</P><P>My data :</P><TABLE><TBODY><TR><TD>Case Identifier</TD><TD>Cycle</TD><TD>Stage</TD><TD>Max stages in the cycle</TD><TD>Overall Status</TD><TD>Time (Days and Hours)</TD><TD>SLA Time Scale</TD><TD>SLA.Time</TD></TR><TR><TD>{E075B973-0000-C511-B2FA-0428B188370D}</TD><TD>6</TD><TD>2</TD><TD>5</TD><TD>Pending</TD><TD>0 00:20:21</TD><TD>Less Than 7 Days</TD><TD>12/05/2021 10:06:20 AM</TD></TR><TR><TD>{E075B973-0000-C511-B2FA-0428B188370D}</TD><TD>6</TD><TD>1</TD><TD>5</TD><TD>Pending</TD><TD>0</TD><TD>Less Than 7 Days</TD><TD>12/05/2021 10:05:59 AM</TD></TR><TR><TD>{E075B973-0000-C511-B2FA-0428B188370D}</TD><TD>5</TD><TD>2</TD><TD>2</TD><TD>Complete</TD><TD>0 00:15:18</TD><TD>Less Than 7 Days</TD><TD>21/10/2020 10:21:15 AM</TD></TR><TR><TD>{E075B973-0000-C511-B2FA-0428B188370D}</TD><TD>5</TD><TD>1</TD><TD>2</TD><TD>Pending</TD><TD>0</TD><TD>Less Than 7 Days</TD><TD>21/10/2020 10:05:57 AM</TD></TR><TR><TD>{E075B973-0000-C511-B2FA-0428B188370D}</TD><TD>4</TD><TD>2</TD><TD>2</TD><TD>Complete</TD><TD>0 00:07:21</TD><TD>Less Than 7 Days</TD><TD>20/10/2020 2:58:41 PM</TD></TR><TR><TD>{E075B973-0000-C511-B2FA-0428B188370D}</TD><TD>4</TD><TD>1</TD><TD>2</TD><TD>Pending</TD><TD>0</TD><TD>Less Than 7 Days</TD><TD>20/10/2020 2:51:20 PM</TD></TR><TR><TD>{E075B973-0000-C511-B2FA-0428B188370D}</TD><TD>3</TD><TD>2</TD><TD>2</TD><TD>Complete</TD><TD>0 03:22:03</TD><TD>Less Than 7 Days</TD><TD>20/10/2020 2:37:09 PM</TD></TR><TR><TD>{E075B973-0000-C511-B2FA-0428B188370D}</TD><TD>3</TD><TD>1</TD><TD>2</TD><TD>Pending</TD><TD>0</TD><TD>Less Than 7 Days</TD><TD>20/10/2020 11:15:06 AM</TD></TR><TR><TD>{E075B973-0000-C511-B2FA-0428B188370D}</TD><TD>2</TD><TD>2</TD><TD>2</TD><TD>Complete</TD><TD>0 00:46:35</TD><TD>Less Than 7 Days</TD><TD>05/08/2020 11:28:05 AM</TD></TR><TR><TD>{E075B973-0000-C511-B2FA-0428B188370D}</TD><TD>2</TD><TD>1</TD><TD>2</TD><TD>Pending</TD><TD>0</TD><TD>Less Than 7 Days</TD><TD>05/08/2020 10:41:30 AM</TD></TR><TR><TD>{E075B973-0000-C511-B2FA-0428B188370D}</TD><TD>1</TD><TD>2</TD><TD>2</TD><TD>Complete</TD><TD>0 04:24:59</TD><TD>Less Than 7 Days</TD><TD>04/08/2020 10:38:39 PM</TD></TR><TR><TD>{E075B973-0000-C511-B2FA-0428B188370D}</TD><TD>1</TD><TD>1</TD><TD>2</TD><TD>Pending</TD><TD>0</TD><TD>Less Than 7 Days</TD><TD>04/08/2020 6:13:40 PM</TD></TR><TR><TD>{1234B}</TD><TD>2</TD><TD>2</TD><TD>3</TD><TD>Pending</TD><TD>0 00:46:35</TD><TD>Less Than 7 Days</TD><TD>05/08/2020 11:28:05 AM</TD></TR><TR><TD>{1234B}</TD><TD>2</TD><TD>1</TD><TD>2</TD><TD>Pending</TD><TD>0</TD><TD>Less Than 7 Days</TD><TD>05/08/2020 10:41:30 AM</TD></TR><TR><TD>{1234B}</TD><TD>1</TD><TD>2</TD><TD>2</TD><TD>Complete</TD><TD>0 04:24:59</TD><TD>Less Than 7 Days</TD><TD>04/08/2020 10:38:39 PM</TD></TR><TR><TD>{1234B}</TD><TD>1</TD><TD>1</TD><TD>2</TD><TD>Pending</TD><TD>0</TD><TD>Less Than 7 Days</TD><TD>04/08/2020 6:13:40 PM</TD></TR></TBODY></TABLE><P><SPAN><BR />What I require now is show only the pending status of the latest cycle in of 'Case ID'. The output required is as shown below:</SPAN>As you can see in the above data when the 'Stage'&nbsp; = 'Max stage in cycle 'the 'Status' is complete.</P><TABLE><TBODY><TR><TD>Case Identifier</TD><TD>Cycle</TD><TD>Stage</TD><TD>Max stages in the cycle</TD><TD>Overall Status</TD><TD>Time (Days and Hours)</TD><TD>SLA Time Scale</TD><TD>SLA.Time</TD></TR><TR><TD>{E075B973-0000-C511-B2FA-0428B188370D}</TD><TD>6</TD><TD>2</TD><TD>5</TD><TD>Pending</TD><TD>0 00:20:21</TD><TD>Less Than 7 Days</TD><TD>12/05/2021 10:06:20 AM</TD></TR><TR><TD>{E075B973-0000-C511-B2FA-0428B188370D}</TD><TD>6</TD><TD>1</TD><TD>5</TD><TD>Pending</TD><TD>0</TD><TD>Less Than 7 Days</TD><TD>12/05/2021 10:05:59 AM</TD></TR><TR><TD>{E075B973-0000-C511-B2FA-0428B188370D}</TD><TD>5</TD><TD>2</TD><TD>2</TD><TD>Complete</TD><TD>0 00:15:18</TD><TD>Less Than 7 Days</TD><TD>21/10/2020 10:21:15 AM</TD></TR><TR><TD>{E075B973-0000-C511-B2FA-0428B188370D}</TD><TD>4</TD><TD>2</TD><TD>2</TD><TD>Complete</TD><TD>0 00:07:21</TD><TD>Less Than 7 Days</TD><TD>20/10/2020 2:58:41 PM</TD></TR><TR><TD>{E075B973-0000-C511-B2FA-0428B188370D}</TD><TD>3</TD><TD>2</TD><TD>2</TD><TD>Complete</TD><TD>0 03:22:03</TD><TD>Less Than 7 Days</TD><TD>20/10/2020 2:37:09 PM</TD></TR><TR><TD>{E075B973-0000-C511-B2FA-0428B188370D}</TD><TD>2</TD><TD>2</TD><TD>2</TD><TD>Complete</TD><TD>0 00:46:35</TD><TD>Less Than 7 Days</TD><TD>05/08/2020 11:28:05 AM</TD></TR><TR><TD>{E075B973-0000-C511-B2FA-0428B188370D}</TD><TD>1</TD><TD>2</TD><TD>2</TD><TD>Complete</TD><TD>0 04:24:59</TD><TD>Less Than 7 Days</TD><TD>04/08/2020 10:38:39 PM</TD></TR><TR><TD>{1234B}</TD><TD>2</TD><TD>2</TD><TD>3</TD><TD>Pending</TD><TD>0 00:46:35</TD><TD>Less Than 7 Days</TD><TD>05/08/2020 11:28:05 AM</TD></TR><TR><TD>{1234B}</TD><TD>2</TD><TD>1</TD><TD>2</TD><TD>Pending</TD><TD>0</TD><TD>Less Than 7 Days</TD><TD>05/08/2020 10:41:30 AM</TD></TR><TR><TD>{1234B}</TD><TD>1</TD><TD>2</TD><TD>2</TD><TD>Complete</TD><TD>0 04:24:59</TD><TD>Less Than 7 Days</TD><TD>04/08/2020 10:38:39 PM</TD></TR></TBODY></TABLE><P>Please advice how this can be achieved,</P><P>&nbsp;</P><P>Thanks in advance</P> Fri, 14 May 2021 07:19:16 GMT Varun1 2021-05-14T07:19:16Z https://community.qlik.com/t5/App-Development/Display-Latest-Cycle/m-p/1807931#M65772 <P>Hi,</P><P>My data :</P><TABLE><TBODY><TR><TD>Case Identifier</TD><TD>Cycle</TD><TD>Stage</TD><TD>Max stages in the cycle</TD><TD>Overall Status</TD><TD>Time (Days and Hours)</TD><TD>SLA Time Scale</TD><TD>SLA.Time</TD></TR><TR><TD>{E075B973-0000-C511-B2FA-0428B188370D}</TD><TD>6</TD><TD>2</TD><TD>5</TD><TD>Pending</TD><TD>0 00:20:21</TD><TD>Less Than 7 Days</TD><TD>12/05/2021 10:06:20 AM</TD></TR><TR><TD>{E075B973-0000-C511-B2FA-0428B188370D}</TD><TD>6</TD><TD>1</TD><TD>5</TD><TD>Pending</TD><TD>0</TD><TD>Less Than 7 Days</TD><TD>12/05/2021 10:05:59 AM</TD></TR><TR><TD>{E075B973-0000-C511-B2FA-0428B188370D}</TD><TD>5</TD><TD>2</TD><TD>2</TD><TD>Complete</TD><TD>0 00:15:18</TD><TD>Less Than 7 Days</TD><TD>21/10/2020 10:21:15 AM</TD></TR><TR><TD>{E075B973-0000-C511-B2FA-0428B188370D}</TD><TD>5</TD><TD>1</TD><TD>2</TD><TD>Pending</TD><TD>0</TD><TD>Less Than 7 Days</TD><TD>21/10/2020 10:05:57 AM</TD></TR><TR><TD>{E075B973-0000-C511-B2FA-0428B188370D}</TD><TD>4</TD><TD>2</TD><TD>2</TD><TD>Complete</TD><TD>0 00:07:21</TD><TD>Less Than 7 Days</TD><TD>20/10/2020 2:58:41 PM</TD></TR><TR><TD>{E075B973-0000-C511-B2FA-0428B188370D}</TD><TD>4</TD><TD>1</TD><TD>2</TD><TD>Pending</TD><TD>0</TD><TD>Less Than 7 Days</TD><TD>20/10/2020 2:51:20 PM</TD></TR><TR><TD>{E075B973-0000-C511-B2FA-0428B188370D}</TD><TD>3</TD><TD>2</TD><TD>2</TD><TD>Complete</TD><TD>0 03:22:03</TD><TD>Less Than 7 Days</TD><TD>20/10/2020 2:37:09 PM</TD></TR><TR><TD>{E075B973-0000-C511-B2FA-0428B188370D}</TD><TD>3</TD><TD>1</TD><TD>2</TD><TD>Pending</TD><TD>0</TD><TD>Less Than 7 Days</TD><TD>20/10/2020 11:15:06 AM</TD></TR><TR><TD>{E075B973-0000-C511-B2FA-0428B188370D}</TD><TD>2</TD><TD>2</TD><TD>2</TD><TD>Complete</TD><TD>0 00:46:35</TD><TD>Less Than 7 Days</TD><TD>05/08/2020 11:28:05 AM</TD></TR><TR><TD>{E075B973-0000-C511-B2FA-0428B188370D}</TD><TD>2</TD><TD>1</TD><TD>2</TD><TD>Pending</TD><TD>0</TD><TD>Less Than 7 Days</TD><TD>05/08/2020 10:41:30 AM</TD></TR><TR><TD>{E075B973-0000-C511-B2FA-0428B188370D}</TD><TD>1</TD><TD>2</TD><TD>2</TD><TD>Complete</TD><TD>0 04:24:59</TD><TD>Less Than 7 Days</TD><TD>04/08/2020 10:38:39 PM</TD></TR><TR><TD>{E075B973-0000-C511-B2FA-0428B188370D}</TD><TD>1</TD><TD>1</TD><TD>2</TD><TD>Pending</TD><TD>0</TD><TD>Less Than 7 Days</TD><TD>04/08/2020 6:13:40 PM</TD></TR><TR><TD>{1234B}</TD><TD>2</TD><TD>2</TD><TD>3</TD><TD>Pending</TD><TD>0 00:46:35</TD><TD>Less Than 7 Days</TD><TD>05/08/2020 11:28:05 AM</TD></TR><TR><TD>{1234B}</TD><TD>2</TD><TD>1</TD><TD>2</TD><TD>Pending</TD><TD>0</TD><TD>Less Than 7 Days</TD><TD>05/08/2020 10:41:30 AM</TD></TR><TR><TD>{1234B}</TD><TD>1</TD><TD>2</TD><TD>2</TD><TD>Complete</TD><TD>0 04:24:59</TD><TD>Less Than 7 Days</TD><TD>04/08/2020 10:38:39 PM</TD></TR><TR><TD>{1234B}</TD><TD>1</TD><TD>1</TD><TD>2</TD><TD>Pending</TD><TD>0</TD><TD>Less Than 7 Days</TD><TD>04/08/2020 6:13:40 PM</TD></TR></TBODY></TABLE><P><SPAN><BR />What I require now is show only the pending status of the latest cycle in of 'Case ID'. The output required is as shown below:</SPAN>As you can see in the above data when the 'Stage'&nbsp; = 'Max stage in cycle 'the 'Status' is complete.</P><TABLE><TBODY><TR><TD>Case Identifier</TD><TD>Cycle</TD><TD>Stage</TD><TD>Max stages in the cycle</TD><TD>Overall Status</TD><TD>Time (Days and Hours)</TD><TD>SLA Time Scale</TD><TD>SLA.Time</TD></TR><TR><TD>{E075B973-0000-C511-B2FA-0428B188370D}</TD><TD>6</TD><TD>2</TD><TD>5</TD><TD>Pending</TD><TD>0 00:20:21</TD><TD>Less Than 7 Days</TD><TD>12/05/2021 10:06:20 AM</TD></TR><TR><TD>{E075B973-0000-C511-B2FA-0428B188370D}</TD><TD>6</TD><TD>1</TD><TD>5</TD><TD>Pending</TD><TD>0</TD><TD>Less Than 7 Days</TD><TD>12/05/2021 10:05:59 AM</TD></TR><TR><TD>{E075B973-0000-C511-B2FA-0428B188370D}</TD><TD>5</TD><TD>2</TD><TD>2</TD><TD>Complete</TD><TD>0 00:15:18</TD><TD>Less Than 7 Days</TD><TD>21/10/2020 10:21:15 AM</TD></TR><TR><TD>{E075B973-0000-C511-B2FA-0428B188370D}</TD><TD>4</TD><TD>2</TD><TD>2</TD><TD>Complete</TD><TD>0 00:07:21</TD><TD>Less Than 7 Days</TD><TD>20/10/2020 2:58:41 PM</TD></TR><TR><TD>{E075B973-0000-C511-B2FA-0428B188370D}</TD><TD>3</TD><TD>2</TD><TD>2</TD><TD>Complete</TD><TD>0 03:22:03</TD><TD>Less Than 7 Days</TD><TD>20/10/2020 2:37:09 PM</TD></TR><TR><TD>{E075B973-0000-C511-B2FA-0428B188370D}</TD><TD>2</TD><TD>2</TD><TD>2</TD><TD>Complete</TD><TD>0 00:46:35</TD><TD>Less Than 7 Days</TD><TD>05/08/2020 11:28:05 AM</TD></TR><TR><TD>{E075B973-0000-C511-B2FA-0428B188370D}</TD><TD>1</TD><TD>2</TD><TD>2</TD><TD>Complete</TD><TD>0 04:24:59</TD><TD>Less Than 7 Days</TD><TD>04/08/2020 10:38:39 PM</TD></TR><TR><TD>{1234B}</TD><TD>2</TD><TD>2</TD><TD>3</TD><TD>Pending</TD><TD>0 00:46:35</TD><TD>Less Than 7 Days</TD><TD>05/08/2020 11:28:05 AM</TD></TR><TR><TD>{1234B}</TD><TD>2</TD><TD>1</TD><TD>2</TD><TD>Pending</TD><TD>0</TD><TD>Less Than 7 Days</TD><TD>05/08/2020 10:41:30 AM</TD></TR><TR><TD>{1234B}</TD><TD>1</TD><TD>2</TD><TD>2</TD><TD>Complete</TD><TD>0 04:24:59</TD><TD>Less Than 7 Days</TD><TD>04/08/2020 10:38:39 PM</TD></TR></TBODY></TABLE><P>Please advice how this can be achieved,</P><P>&nbsp;</P><P>Thanks in advance</P> Fri, 14 May 2021 07:19:16 GMT https://community.qlik.com/t5/App-Development/Display-Latest-Cycle/m-p/1807931#M65772 Varun1 2021-05-14T07:19:16Z