topic Getting the info from the max date in QlikView https://community.qlik.com/t5/QlikView/Getting-the-info-from-the-max-date/m-p/747565#M266774 <HTML><HEAD></HEAD><BODY><P>Hi guys!</P><P></P><P>Need your help!!!</P><P></P><P>I have 2&nbsp; documents having the same field name like "Employee". </P><P>Here is the first table in Excel:</P><P><IMG class="image-1 jive-image" height="155" src="https://community.qlik.com/legacyfs/online/81242_pastedImage_0.png" style="width: 625.054347826087px; height: 155px;" width="625" /></P><P>There are&nbsp; fields with "Account" and Months, and I need to find the latest Account where the values end and start null values. I need to find the latest start date of the Account of some person and join the name of Account to the other table next to the name of Employee.</P><P></P><P>Can You help me please?</P></BODY></HTML> Thu, 19 Mar 2015 08:28:17 GMT 2015-03-19T08:28:17Z Getting the info from the max date https://community.qlik.com/t5/QlikView/Getting-the-info-from-the-max-date/m-p/747565#M266774 <HTML><HEAD></HEAD><BODY><P>Hi guys!</P><P></P><P>Need your help!!!</P><P></P><P>I have 2&nbsp; documents having the same field name like "Employee". </P><P>Here is the first table in Excel:</P><P><IMG class="image-1 jive-image" height="155" src="https://community.qlik.com/legacyfs/online/81242_pastedImage_0.png" style="width: 625.054347826087px; height: 155px;" width="625" /></P><P>There are&nbsp; fields with "Account" and Months, and I need to find the latest Account where the values end and start null values. I need to find the latest start date of the Account of some person and join the name of Account to the other table next to the name of Employee.</P><P></P><P>Can You help me please?</P></BODY></HTML> Thu, 19 Mar 2015 08:28:17 GMT https://community.qlik.com/t5/QlikView/Getting-the-info-from-the-max-date/m-p/747565#M266774 2015-03-19T08:28:17Z