topic Sum where max in QlikView https://community.qlik.com/t5/QlikView/Sum-where-max/m-p/844231#M296519 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>there is a situation I never experienced before,</P><P>There is a customer, its value and its Sold Date, for each customer I have to find the values corresponding to max date.</P><P></P><P>I Always solved the problem in the script (in a very sinple way), now I am trying to write an expression to solve the question in the front end, I nearly did it but there is still a field I do not want to see. Is it possible to achive the result without including DateSold field as dimension? I do not want to hide the field, I do not want to include it!</P><P></P><P>Refer to the attached qvw.</P><P></P><P>Thanks</P></BODY></HTML> Wed, 17 Jun 2015 13:50:15 GMT alexandros17 2015-06-17T13:50:15Z Sum where max https://community.qlik.com/t5/QlikView/Sum-where-max/m-p/844231#M296519 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>there is a situation I never experienced before,</P><P>There is a customer, its value and its Sold Date, for each customer I have to find the values corresponding to max date.</P><P></P><P>I Always solved the problem in the script (in a very sinple way), now I am trying to write an expression to solve the question in the front end, I nearly did it but there is still a field I do not want to see. Is it possible to achive the result without including DateSold field as dimension? I do not want to hide the field, I do not want to include it!</P><P></P><P>Refer to the attached qvw.</P><P></P><P>Thanks</P></BODY></HTML> Wed, 17 Jun 2015 13:50:15 GMT https://community.qlik.com/t5/QlikView/Sum-where-max/m-p/844231#M296519 alexandros17 2015-06-17T13:50:15Z Re: Sum where max https://community.qlik.com/t5/QlikView/Sum-where-max/m-p/844232#M296520 <HTML><HEAD></HEAD><BODY><P>Try FirstSortedValue(Value, -DateSold)</P></BODY></HTML> Wed, 17 Jun 2015 14:01:33 GMT https://community.qlik.com/t5/QlikView/Sum-where-max/m-p/844232#M296520 Gysbert_Wassenaar 2015-06-17T14:01:33Z Re: Sum where max https://community.qlik.com/t5/QlikView/Sum-where-max/m-p/844233#M296521 <HTML><HEAD></HEAD><BODY><P>Great!</P></BODY></HTML> Wed, 17 Jun 2015 14:07:43 GMT https://community.qlik.com/t5/QlikView/Sum-where-max/m-p/844233#M296521 alexandros17 2015-06-17T14:07:43Z