topic How to pick one value in QlikView https://community.qlik.com/t5/QlikView/How-to-pick-one-value/m-p/168299#M39503 <HTML><HEAD></HEAD><BODY><P>you can use Firstsortedvalue(),Firstvalue()</P></BODY></HTML> Fri, 18 Mar 2011 09:23:29 GMT suniljain 2011-03-18T09:23:29Z How to pick one value https://community.qlik.com/t5/QlikView/How-to-pick-one-value/m-p/168298#M39502 <HTML><HEAD></HEAD><BODY><P>Hello All,</P><P>I'm sure this is an easy one for you.. I have a field where there should only ever be one value, but in the case of two I want to only want to select one.</P><P>I was thinking a min(site) or firstsortedvalue, but I don't have a date field or anything that I can use. I'm not bothered which one of the two values it uses, aslong as I only get one - so I was thinking of doing it within my load script.</P><P>I hope you can help me!</P><P>Kind Regards,<BR />Dayna</P></BODY></HTML> Fri, 18 Mar 2011 09:22:01 GMT https://community.qlik.com/t5/QlikView/How-to-pick-one-value/m-p/168298#M39502 Dayna 2011-03-18T09:22:01Z How to pick one value https://community.qlik.com/t5/QlikView/How-to-pick-one-value/m-p/168299#M39503 <HTML><HEAD></HEAD><BODY><P>you can use Firstsortedvalue(),Firstvalue()</P></BODY></HTML> Fri, 18 Mar 2011 09:23:29 GMT https://community.qlik.com/t5/QlikView/How-to-pick-one-value/m-p/168299#M39503 suniljain 2011-03-18T09:23:29Z How to pick one value https://community.qlik.com/t5/QlikView/How-to-pick-one-value/m-p/168300#M39504 <HTML><HEAD></HEAD><BODY><P>How do I use it within the load script, as I keep getting errors?</P><P>Firstsortedvalue I couldn't get to work due to the lack of a sort weight field as above, so looking at firstvalue().</P></BODY></HTML> Fri, 18 Mar 2011 09:28:29 GMT https://community.qlik.com/t5/QlikView/How-to-pick-one-value/m-p/168300#M39504 Dayna 2011-03-18T09:28:29Z How to pick one value https://community.qlik.com/t5/QlikView/How-to-pick-one-value/m-p/168301#M39505 <HTML><HEAD></HEAD><BODY><P>LOAD<BR /> DISTINCT SHIP_TO_CUSTOMER,<BR /> Firstvalue(SHIP_TO_CUST_GRP5_DESC) as SHIP_TO_CG5<BR /><BR />RESIDENT SHIP_TO GROUP BY SHIP_TO_CUSTOMER; //OK</P></BODY></HTML> Fri, 18 Mar 2011 09:35:18 GMT https://community.qlik.com/t5/QlikView/How-to-pick-one-value/m-p/168301#M39505 suniljain 2011-03-18T09:35:18Z How to pick one value https://community.qlik.com/t5/QlikView/How-to-pick-one-value/m-p/168302#M39506 <HTML><HEAD></HEAD><BODY><P>Hello Dayna,</P><P>Use MaxString() that works as any other aggregation function (needs a group by in the script and so).</P><P>Hope that helps.</P><P></P></BODY></HTML> Fri, 18 Mar 2011 09:36:20 GMT https://community.qlik.com/t5/QlikView/How-to-pick-one-value/m-p/168302#M39506 Miguel_Angel_Baeyens 2011-03-18T09:36:20Z How to pick one value https://community.qlik.com/t5/QlikView/How-to-pick-one-value/m-p/168303#M39507 <HTML><HEAD></HEAD><BODY><P>That's what I wanted! Cheers again Miguel!</P></BODY></HTML> Fri, 18 Mar 2011 11:00:34 GMT https://community.qlik.com/t5/QlikView/How-to-pick-one-value/m-p/168303#M39507 Dayna 2011-03-18T11:00:34Z