topic Re: Sales Data for max Date in Qlik Learning Discussions https://community.qlik.com/t5/Qlik-Learning-Discussions/Sales-Data-for-max-Date/m-p/678824#M459 <HTML><HEAD></HEAD><BODY><P>FirstSortedValue(Sales,-Date)</P></BODY></HTML> Sat, 30 Aug 2014 19:10:06 GMT MK_QSL 2014-08-30T19:10:06Z Sales Data for max Date https://community.qlik.com/t5/Qlik-Learning-Discussions/Sales-Data-for-max-Date/m-p/678823#M458 <HTML><HEAD></HEAD><BODY><P>Hi!</P><P>I need to create report with sales data by customers related to the latest sales date for each.</P><P>Yellow lines in the table below are what i need to extract.</P><P><SPAN style="line-height: 1.5em; font-size: 10pt;"><IMG alt="Capture.PNG.png" class="jive-image" height="118" src="https://community.qlik.com/legacyfs/online/65599_Capture.PNG.png" style="height: 118px; width: 178.6164383561644px;" width="179" /> </SPAN></P><P>I use an expression: <EM>aggr(max(Date),[Customer])</EM> and get right date for every Customer.</P><P>Then i try to use this expression for sales data: <EM>sum({$&lt;Date={"=aggr(max(Date),[Customer])"}&gt;}Sales)&nbsp; </EM></P><P>and get a wrong result.</P><P></P><P>Thanks in advance. </P></BODY></HTML> Sat, 30 Aug 2014 14:21:23 GMT https://community.qlik.com/t5/Qlik-Learning-Discussions/Sales-Data-for-max-Date/m-p/678823#M458 turodionova 2014-08-30T14:21:23Z Re: Sales Data for max Date https://community.qlik.com/t5/Qlik-Learning-Discussions/Sales-Data-for-max-Date/m-p/678824#M459 <HTML><HEAD></HEAD><BODY><P>FirstSortedValue(Sales,-Date)</P></BODY></HTML> Sat, 30 Aug 2014 19:10:06 GMT https://community.qlik.com/t5/Qlik-Learning-Discussions/Sales-Data-for-max-Date/m-p/678824#M459 MK_QSL 2014-08-30T19:10:06Z Re: Sales Data for max Date https://community.qlik.com/t5/Qlik-Learning-Discussions/Sales-Data-for-max-Date/m-p/678825#M460 <HTML><HEAD></HEAD><BODY><P>Was it exactly what you were looking for Tamara? Did it work?</P></BODY></HTML> Mon, 01 Sep 2014 11:40:40 GMT https://community.qlik.com/t5/Qlik-Learning-Discussions/Sales-Data-for-max-Date/m-p/678825#M460 Agis-Kalogiannis 2014-09-01T11:40:40Z Re: Sales Data for max Date https://community.qlik.com/t5/Qlik-Learning-Discussions/Sales-Data-for-max-Date/m-p/678826#M461 <HTML><HEAD></HEAD><BODY><P>Hi, Agis!</P><P>It does not work unfortunately in my case. I guess some grouping is </P><P>needed?</P><P></P><P></P><P></P><P>Kind regards</P><P>Tamara Rodionova</P><P></P><P>Colgate-Palmolive Russia.</P><P>Senior Sales Analyst</P><P>Office phone +7495 937 11 00 (ext. 2-822)</P></BODY></HTML> Mon, 01 Sep 2014 12:12:44 GMT https://community.qlik.com/t5/Qlik-Learning-Discussions/Sales-Data-for-max-Date/m-p/678826#M461 turodionova 2014-09-01T12:12:44Z Re: Sales Data for max Date https://community.qlik.com/t5/Qlik-Learning-Discussions/Sales-Data-for-max-Date/m-p/678827#M462 <HTML><HEAD></HEAD><BODY><P>Provide few more data which showing that this is not working.... This should work on the sample data you have provided.</P></BODY></HTML> Mon, 01 Sep 2014 12:18:45 GMT https://community.qlik.com/t5/Qlik-Learning-Discussions/Sales-Data-for-max-Date/m-p/678827#M462 MK_QSL 2014-09-01T12:18:45Z Re: Sales Data for max Date https://community.qlik.com/t5/Qlik-Learning-Discussions/Sales-Data-for-max-Date/m-p/678828#M463 <HTML><HEAD></HEAD><BODY><P>Sales - ,</P><P>Date - Дата </P><P></P><P></P><P></P><P>Kind regards</P><P>Tamara Rodionova</P><P></P><P>Colgate-Palmolive Russia.</P><P>Senior Sales Analyst</P><P>Office phone +7495 937 11 00 (ext. 2-822)</P></BODY></HTML> Mon, 01 Sep 2014 12:35:32 GMT https://community.qlik.com/t5/Qlik-Learning-Discussions/Sales-Data-for-max-Date/m-p/678828#M463 turodionova 2014-09-01T12:35:32Z Re: Sales Data for max Date https://community.qlik.com/t5/Qlik-Learning-Discussions/Sales-Data-for-max-Date/m-p/678829#M464 <HTML><HEAD></HEAD><BODY><P>here you have an example for this</P></BODY></HTML> Mon, 01 Sep 2014 12:58:40 GMT https://community.qlik.com/t5/Qlik-Learning-Discussions/Sales-Data-for-max-Date/m-p/678829#M464 ecolomer 2014-09-01T12:58:40Z Re: Sales Data for max Date https://community.qlik.com/t5/Qlik-Learning-Discussions/Sales-Data-for-max-Date/m-p/678830#M465 <HTML><HEAD></HEAD><BODY><P>Can you create little dummy data and pass to us? Your application is difficult to understand..</P></BODY></HTML> Mon, 01 Sep 2014 13:13:04 GMT https://community.qlik.com/t5/Qlik-Learning-Discussions/Sales-Data-for-max-Date/m-p/678830#M465 MK_QSL 2014-09-01T13:13:04Z Re: Sales Data for max Date https://community.qlik.com/t5/Qlik-Learning-Discussions/Sales-Data-for-max-Date/m-p/678831#M466 <HTML><HEAD></HEAD><BODY><P>Manish, your expression works in a model with dummy data, so the issue is </P><P>in my application. </P><P>I will try to identify, thanks for your help. </P><P></P><P></P><P></P><P>Kind regards</P><P>Tamara Rodionova</P><P></P><P>Colgate-Palmolive Russia.</P><P>Senior Sales Analyst</P><P>Office phone +7495 937 11 00 (ext. 2-822)</P></BODY></HTML> Mon, 01 Sep 2014 14:36:44 GMT https://community.qlik.com/t5/Qlik-Learning-Discussions/Sales-Data-for-max-Date/m-p/678831#M466 turodionova 2014-09-01T14:36:44Z Re: Sales Data for max Date https://community.qlik.com/t5/Qlik-Learning-Discussions/Sales-Data-for-max-Date/m-p/678832#M467 <HTML><HEAD></HEAD><BODY><P>Manish, it worked, but as soon as i concatenate additional value, it </P><P>stopped working. </P><P></P><P>Kind regards</P><P>Tamara Rodionova</P><P></P><P>Colgate-Palmolive Russia.</P><P>Senior Sales Analyst</P><P>Office phone +7495 937 11 00 (ext. 2-822)</P></BODY></HTML> Mon, 01 Sep 2014 14:54:44 GMT https://community.qlik.com/t5/Qlik-Learning-Discussions/Sales-Data-for-max-Date/m-p/678832#M467 turodionova 2014-09-01T14:54:44Z Re: Sales Data for max Date https://community.qlik.com/t5/Qlik-Learning-Discussions/Sales-Data-for-max-Date/m-p/678833#M468 <HTML><HEAD></HEAD><BODY><P>try with</P><P>SubField( concat( Sales, '@', -Date), '@', 1)</P></BODY></HTML> Mon, 01 Sep 2014 19:44:59 GMT https://community.qlik.com/t5/Qlik-Learning-Discussions/Sales-Data-for-max-Date/m-p/678833#M468 maxgro 2014-09-01T19:44:59Z