https://community.qlik.com/t5/App-Development/Alternative-combination-of-FirstSortedValue-and-Group-By-in-UI/m-p/1758849#M58640 <P>Hi folks,&nbsp;</P><P>My table&nbsp;</P><TABLE><TBODY><TR><TD>Title</TD><TD>Date</TD><TD>LAST_STATE</TD></TR><TR><TD>Title 1</TD><TD>1/10/2020 1:38:47 PM</TD><TD>None</TD></TR><TR><TD>Title 1</TD><TD>1/10/2020 2:38:47 PM</TD><TD>None</TD></TR><TR><TD>Title 1</TD><TD>1/10/2020 3:38:47 PM</TD><TD>None</TD></TR><TR><TD>Title 1</TD><TD>1/10/2020 4:38:47 PM</TD><TD>None</TD></TR><TR><TD>Title 1</TD><TD>1/10/2020 5:38:47 PM</TD><TD>None</TD></TR><TR><TD>Title 2</TD><TD>1/10/2020 1:38:47 PM</TD><TD>Passed</TD></TR><TR><TD>Title 2</TD><TD>1/10/2020 2:38:47 PM</TD><TD>Passed</TD></TR><TR><TD>Title 2</TD><TD>1/10/2020 3:38:47 PM</TD><TD>Passed</TD></TR><TR><TD>Title 2</TD><TD>1/10/2020 4:38:47 PM</TD><TD>Passed</TD></TR><TR><TD>Title 2</TD><TD>1/10/2020 5:38:47 PM</TD><TD>Passed</TD></TR></TBODY></TABLE><P>My expected result in UI(straight table):</P><TABLE><TBODY><TR><TD>Title</TD><TD>Date</TD><TD>LAST_STATE</TD></TR><TR><TD>Title 1</TD><TD>1/10/2020 1:38:47 PM</TD><TD>&nbsp;</TD></TR><TR><TD>Title 1</TD><TD>1/10/2020 2:38:47 PM</TD><TD>&nbsp;</TD></TR><TR><TD>Title 1</TD><TD>1/10/2020 3:38:47 PM</TD><TD>&nbsp;</TD></TR><TR><TD>Title 1</TD><TD>1/10/2020 4:38:47 PM</TD><TD>&nbsp;</TD></TR><TR><TD>Title 1</TD><TD>1/10/2020 5:38:47 PM</TD><TD>None</TD></TR><TR><TD>Title 2</TD><TD>1/10/2020 1:38:47 PM</TD><TD>&nbsp;</TD></TR><TR><TD>Title 2</TD><TD>1/10/2020 2:38:47 PM</TD><TD>&nbsp;</TD></TR><TR><TD>Title 2</TD><TD>1/10/2020 3:38:47 PM</TD><TD>&nbsp;</TD></TR><TR><TD>Title 2</TD><TD>1/10/2020 4:38:47 PM</TD><TD>&nbsp;</TD></TR><TR><TD>Title 2</TD><TD>1/10/2020 5:38:47 PM</TD><TD>Passed</TD></TR></TBODY></TABLE><P>As you see Last_State need to be group by Title and should show State where the latest Date occurs&nbsp;</P><P>It's working when I have one dimension and one measures Like below, but i need to add dimensions, SO WHEN i ADD dimensions&nbsp; it's stop working:</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Micki_0-1604597442759.png" style="width: 699px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/43645iD68CAA5AB7D0F077/image-dimensions/699x124?v=v2" width="699" height="124" role="button" title="Micki_0-1604597442759.png" alt="Micki_0-1604597442759.png" /></span></P><P>Any ideas ?&nbsp;</P><P><a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/46628">@sunny_talwar</a>&nbsp;,&nbsp;<a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/18624">@Gysbert_Wassenaar</a>&nbsp;,&nbsp;<a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/22245">@swuehl</a>&nbsp;,&nbsp;<a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/41481">@petter</a>&nbsp;,&nbsp;<a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/28684">@kaushiknsolanki</a>,&nbsp;<a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/22949">@tresB</a>&nbsp;</P> Thu, 05 Nov 2020 17:39:54 GMT Micki 2020-11-05T17:39:54Z https://community.qlik.com/t5/App-Development/Alternative-combination-of-FirstSortedValue-and-Group-By-in-UI/m-p/1758849#M58640 <P>Hi folks,&nbsp;</P><P>My table&nbsp;</P><TABLE><TBODY><TR><TD>Title</TD><TD>Date</TD><TD>LAST_STATE</TD></TR><TR><TD>Title 1</TD><TD>1/10/2020 1:38:47 PM</TD><TD>None</TD></TR><TR><TD>Title 1</TD><TD>1/10/2020 2:38:47 PM</TD><TD>None</TD></TR><TR><TD>Title 1</TD><TD>1/10/2020 3:38:47 PM</TD><TD>None</TD></TR><TR><TD>Title 1</TD><TD>1/10/2020 4:38:47 PM</TD><TD>None</TD></TR><TR><TD>Title 1</TD><TD>1/10/2020 5:38:47 PM</TD><TD>None</TD></TR><TR><TD>Title 2</TD><TD>1/10/2020 1:38:47 PM</TD><TD>Passed</TD></TR><TR><TD>Title 2</TD><TD>1/10/2020 2:38:47 PM</TD><TD>Passed</TD></TR><TR><TD>Title 2</TD><TD>1/10/2020 3:38:47 PM</TD><TD>Passed</TD></TR><TR><TD>Title 2</TD><TD>1/10/2020 4:38:47 PM</TD><TD>Passed</TD></TR><TR><TD>Title 2</TD><TD>1/10/2020 5:38:47 PM</TD><TD>Passed</TD></TR></TBODY></TABLE><P>My expected result in UI(straight table):</P><TABLE><TBODY><TR><TD>Title</TD><TD>Date</TD><TD>LAST_STATE</TD></TR><TR><TD>Title 1</TD><TD>1/10/2020 1:38:47 PM</TD><TD>&nbsp;</TD></TR><TR><TD>Title 1</TD><TD>1/10/2020 2:38:47 PM</TD><TD>&nbsp;</TD></TR><TR><TD>Title 1</TD><TD>1/10/2020 3:38:47 PM</TD><TD>&nbsp;</TD></TR><TR><TD>Title 1</TD><TD>1/10/2020 4:38:47 PM</TD><TD>&nbsp;</TD></TR><TR><TD>Title 1</TD><TD>1/10/2020 5:38:47 PM</TD><TD>None</TD></TR><TR><TD>Title 2</TD><TD>1/10/2020 1:38:47 PM</TD><TD>&nbsp;</TD></TR><TR><TD>Title 2</TD><TD>1/10/2020 2:38:47 PM</TD><TD>&nbsp;</TD></TR><TR><TD>Title 2</TD><TD>1/10/2020 3:38:47 PM</TD><TD>&nbsp;</TD></TR><TR><TD>Title 2</TD><TD>1/10/2020 4:38:47 PM</TD><TD>&nbsp;</TD></TR><TR><TD>Title 2</TD><TD>1/10/2020 5:38:47 PM</TD><TD>Passed</TD></TR></TBODY></TABLE><P>As you see Last_State need to be group by Title and should show State where the latest Date occurs&nbsp;</P><P>It's working when I have one dimension and one measures Like below, but i need to add dimensions, SO WHEN i ADD dimensions&nbsp; it's stop working:</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Micki_0-1604597442759.png" style="width: 699px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/43645iD68CAA5AB7D0F077/image-dimensions/699x124?v=v2" width="699" height="124" role="button" title="Micki_0-1604597442759.png" alt="Micki_0-1604597442759.png" /></span></P><P>Any ideas ?&nbsp;</P><P><a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/46628">@sunny_talwar</a>&nbsp;,&nbsp;<a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/18624">@Gysbert_Wassenaar</a>&nbsp;,&nbsp;<a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/22245">@swuehl</a>&nbsp;,&nbsp;<a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/41481">@petter</a>&nbsp;,&nbsp;<a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/28684">@kaushiknsolanki</a>,&nbsp;<a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/22949">@tresB</a>&nbsp;</P> Thu, 05 Nov 2020 17:39:54 GMT https://community.qlik.com/t5/App-Development/Alternative-combination-of-FirstSortedValue-and-Group-By-in-UI/m-p/1758849#M58640 Micki 2020-11-05T17:39:54Z