topic Selecting the first instance of the id status in QlikView https://community.qlik.com/t5/QlikView/Selecting-the-first-instance-of-the-id-status/m-p/1540729#M746607 <P>Hi,</P><P>&nbsp;</P><P>I have the below following data.</P><TABLE><TBODY><TR><TD>Test ID</TD><TD>Run ID</TD><TD>Result</TD></TR><TR><TD>1</TD><TD>1</TD><TD>Passed</TD></TR><TR><TD>1</TD><TD>2</TD><TD>Passed</TD></TR><TR><TD>1</TD><TD>3</TD><TD>Failed</TD></TR><TR><TD>1</TD><TD>4</TD><TD>Blocked&nbsp;</TD></TR><TR><TD>1</TD><TD>5</TD><TD>NA</TD></TR><TR><TD>2</TD><TD>6</TD><TD>Failed</TD></TR><TR><TD>2</TD><TD>7</TD><TD>Passed</TD></TR><TR><TD>2</TD><TD>8</TD><TD>Passed</TD></TR><TR><TD>3</TD><TD>9</TD><TD>NA</TD></TR><TR><TD>3</TD><TD>10</TD><TD>Passed</TD></TR><TR><TD>3</TD><TD>11</TD><TD>Passed</TD></TR><TR><TD>4</TD><TD>12</TD><TD>Passed</TD></TR><TR><TD>4</TD><TD>13</TD><TD>Passed</TD></TR><TR><TD>5</TD><TD>14</TD><TD>Failed</TD></TR><TR><TD>5</TD><TD>15</TD><TD>Passes</TD></TR><TR><TD>5</TD><TD>16</TD><TD>NA</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>I need the count of the test passed and failed the column TestId for the 1st instance in RunId. Other than these two status i need to ignore that particular row.</P><P>Expected Result :</P><TABLE><TBODY><TR><TD>Count of Passed=</TD><TD>2</TD></TR><TR><TD>Count of failed=</TD><TD>2</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>&nbsp;</P> Wed, 25 Nov 2020 16:16:04 GMT kiranb13 2020-11-25T16:16:04Z Selecting the first instance of the id status https://community.qlik.com/t5/QlikView/Selecting-the-first-instance-of-the-id-status/m-p/1540729#M746607 <P>Hi,</P><P>&nbsp;</P><P>I have the below following data.</P><TABLE><TBODY><TR><TD>Test ID</TD><TD>Run ID</TD><TD>Result</TD></TR><TR><TD>1</TD><TD>1</TD><TD>Passed</TD></TR><TR><TD>1</TD><TD>2</TD><TD>Passed</TD></TR><TR><TD>1</TD><TD>3</TD><TD>Failed</TD></TR><TR><TD>1</TD><TD>4</TD><TD>Blocked&nbsp;</TD></TR><TR><TD>1</TD><TD>5</TD><TD>NA</TD></TR><TR><TD>2</TD><TD>6</TD><TD>Failed</TD></TR><TR><TD>2</TD><TD>7</TD><TD>Passed</TD></TR><TR><TD>2</TD><TD>8</TD><TD>Passed</TD></TR><TR><TD>3</TD><TD>9</TD><TD>NA</TD></TR><TR><TD>3</TD><TD>10</TD><TD>Passed</TD></TR><TR><TD>3</TD><TD>11</TD><TD>Passed</TD></TR><TR><TD>4</TD><TD>12</TD><TD>Passed</TD></TR><TR><TD>4</TD><TD>13</TD><TD>Passed</TD></TR><TR><TD>5</TD><TD>14</TD><TD>Failed</TD></TR><TR><TD>5</TD><TD>15</TD><TD>Passes</TD></TR><TR><TD>5</TD><TD>16</TD><TD>NA</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>I need the count of the test passed and failed the column TestId for the 1st instance in RunId. Other than these two status i need to ignore that particular row.</P><P>Expected Result :</P><TABLE><TBODY><TR><TD>Count of Passed=</TD><TD>2</TD></TR><TR><TD>Count of failed=</TD><TD>2</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>&nbsp;</P> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Selecting-the-first-instance-of-the-id-status/m-p/1540729#M746607 kiranb13 2020-11-25T16:16:04Z Re: Selecting the first instance of the id status https://community.qlik.com/t5/QlikView/Selecting-the-first-instance-of-the-id-status/m-p/1540784#M746608 <P>See attached example</P> Thu, 07 Feb 2019 10:30:18 GMT https://community.qlik.com/t5/QlikView/Selecting-the-first-instance-of-the-id-status/m-p/1540784#M746608 Gysbert_Wassenaar 2019-02-07T10:30:18Z Re: Selecting the first instance of the id status https://community.qlik.com/t5/QlikView/Selecting-the-first-instance-of-the-id-status/m-p/1540835#M746609 Hi Gysbert,<BR />I am not able to get the result for the above expression. Thu, 07 Feb 2019 11:30:31 GMT https://community.qlik.com/t5/QlikView/Selecting-the-first-instance-of-the-id-status/m-p/1540835#M746609 kiranb13 2019-02-07T11:30:31Z Re: Selecting the first instance of the id status https://community.qlik.com/t5/QlikView/Selecting-the-first-instance-of-the-id-status/m-p/1540906#M746610 <P>What are you getting and what are you looking to get when you use&nbsp;<a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/18624">@Gysbert_Wassenaar</a>&nbsp;expression and calculated dimension?</P> Thu, 07 Feb 2019 13:25:42 GMT https://community.qlik.com/t5/QlikView/Selecting-the-first-instance-of-the-id-status/m-p/1540906#M746610 sunny_talwar 2019-02-07T13:25:42Z Re: Selecting the first instance of the id status https://community.qlik.com/t5/QlikView/Selecting-the-first-instance-of-the-id-status/m-p/1541401#M746611 <P>Data is not getting displayed, it's completely empty straight table. <span class="lia-inline-image-display-wrapper lia-image-align-center" image-alt="FirstSortedValue.PNG" style="width: 718px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/5502iE13F4B2475C33D23/image-size/large?v=v2&amp;px=999" role="button" title="FirstSortedValue.PNG" alt="FirstSortedValue.PNG" /></span></P><P>&nbsp;</P><P>&nbsp;</P> Fri, 08 Feb 2019 10:22:34 GMT https://community.qlik.com/t5/QlikView/Selecting-the-first-instance-of-the-id-status/m-p/1541401#M746611 kiranb13 2019-02-08T10:22:34Z Re: Selecting the first instance of the id status https://community.qlik.com/t5/QlikView/Selecting-the-first-instance-of-the-id-status/m-p/1541473#M746612 <P>It might be easier if you are able to share a sample to show what is going on?</P> Fri, 08 Feb 2019 12:18:37 GMT https://community.qlik.com/t5/QlikView/Selecting-the-first-instance-of-the-id-status/m-p/1541473#M746612 sunny_talwar 2019-02-08T12:18:37Z Re: Selecting the first instance of the id status https://community.qlik.com/t5/QlikView/Selecting-the-first-instance-of-the-id-status/m-p/1543518#M746613 <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="FTR.PNG" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/5830i803C32FD90E10BB2/image-size/medium?v=v2&amp;px=400" role="button" title="FTR.PNG" alt="FTR.PNG" /></span><BR /><BR /></P><P>Hi Sunny,</P><P>Above is requirement.&nbsp;</P><P>FTR=(No of TC's passed/(No of TC's passed+No of TC's failed))</P><P>I need TC's status Passed or Failed count at 1st instance.</P> Wed, 13 Feb 2019 10:16:05 GMT https://community.qlik.com/t5/QlikView/Selecting-the-first-instance-of-the-id-status/m-p/1543518#M746613 kiranb13 2019-02-13T10:16:05Z Re: Selecting the first instance of the id status https://community.qlik.com/t5/QlikView/Selecting-the-first-instance-of-the-id-status/m-p/1543578#M746614 <P>okay, sounds good</P> Wed, 13 Feb 2019 12:18:47 GMT https://community.qlik.com/t5/QlikView/Selecting-the-first-instance-of-the-id-status/m-p/1543578#M746614 sunny_talwar 2019-02-13T12:18:47Z Re: Selecting the first instance of the id status https://community.qlik.com/t5/QlikView/Selecting-the-first-instance-of-the-id-status/m-p/1544252#M746615 <P>Hi Sunny,</P><P>Did you get any chance to look into the above scenario ?</P> Thu, 14 Feb 2019 11:42:53 GMT https://community.qlik.com/t5/QlikView/Selecting-the-first-instance-of-the-id-status/m-p/1544252#M746615 kiranb13 2019-02-14T11:42:53Z Re: Selecting the first instance of the id status https://community.qlik.com/t5/QlikView/Selecting-the-first-instance-of-the-id-status/m-p/1544276#M746616 <P>Where do I need to look? I didn't see any sample attached? Am I missing something?</P> Thu, 14 Feb 2019 12:20:18 GMT https://community.qlik.com/t5/QlikView/Selecting-the-first-instance-of-the-id-status/m-p/1544276#M746616 sunny_talwar 2019-02-14T12:20:18Z