topic Search Max Date Sales in QlikView https://community.qlik.com/t5/QlikView/Search-Max-Date-Sales/m-p/1099916#M628963 <HTML><HEAD></HEAD><BODY><P>Hi folks!</P><P>&nbsp;&nbsp; Recently i receive one solicitation, the solicitation is create a sales product no sales, and take the respective last date of sales, this mean, search in may database the max data of sale, product by product. Easy, just make a max(datasale) in SLQ and catch...Is not too simples, because a have group by in a all movement product table, of two year, this delay a lot. So i did this, i load all sales in qlikview and manage a column insed pivot table, make MAXSTRING(DateSale), ok...work it, but soon after a have catch de cost sales that product in the max datasale, and i not get, anyway, because a column Max(DateSales) in not a dimension.</P><P>How a make to get this.</P><P>sum(if(DataSale = Max(DataSales),CostSale))&nbsp; ??</P><P>Sample below.</P><P>Sorry by my english!!!</P><P></P><P>Thank you!</P></BODY></HTML> Fri, 12 Aug 2016 12:34:35 GMT Anonymous 2016-08-12T12:34:35Z Search Max Date Sales https://community.qlik.com/t5/QlikView/Search-Max-Date-Sales/m-p/1099916#M628963 <HTML><HEAD></HEAD><BODY><P>Hi folks!</P><P>&nbsp;&nbsp; Recently i receive one solicitation, the solicitation is create a sales product no sales, and take the respective last date of sales, this mean, search in may database the max data of sale, product by product. Easy, just make a max(datasale) in SLQ and catch...Is not too simples, because a have group by in a all movement product table, of two year, this delay a lot. So i did this, i load all sales in qlikview and manage a column insed pivot table, make MAXSTRING(DateSale), ok...work it, but soon after a have catch de cost sales that product in the max datasale, and i not get, anyway, because a column Max(DateSales) in not a dimension.</P><P>How a make to get this.</P><P>sum(if(DataSale = Max(DataSales),CostSale))&nbsp; ??</P><P>Sample below.</P><P>Sorry by my english!!!</P><P></P><P>Thank you!</P></BODY></HTML> Fri, 12 Aug 2016 12:34:35 GMT https://community.qlik.com/t5/QlikView/Search-Max-Date-Sales/m-p/1099916#M628963 Anonymous 2016-08-12T12:34:35Z Re: Search Max Date Sales https://community.qlik.com/t5/QlikView/Search-Max-Date-Sales/m-p/1099917#M628964 <HTML><HEAD></HEAD><BODY><P>Try this:</P><P></P><P><STRONG>FirstSortedValue(COSTSALES, -DATASALES)</STRONG></P><P><STRONG><BR /></STRONG></P><P><STRONG><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/134458_Capture.PNG" style="height: auto;" /><BR /></STRONG></P></BODY></HTML> Fri, 12 Aug 2016 14:12:40 GMT https://community.qlik.com/t5/QlikView/Search-Max-Date-Sales/m-p/1099917#M628964 sunny_talwar 2016-08-12T14:12:40Z Re: Search Max Date Sales https://community.qlik.com/t5/QlikView/Search-Max-Date-Sales/m-p/1099918#M628965 <HTML><HEAD></HEAD><BODY><P>Very good man ... thanks thanks .</P><P>I research about FirstSortedValue understad and how it work ... The next time i will make by myself&nbsp; =D !</P><P>Thank you again ... !!!!</P></BODY></HTML> Fri, 12 Aug 2016 14:28:27 GMT https://community.qlik.com/t5/QlikView/Search-Max-Date-Sales/m-p/1099918#M628965 Anonymous 2016-08-12T14:28:27Z