https://community.qlik.com/t5/App-Development/Bring-back-latest-version/m-p/2547292#M110027 <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="gp_oconnor_0-1776698586291.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/187887iEDDB37FC3A864E47/image-size/medium?v=v2&amp;px=400" role="button" title="gp_oconnor_0-1776698586291.png" alt="gp_oconnor_0-1776698586291.png" /></span></P><P>If this is the result you're after, then the expression below works:<BR /><BR />=if(not IsNull(Only([parent_id])),<BR />if(Only([version]) = Max(total &lt;[parent_id]&gt; version),<BR />Only([parent_id]),<BR />0<BR />),<BR />if(Count({&lt;[leadbyte_id]=P([parent_id])&gt;} [leadbyte_id]) &gt; 0,<BR />0,<BR />Only([leadbyte_id])<BR />)<BR />)</P> Mon, 20 Apr 2026 15:25:20 GMT gp_oconnor 2026-04-20T15:25:20Z https://community.qlik.com/t5/App-Development/Bring-back-latest-version/m-p/2546828#M109993 <P><SPAN data-teams="true">Hi all. </SPAN></P> <P><SPAN data-teams="true">How do i bring back only the latest version (version 3 in this case) for leadbyte_id 400117. I assume i would need to use a combination of the parent_id and version somehow?</SPAN></P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Screenshot 2026-04-14 150727.png" style="width: 637px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/187777i0A69BD969E06A81A/image-size/large?v=v2&amp;px=999" role="button" title="Screenshot 2026-04-14 150727.png" alt="Screenshot 2026-04-14 150727.png" /></span></P> Tue, 14 Apr 2026 13:21:49 GMT https://community.qlik.com/t5/App-Development/Bring-back-latest-version/m-p/2546828#M109993 cclayford_ric 2026-04-14T13:21:49Z https://community.qlik.com/t5/App-Development/Bring-back-latest-version/m-p/2547292#M110027 <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="gp_oconnor_0-1776698586291.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/187887iEDDB37FC3A864E47/image-size/medium?v=v2&amp;px=400" role="button" title="gp_oconnor_0-1776698586291.png" alt="gp_oconnor_0-1776698586291.png" /></span></P><P>If this is the result you're after, then the expression below works:<BR /><BR />=if(not IsNull(Only([parent_id])),<BR />if(Only([version]) = Max(total &lt;[parent_id]&gt; version),<BR />Only([parent_id]),<BR />0<BR />),<BR />if(Count({&lt;[leadbyte_id]=P([parent_id])&gt;} [leadbyte_id]) &gt; 0,<BR />0,<BR />Only([leadbyte_id])<BR />)<BR />)</P> Mon, 20 Apr 2026 15:25:20 GMT https://community.qlik.com/t5/App-Development/Bring-back-latest-version/m-p/2547292#M110027 gp_oconnor 2026-04-20T15:25:20Z