topic Re: FirstSortedValue with equal values in QlikView https://community.qlik.com/t5/QlikView/FirstSortedValue-with-equal-values/m-p/58284#M9712 <HTML><HEAD></HEAD><BODY><P>One more thought on this though:</P><P>What if one contact has 2 different values on the same day. Which one will it pick? And will it produce the same "issue"?</P></BODY></HTML> Tue, 06 Feb 2018 14:02:09 GMT Anonymous 2018-02-06T14:02:09Z FirstSortedValue with equal values https://community.qlik.com/t5/QlikView/FirstSortedValue-with-equal-values/m-p/58281#M9709 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>I have the following 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>Wave</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>ActivityDate</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>ContactID</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>NPSSegment</STRONG></TH></TR><TR><TD style="padding: 2px;">1</TD><TD style="padding: 2px;">01/01/2018</TD><TD style="padding: 2px;">A</TD><TD style="padding: 2px;">Neutral</TD></TR><TR><TD style="padding: 2px;">1</TD><TD style="padding: 2px;">01/01/2018</TD><TD style="padding: 2px;">A</TD><TD style="padding: 2px;">Neutral</TD></TR><TR><TD style="padding: 2px;">1</TD><TD style="padding: 2px;">01/01/2018</TD><TD style="padding: 2px;">B</TD><TD style="padding: 2px;">Detractor</TD></TR><TR><TD style="padding: 2px;">1</TD><TD style="padding: 2px;">01/01/2018</TD><TD style="padding: 2px;">C</TD><TD style="padding: 2px;">Promotor</TD></TR></TBODY></TABLE><P></P><P>And the following script:</P><P style="font-size: 9px; font-family: 'Courier New'; color: #941100;"><SPAN style="color: #000000;">NPSSegments:<BR /> </SPAN><SPAN style="color: #0433ff;"><STRONG>LOAD</STRONG></SPAN><SPAN style="color: #000000;"> </SPAN><SPAN style="color: #0433ff;">FirstSortedValue</SPAN><SPAN style="color: #000000;">(</SPAN>NPSSegment<SPAN style="color: #000000;">,-</SPAN>ActivityDate<SPAN style="color: #000000;">) </SPAN><SPAN style="color: #0433ff;">as</SPAN><SPAN style="color: #000000;"> </SPAN>NPSSegmentPre<SPAN style="color: #000000;">,<BR /> </SPAN><SPAN style="color: #008f00;">//avg(round(NPSScore)) as AvgNPSScore,<BR /> </SPAN><SPAN style="color: #000000;">&nbsp; </SPAN>ContactID<SPAN style="color: #000000;"><BR /> </SPAN><SPAN style="color: #0433ff;">Resident</SPAN><SPAN style="color: #000000;"> NPSPreload<BR /> </SPAN><SPAN style="color: #0433ff;">Where</SPAN><SPAN style="color: #000000;"> </SPAN>Wave<SPAN style="color: #000000;"> = '0'<BR /> </SPAN><SPAN style="color: #0433ff;">Group</SPAN><SPAN style="color: #000000;"> </SPAN><SPAN style="color: #0433ff;">By</SPAN><SPAN style="color: #000000;"> </SPAN>ContactID<SPAN style="color: #000000;">; </SPAN></P><P><SPAN style="color: #000000;"><BR /></SPAN></P><P><SPAN style="color: #000000;">For ContactID A, there is no value. For B &amp; C, there is. </SPAN></P><P><SPAN style="color: #000000;">The issue I'm having is with the ContactID A. </SPAN></P><P><SPAN style="color: #000000;"><BR /></SPAN></P><P><SPAN style="color: #000000;">How can I make the script "pick" one (the latest based on the sorting of the load script) when the activity date is the same?</SPAN></P><P><SPAN style="color: #000000;">Now it's just returning nothing.</SPAN></P><P><SPAN style="color: #000000;"><BR /></SPAN></P><P><SPAN style="color: #000000;">As always, any help is greatly appreciated!</SPAN></P><P><SPAN style="color: #000000;"><BR /></SPAN></P><P><SPAN style="color: #000000;">Kind regards,</SPAN></P><P><SPAN style="color: #000000;">Christophe<BR /></SPAN></P></BODY></HTML> Tue, 06 Feb 2018 12:48:43 GMT https://community.qlik.com/t5/QlikView/FirstSortedValue-with-equal-values/m-p/58281#M9709 Anonymous 2018-02-06T12:48:43Z Re: FirstSortedValue with equal values https://community.qlik.com/t5/QlikView/FirstSortedValue-with-equal-values/m-p/58282#M9710 <HTML><HEAD></HEAD><BODY><P>Try this</P><P></P><P><STRONG>FirstSortedValue(<SPAN style="color: #ff0000;">DISTINCT</SPAN> NPSSegment,-ActivityDate) as NPSSegmentPre,</STRONG></P></BODY></HTML> Tue, 06 Feb 2018 12:53:20 GMT https://community.qlik.com/t5/QlikView/FirstSortedValue-with-equal-values/m-p/58282#M9710 sunny_talwar 2018-02-06T12:53:20Z Re: FirstSortedValue with equal values https://community.qlik.com/t5/QlikView/FirstSortedValue-with-equal-values/m-p/58283#M9711 <HTML><HEAD></HEAD><BODY><P>It worked, thanks!</P></BODY></HTML> Tue, 06 Feb 2018 14:00:45 GMT https://community.qlik.com/t5/QlikView/FirstSortedValue-with-equal-values/m-p/58283#M9711 Anonymous 2018-02-06T14:00:45Z Re: FirstSortedValue with equal values https://community.qlik.com/t5/QlikView/FirstSortedValue-with-equal-values/m-p/58284#M9712 <HTML><HEAD></HEAD><BODY><P>One more thought on this though:</P><P>What if one contact has 2 different values on the same day. Which one will it pick? And will it produce the same "issue"?</P></BODY></HTML> Tue, 06 Feb 2018 14:02:09 GMT https://community.qlik.com/t5/QlikView/FirstSortedValue-with-equal-values/m-p/58284#M9712 Anonymous 2018-02-06T14:02:09Z Re: FirstSortedValue with equal values https://community.qlik.com/t5/QlikView/FirstSortedValue-with-equal-values/m-p/58285#M9713 <HTML><HEAD></HEAD><BODY><P>It will pick on of them randomly. But is there a preference to what should be picked?</P></BODY></HTML> Tue, 06 Feb 2018 14:04:13 GMT https://community.qlik.com/t5/QlikView/FirstSortedValue-with-equal-values/m-p/58285#M9713 sunny_talwar 2018-02-06T14:04:13Z