topic Re: Get data with lowest Date in QlikView https://community.qlik.com/t5/QlikView/Get-data-with-lowest-Date/m-p/41577#M6998 <HTML><HEAD></HEAD><BODY><P>May be try with FirstSortedValue...</P><P></P><P><STRONG>FirstSortedValue(DISTINCT ItemId, ImportDate)</STRONG></P></BODY></HTML> Fri, 02 Mar 2018 14:41:19 GMT sunny_talwar 2018-03-02T14:41:19Z Get data with lowest Date https://community.qlik.com/t5/QlikView/Get-data-with-lowest-Date/m-p/41576#M6997 <HTML><HEAD></HEAD><BODY><P>I'm trying to find out how to display the lowest value for a specific date to display in a textbox but haven't found anything that is working.</P><P></P><P>Show <STRONG>ItemId</STRONG> that has the <STRONG>lowest ImportDate</STRONG>. I have been trying out som Set-Analys but can I only use them together with some kind of aggregating function but I only want to show just the value(ItemId) with the lowest ImportDate.</P><P></P><P>/Frank </P></BODY></HTML> Fri, 02 Mar 2018 14:39:22 GMT https://community.qlik.com/t5/QlikView/Get-data-with-lowest-Date/m-p/41576#M6997 Anonymous 2018-03-02T14:39:22Z Re: Get data with lowest Date https://community.qlik.com/t5/QlikView/Get-data-with-lowest-Date/m-p/41577#M6998 <HTML><HEAD></HEAD><BODY><P>May be try with FirstSortedValue...</P><P></P><P><STRONG>FirstSortedValue(DISTINCT ItemId, ImportDate)</STRONG></P></BODY></HTML> Fri, 02 Mar 2018 14:41:19 GMT https://community.qlik.com/t5/QlikView/Get-data-with-lowest-Date/m-p/41577#M6998 sunny_talwar 2018-03-02T14:41:19Z Re: Get data with lowest Date https://community.qlik.com/t5/QlikView/Get-data-with-lowest-Date/m-p/41578#M6999 <HTML><HEAD></HEAD><BODY><P>Thanks that worked, I'll try it out and see if the result is what I wnt.</P></BODY></HTML> Fri, 02 Mar 2018 14:56:29 GMT https://community.qlik.com/t5/QlikView/Get-data-with-lowest-Date/m-p/41578#M6999 Anonymous 2018-03-02T14:56:29Z