topic Re: How to: Get Max Value for make invitation list in QlikView https://community.qlik.com/t5/QlikView/How-to-Get-Max-Value-for-make-invitation-list/m-p/73522#M12139 <HTML><HEAD></HEAD><BODY><P>Try using FirstSortedValue()</P><P></P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/192836_Capture.PNG" style="height: 121px; width: 620px;" /></P></BODY></HTML> Thu, 08 Feb 2018 12:56:34 GMT sunny_talwar 2018-02-08T12:56:34Z How to: Get Max Value for make invitation list https://community.qlik.com/t5/QlikView/How-to-Get-Max-Value-for-make-invitation-list/m-p/73521#M12138 <HTML><HEAD></HEAD><BODY><P>I have raw data for prepare invitation list.<BR />For Invitation list I need to select agent name who will take care member, so I will select Agent who member have max(sum(sale)).</P><P>If you confuse about what I am talking about please see photo as attach file. <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Thu, 08 Feb 2018 12:05:44 GMT https://community.qlik.com/t5/QlikView/How-to-Get-Max-Value-for-make-invitation-list/m-p/73521#M12138 panwipa2528 2018-02-08T12:05:44Z Re: How to: Get Max Value for make invitation list https://community.qlik.com/t5/QlikView/How-to-Get-Max-Value-for-make-invitation-list/m-p/73522#M12139 <HTML><HEAD></HEAD><BODY><P>Try using FirstSortedValue()</P><P></P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/192836_Capture.PNG" style="height: 121px; width: 620px;" /></P></BODY></HTML> Thu, 08 Feb 2018 12:56:34 GMT https://community.qlik.com/t5/QlikView/How-to-Get-Max-Value-for-make-invitation-list/m-p/73522#M12139 sunny_talwar 2018-02-08T12:56:34Z Re: How to: Get Max Value for make invitation list https://community.qlik.com/t5/QlikView/How-to-Get-Max-Value-for-make-invitation-list/m-p/73523#M12140 <HTML><HEAD></HEAD><BODY><P>Sale is not field in dimension how should I do?</P></BODY></HTML> Fri, 09 Feb 2018 06:44:06 GMT https://community.qlik.com/t5/QlikView/How-to-Get-Max-Value-for-make-invitation-list/m-p/73523#M12140 panwipa2528 2018-02-09T06:44:06Z Re: How to: Get Max Value for make invitation list https://community.qlik.com/t5/QlikView/How-to-Get-Max-Value-for-make-invitation-list/m-p/73524#M12141 <HTML><HEAD></HEAD><BODY><P>Then how do you get sales value?</P></BODY></HTML> Fri, 09 Feb 2018 06:54:59 GMT https://community.qlik.com/t5/QlikView/How-to-Get-Max-Value-for-make-invitation-list/m-p/73524#M12141 tresB 2018-02-09T06:54:59Z Re: How to: Get Max Value for make invitation list https://community.qlik.com/t5/QlikView/How-to-Get-Max-Value-for-make-invitation-list/m-p/73525#M12142 <HTML><HEAD></HEAD><BODY><P>Either use Aggr in formula (see example) or preaggregate data in script with group by.</P><P></P><P>FirstSortedValue requires 1:1 relationship between sorted field and sort weight field, so you can't use it directly when your sort weight is a result of aggregation.</P></BODY></HTML> Fri, 09 Feb 2018 09:00:29 GMT https://community.qlik.com/t5/QlikView/How-to-Get-Max-Value-for-make-invitation-list/m-p/73525#M12142 kuba_michalik 2018-02-09T09:00:29Z Re: How to: Get Max Value for make invitation list https://community.qlik.com/t5/QlikView/How-to-Get-Max-Value-for-make-invitation-list/m-p/73526#M12143 <HTML><HEAD></HEAD><BODY><P>You can just do something like this</P><P></P><P><STRONG>FirstSortedValue(ShopName, -Aggr(Sum(Sales), MemberID))</STRONG></P></BODY></HTML> Sun, 11 Feb 2018 01:26:49 GMT https://community.qlik.com/t5/QlikView/How-to-Get-Max-Value-for-make-invitation-list/m-p/73526#M12143 sunny_talwar 2018-02-11T01:26:49Z