topic query in QlikView https://community.qlik.com/t5/QlikView/query/m-p/1050704#M352759 <HTML><HEAD></HEAD><BODY><P>how to pick the list of regionwith Max RSM Code .so that only one RSM email id belong to one rsm for specific region</P></BODY></HTML> Fri, 08 Jan 2016 05:08:25 GMT 2016-01-08T05:08:25Z query https://community.qlik.com/t5/QlikView/query/m-p/1050704#M352759 <HTML><HEAD></HEAD><BODY><P>how to pick the list of regionwith Max RSM Code .so that only one RSM email id belong to one rsm for specific region</P></BODY></HTML> Fri, 08 Jan 2016 05:08:25 GMT https://community.qlik.com/t5/QlikView/query/m-p/1050704#M352759 2016-01-08T05:08:25Z Re: query https://community.qlik.com/t5/QlikView/query/m-p/1050705#M352760 <HTML><HEAD></HEAD><BODY><P>You can use the FirstSortedValue function for this: FirstSortedValue(Region, -RSMCode)</P></BODY></HTML> Fri, 08 Jan 2016 17:26:17 GMT https://community.qlik.com/t5/QlikView/query/m-p/1050705#M352760 Gysbert_Wassenaar 2016-01-08T17:26:17Z Re: query https://community.qlik.com/t5/QlikView/query/m-p/1050706#M352761 <HTML><HEAD></HEAD><BODY><P>Two different approaches:</P><P></P><P>1) via the Load script</P><P><IMG alt="2016-01-08 #1.PNG" class="jive-image image-1" src="/legacyfs/online/111096_2016-01-08 #1.PNG" style="height: auto;" /></P><P></P><P>2) Directly in the UI with expression:</P><P></P><P><IMG alt="2016-01-08 #2.PNG" class="jive-image image-2" src="/legacyfs/online/111097_2016-01-08 #2.PNG" style="height: auto;" /></P></BODY></HTML> Fri, 08 Jan 2016 17:32:47 GMT https://community.qlik.com/t5/QlikView/query/m-p/1050706#M352761 petter 2016-01-08T17:32:47Z