https://community.qlik.com/t5/App-Development/aggr-selection-issue/m-p/1689681#M52658 <P>hi&nbsp;</P><P>use this expression :count(aggr( if(Date = max(total&lt;user&gt; Date), user),user,vp))</P><P>with vp as your dimension</P> Wed, 01 Apr 2020 06:00:44 GMT lironbaram 2020-04-01T06:00:44Z https://community.qlik.com/t5/App-Development/aggr-selection-issue/m-p/1689610#M52652 <P>Hi,</P><P>when using calculated dimension with aggr it select the user,</P><P>here is my dimension:</P><P>=Aggr(FirstSortedValue(vp, -Date), user)</P><P>can i make it select the vp?</P><P>the result in the table is correct.</P><P>please find attached qvf</P><P>thanks.</P><P>ido.</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Capture.PNG" style="width: 999px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/31013iFF96986EB7B8E870/image-size/large?v=v2&amp;px=999" role="button" title="Capture.PNG" alt="Capture.PNG" /></span></P> Tue, 31 Mar 2020 19:18:51 GMT https://community.qlik.com/t5/App-Development/aggr-selection-issue/m-p/1689610#M52652 idogridish2 2020-03-31T19:18:51Z https://community.qlik.com/t5/App-Development/aggr-selection-issue/m-p/1689681#M52658 <P>hi&nbsp;</P><P>use this expression :count(aggr( if(Date = max(total&lt;user&gt; Date), user),user,vp))</P><P>with vp as your dimension</P> Wed, 01 Apr 2020 06:00:44 GMT https://community.qlik.com/t5/App-Development/aggr-selection-issue/m-p/1689681#M52658 lironbaram 2020-04-01T06:00:44Z