topic Re: Set analysis does not limit data by date. FirstSortedValue in Integration, Extension & APIs https://community.qlik.com/t5/Integration-Extension-APIs/Set-analysis-does-not-limit-data-by-date-FirstSortedValue/m-p/1546890#M10041 <P>So trying to withdraw, and always shows the last price</P> Wed, 20 Feb 2019 12:48:29 GMT Svetlana1 2019-02-20T12:48:29Z Set analysis does not limit data by date. FirstSortedValue https://community.qlik.com/t5/Integration-Extension-APIs/Set-analysis-does-not-limit-data-by-date-FirstSortedValue/m-p/1546835#M10038 <P>Hey, guys. How do I display the last price of an item on the date of sale? Unable to set a date.</P><P>FirstSortedValue(${DateSales={""&gt;=$(Max(DatePrice))""}}price,-DatePrice)</P> Wed, 20 Feb 2019 11:21:16 GMT https://community.qlik.com/t5/Integration-Extension-APIs/Set-analysis-does-not-limit-data-by-date-FirstSortedValue/m-p/1546835#M10038 Svetlana1 2019-02-20T11:21:16Z Re: Set analysis does not limit data by date. FirstSortedValue https://community.qlik.com/t5/Integration-Extension-APIs/Set-analysis-does-not-limit-data-by-date-FirstSortedValue/m-p/1546861#M10039 <P>What if there are two prices for a particular DateSales with Max DatePrice?</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="image.png" style="width: 999px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/6414i88FDD32E9D090327/image-size/large?v=v2&amp;px=999" role="button" title="image.png" alt="image.png" /></span></P> Wed, 20 Feb 2019 12:00:30 GMT https://community.qlik.com/t5/Integration-Extension-APIs/Set-analysis-does-not-limit-data-by-date-FirstSortedValue/m-p/1546861#M10039 sunny_talwar 2019-02-20T12:00:30Z Re: Set analysis does not limit data by date. FirstSortedValue https://community.qlik.com/t5/Integration-Extension-APIs/Set-analysis-does-not-limit-data-by-date-FirstSortedValue/m-p/1546881#M10040 <P>display the maximum price</P> Wed, 20 Feb 2019 12:32:29 GMT https://community.qlik.com/t5/Integration-Extension-APIs/Set-analysis-does-not-limit-data-by-date-FirstSortedValue/m-p/1546881#M10040 Svetlana1 2019-02-20T12:32:29Z Re: Set analysis does not limit data by date. FirstSortedValue https://community.qlik.com/t5/Integration-Extension-APIs/Set-analysis-does-not-limit-data-by-date-FirstSortedValue/m-p/1546890#M10041 <P>So trying to withdraw, and always shows the last price</P> Wed, 20 Feb 2019 12:48:29 GMT https://community.qlik.com/t5/Integration-Extension-APIs/Set-analysis-does-not-limit-data-by-date-FirstSortedValue/m-p/1546890#M10041 Svetlana1 2019-02-20T12:48:29Z Re: Set analysis does not limit data by date. FirstSortedValue https://community.qlik.com/t5/Integration-Extension-APIs/Set-analysis-does-not-limit-data-by-date-FirstSortedValue/m-p/1546916#M10042 <P>Not sure I understand your requirement?</P> Wed, 20 Feb 2019 13:12:50 GMT https://community.qlik.com/t5/Integration-Extension-APIs/Set-analysis-does-not-limit-data-by-date-FirstSortedValue/m-p/1546916#M10042 sunny_talwar 2019-02-20T13:12:50Z Re: Set analysis does not limit data by date. FirstSortedValue https://community.qlik.com/t5/Integration-Extension-APIs/Set-analysis-does-not-limit-data-by-date-FirstSortedValue/m-p/1546943#M10043 <P>Example,<BR />at the DateSales 02.06.2018 и 10.06.2018 to bring the price from DatePrice 05.05.2018<BR />Since the DateSales 02.06.2018 the price of the product was 0.05</P><P>at the DateSales 09.07.2018 to bring the price from DatePrice 04.07.2018<BR />Since the DateSales 09.07.2018 the price of the product was 0.02</P> Wed, 20 Feb 2019 13:42:45 GMT https://community.qlik.com/t5/Integration-Extension-APIs/Set-analysis-does-not-limit-data-by-date-FirstSortedValue/m-p/1546943#M10043 Svetlana1 2019-02-20T13:42:45Z