https://community.qlik.com/t5/App-Development/Latest-record-should-show-on-Date-field-and-multiple-Dimensions/m-p/1810386#M66034 <P>Hi All,</P><P>I trying to create one table which shows the Last_worked_date of each employee as a one row (Latest)</P><P>my Dimensions and Measures are like below</P><P>Name, job_title, email, last_worked_Date, division, production_name&nbsp;</P><P>expression:&nbsp;=Max({&lt;LAST_WORKED_DATE={"&gt;=$(=Addmonths(Max(Today()),-13))&lt;=$(=Addmonths(Max(Today()),-1))"},job_title={"*ACC*"}&gt;} LAST_WORKED_DATE)</P><P>but it showing like below two or more records for one person, instead i should show only one record the latest one as highlighted one.</P><P>Date column in MM/DD/YYYY format</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Capture.png" style="width: 889px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/55646iB1611E97589B3FE8/image-size/large?v=v2&amp;px=999" role="button" title="Capture.png" alt="Capture.png" /></span></P><P>Can any one suggest me on this please.</P><P>Thanks in advance</P><P>-Rajesh.</P><P>&nbsp;</P><P>&nbsp;</P> Tue, 25 May 2021 14:07:56 GMT Rajesh 2021-05-25T14:07:56Z https://community.qlik.com/t5/App-Development/Latest-record-should-show-on-Date-field-and-multiple-Dimensions/m-p/1810386#M66034 <P>Hi All,</P><P>I trying to create one table which shows the Last_worked_date of each employee as a one row (Latest)</P><P>my Dimensions and Measures are like below</P><P>Name, job_title, email, last_worked_Date, division, production_name&nbsp;</P><P>expression:&nbsp;=Max({&lt;LAST_WORKED_DATE={"&gt;=$(=Addmonths(Max(Today()),-13))&lt;=$(=Addmonths(Max(Today()),-1))"},job_title={"*ACC*"}&gt;} LAST_WORKED_DATE)</P><P>but it showing like below two or more records for one person, instead i should show only one record the latest one as highlighted one.</P><P>Date column in MM/DD/YYYY format</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Capture.png" style="width: 889px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/55646iB1611E97589B3FE8/image-size/large?v=v2&amp;px=999" role="button" title="Capture.png" alt="Capture.png" /></span></P><P>Can any one suggest me on this please.</P><P>Thanks in advance</P><P>-Rajesh.</P><P>&nbsp;</P><P>&nbsp;</P> Tue, 25 May 2021 14:07:56 GMT https://community.qlik.com/t5/App-Development/Latest-record-should-show-on-Date-field-and-multiple-Dimensions/m-p/1810386#M66034 Rajesh 2021-05-25T14:07:56Z