topic How to apply firstsorted function for below case. in QlikView https://community.qlik.com/t5/QlikView/How-to-apply-firstsorted-function-for-below-case/m-p/1252819#M396309 <HTML><HEAD></HEAD><BODY><P>Dear All,</P><P></P><P>I have one requirement to find unique value.so please help me and check how we can do on script level.</P><P><SPAN style="font-size: 10pt;"><BR /></SPAN></P><P><SPAN style="font-size: 10pt;">INPUT:-<BR /></SPAN></P><P><SPAN style="font-size: 10pt;"> <IMG alt="Input.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/146471_Input.PNG" style="height: auto;" /></SPAN></P><P></P><P><SPAN style="font-size: 13.3333px;">Output:-</SPAN></P><P><IMG alt="output.PNG" class="jive-image image-2" src="https://community.qlik.com/legacyfs/online/146472_output.PNG" style="height: auto;" /></P></BODY></HTML> Tue, 13 Dec 2016 11:57:50 GMT 2016-12-13T11:57:50Z How to apply firstsorted function for below case. https://community.qlik.com/t5/QlikView/How-to-apply-firstsorted-function-for-below-case/m-p/1252819#M396309 <HTML><HEAD></HEAD><BODY><P>Dear All,</P><P></P><P>I have one requirement to find unique value.so please help me and check how we can do on script level.</P><P><SPAN style="font-size: 10pt;"><BR /></SPAN></P><P><SPAN style="font-size: 10pt;">INPUT:-<BR /></SPAN></P><P><SPAN style="font-size: 10pt;"> <IMG alt="Input.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/146471_Input.PNG" style="height: auto;" /></SPAN></P><P></P><P><SPAN style="font-size: 13.3333px;">Output:-</SPAN></P><P><IMG alt="output.PNG" class="jive-image image-2" src="https://community.qlik.com/legacyfs/online/146472_output.PNG" style="height: auto;" /></P></BODY></HTML> Tue, 13 Dec 2016 11:57:50 GMT https://community.qlik.com/t5/QlikView/How-to-apply-firstsorted-function-for-below-case/m-p/1252819#M396309 2016-12-13T11:57:50Z Re: How to apply firstsorted function for below case. https://community.qlik.com/t5/QlikView/How-to-apply-firstsorted-function-for-below-case/m-p/1252820#M396310 <HTML><HEAD></HEAD><BODY><P>May be like this</P><P></P><P><STRONG>LOAD Company,</STRONG></P><P><STRONG>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Date(Max(Date)) as Date,</STRONG></P><P><STRONG>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; FirstValue([Sales Person]) as [Sales Person]</STRONG></P><P><STRONG>FROM ....</STRONG></P><P><STRONG>Group By Company</STRONG></P></BODY></HTML> Tue, 13 Dec 2016 12:09:25 GMT https://community.qlik.com/t5/QlikView/How-to-apply-firstsorted-function-for-below-case/m-p/1252820#M396310 sunny_talwar 2016-12-13T12:09:25Z