topic Re: How to fetch id with maximum date? in QlikView https://community.qlik.com/t5/QlikView/How-to-fetch-id-with-maximum-date/m-p/1544683#M744957 <P>Dimension1 - clsid</P><P>Dimension2 - partyid</P><P>&nbsp;</P><P>Measure1 - FirstSortedValue(accountid,-AccountOpeningDate)</P><P>Measure2 - FirstSortedValue(AccountOpeningDate,-AccountOpeningDate)</P> Fri, 15 Feb 2019 05:35:59 GMT pradosh_thakur 2019-02-15T05:35:59Z How to fetch id with maximum date? https://community.qlik.com/t5/QlikView/How-to-fetch-id-with-maximum-date/m-p/1544665#M744954 <P>&nbsp;</P><P>Hi All,</P><P>I have below data with me.&nbsp;</P><TABLE><TBODY><TR><TD>clsid&nbsp;</TD><TD>partyid</TD><TD>accountid</TD><TD>AccountOpeningDate&nbsp;</TD></TR><TR><TD>12111111</TD><TD>123</TD><TD>1000</TD><TD>23-05-2016</TD></TR><TR><TD>12111111</TD><TD>123</TD><TD>5000</TD><TD>24-03-2017</TD></TR><TR><TD>12111111</TD><TD>123</TD><TD>3000</TD><TD>12-03-2019</TD></TR><TR><TD>12111111</TD><TD>123</TD><TD>3999</TD><TD>25-09-2016</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>i want the below output from this. Please help. i want the record with account ID which is the latest.</P><TABLE><TBODY><TR><TD>clsid&nbsp;</TD><TD>partyid</TD><TD>accountid</TD><TD>AccountOpeningDate&nbsp;</TD></TR><TR><TD>12111111</TD><TD>123</TD><TD>3000</TD><TD>12-03-2019</TD></TR></TBODY></TABLE> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/How-to-fetch-id-with-maximum-date/m-p/1544665#M744954 fallenangel6 2020-11-25T16:16:04Z Re: How to fetch id with maximum date? https://community.qlik.com/t5/QlikView/How-to-fetch-id-with-maximum-date/m-p/1544667#M744955 <P>Something like:</P><P><EM>FirstSortedValue(clsid, -AccountOpeningDate)</EM></P> Fri, 15 Feb 2019 05:01:05 GMT https://community.qlik.com/t5/QlikView/How-to-fetch-id-with-maximum-date/m-p/1544667#M744955 jonathandienst 2019-02-15T05:01:05Z Re: How to fetch id with maximum date? https://community.qlik.com/t5/QlikView/How-to-fetch-id-with-maximum-date/m-p/1544683#M744957 <P>Dimension1 - clsid</P><P>Dimension2 - partyid</P><P>&nbsp;</P><P>Measure1 - FirstSortedValue(accountid,-AccountOpeningDate)</P><P>Measure2 - FirstSortedValue(AccountOpeningDate,-AccountOpeningDate)</P> Fri, 15 Feb 2019 05:35:59 GMT https://community.qlik.com/t5/QlikView/How-to-fetch-id-with-maximum-date/m-p/1544683#M744957 pradosh_thakur 2019-02-15T05:35:59Z Re: How to fetch id with maximum date? https://community.qlik.com/t5/QlikView/How-to-fetch-id-with-maximum-date/m-p/1544749#M744958 <P>Hi,</P><P>what if i have this data</P><P>&nbsp;</P><TABLE><TBODY><TR><TD>clsid&nbsp;</TD><TD>partyid</TD><TD>accountStatus</TD><TD>accountid</TD><TD>AccountOpeningDate&nbsp;</TD></TR><TR><TD>12111111</TD><TD>123</TD><TD>Active</TD><TD>1000</TD><TD>23-05-2016</TD></TR><TR><TD>12111111</TD><TD>123</TD><TD>Active</TD><TD>5000</TD><TD>24-03-2017</TD></TR><TR><TD>12111111</TD><TD>123</TD><TD>Closed</TD><TD>3000</TD><TD>12-03-2019</TD></TR><TR><TD>12111111</TD><TD>123</TD><TD>Closed</TD><TD>3999</TD><TD>25-09-2016</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>and my desired output is as below,</P><P>&nbsp;</P><TABLE><TBODY><TR><TD>clsid&nbsp;</TD><TD>partyid</TD><TD>accountStatus</TD><TD>accountid</TD><TD>AccountOpeningDate&nbsp;</TD></TR><TR><TD>12111111</TD><TD>123</TD><TD>Active</TD><TD>3000</TD><TD>12-03-2019</TD></TR></TBODY></TABLE> Fri, 15 Feb 2019 07:05:13 GMT https://community.qlik.com/t5/QlikView/How-to-fetch-id-with-maximum-date/m-p/1544749#M744958 fallenangel6 2019-02-15T07:05:13Z