topic Re: How to remove duplicates in FirstSortedValue? in QlikView https://community.qlik.com/t5/QlikView/How-to-remove-duplicates-in-FirstSortedValue/m-p/703245#M1262602 <HTML><HEAD></HEAD><BODY><P>Thanks for the reply Chander:)</P></BODY></HTML> Wed, 06 Aug 2014 13:55:52 GMT jansen28 2014-08-06T13:55:52Z How to remove duplicates in FirstSortedValue? https://community.qlik.com/t5/QlikView/How-to-remove-duplicates-in-FirstSortedValue/m-p/703243#M1262597 <HTML><HEAD></HEAD><BODY><P>Hi, I need to find which [Sales Person] has performed well in a country? Here is my input table</P><TABLE border="1" class="jiveBorder" style="border: 1px solid rgb(0, 0, 0); width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Country</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>State</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>City</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Sales Person</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>sale</STRONG></TH></TR><TR><TD style="padding: 2px;">Argentina</TD><TD style="padding: 2px;">Buenos Aires</TD><TD style="padding: 2px;">Ayacucho</TD><TD style="padding: 2px;">Pamela</TD><TD style="padding: 2px;">1200</TD></TR><TR><TD>Australia</TD><TD>New South Wales</TD><TD>Avalon</TD><TD>Anke</TD><TD>3600</TD></TR><TR><TD>Australia</TD><TD>New South Wales</TD><TD>Lindfiled</TD><TD>Jacob</TD><TD>3600</TD></TR><TR><TD>Austria</TD><TD>Vienna</TD><TD>Inner City</TD><TD>Corina</TD><TD>3600</TD></TR><TR><TD>Austria</TD><TD>Vienna</TD><TD>Mid City</TD><TD>Corine</TD><TD>5000</TD></TR><TR><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD></TR></TBODY></TABLE><P></P><P>My output in qlikview:</P><TABLE bgcolor="#ffffff" border="1" cellpadding="2" cellspacing="0" style="font-size: 9pt;"><TBODY><TR bgcolor="#f5f5f5"><TH nowrap="nowrap"><SPAN style="color: #363636;"><STRONG>Country</STRONG></SPAN><STRONG> </STRONG></TH><TH nowrap="nowrap"><SPAN style="color: #363636;"><STRONG>Largest Sales By SaleRep</STRONG></SPAN><STRONG> </STRONG></TH><TH nowrap="nowrap"><SPAN style="color: #363636;"><STRONG>FirstSortedValue(SalesPerson,-aggr(sum(Sale),Country,SalesPerson))</STRONG></SPAN><STRONG> </STRONG></TH></TR><TR bgcolor="#f5f5f5"><TD bgcolor="#f5f5f5"></TD><TD bgcolor="#f5f5f5"><STRONG>5000 </STRONG></TD><TD bgcolor="#f5f5f5"><STRONG>Mike </STRONG></TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">Argentia</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">1200</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">Jan</SPAN> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">Australia</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">3600</SPAN></TD><TD bgcolor="#ffffff"> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">Austria</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">5000</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">Mike</SPAN></TD></TR></TBODY></TABLE><P></P><P>So there is null value in my 2nd row. Hence how do I remove duplicate or how should I bring my top Performer with repeated value?</P><P>Any help appreciated?</P></BODY></HTML> Mon, 26 Jan 2026 18:19:17 GMT https://community.qlik.com/t5/QlikView/How-to-remove-duplicates-in-FirstSortedValue/m-p/703243#M1262597 jansen28 2026-01-26T18:19:17Z Re: How to remove duplicates in FirstSortedValue? https://community.qlik.com/t5/QlikView/How-to-remove-duplicates-in-FirstSortedValue/m-p/703244#M1262599 <HTML><HEAD></HEAD><BODY><P>As far as I know, first sorted value returns a blank/null when more than value has the same weight. So here two names could end up having the same sales and hence it is not able to return a value. You can pick one by changing the formula to FirstSortedValue(<STRONG>distinct</STRONG> SalesPerson,-aggr(sum(Sale),Country,SalesPerson))</P></BODY></HTML> Sun, 03 Aug 2014 19:00:50 GMT https://community.qlik.com/t5/QlikView/How-to-remove-duplicates-in-FirstSortedValue/m-p/703244#M1262599 2014-08-03T19:00:50Z Re: How to remove duplicates in FirstSortedValue? https://community.qlik.com/t5/QlikView/How-to-remove-duplicates-in-FirstSortedValue/m-p/703245#M1262602 <HTML><HEAD></HEAD><BODY><P>Thanks for the reply Chander:)</P></BODY></HTML> Wed, 06 Aug 2014 13:55:52 GMT https://community.qlik.com/t5/QlikView/How-to-remove-duplicates-in-FirstSortedValue/m-p/703245#M1262602 jansen28 2014-08-06T13:55:52Z