topic Re: First unique value from different Fields in QlikView https://community.qlik.com/t5/QlikView/First-unique-value-from-different-Fields/m-p/504093#M1133806 <HTML><HEAD></HEAD><BODY><P>Hi Thank you, appreciate the help Shruthi</P></BODY></HTML> Thu, 28 Nov 2013 14:15:01 GMT 2013-11-28T14:15:01Z First unique value from different Fields https://community.qlik.com/t5/QlikView/First-unique-value-from-different-Fields/m-p/504091#M1133802 <HTML><HEAD></HEAD><BODY><P>Hi Qlikview Friends:</P><P></P><P>I have four different fields, but want to create a new field with the value from the first available field,</P><P>example as below:</P><P></P><P>Field1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Field2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Field3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Field4&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Newfield(Required)</P><P>-&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; A&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; B&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; A</P><P>B&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; C&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; D&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; B</P><P>-&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; B&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; D&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; E&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; B&nbsp; </P><P></P><P>Appreciate your help in advance.</P><P></P><P>thanks</P><P>Kumar</P><P><BR /> </P></BODY></HTML> Thu, 28 Nov 2013 10:52:38 GMT https://community.qlik.com/t5/QlikView/First-unique-value-from-different-Fields/m-p/504091#M1133802 2013-11-28T10:52:38Z Re: First unique value from different Fields https://community.qlik.com/t5/QlikView/First-unique-value-from-different-Fields/m-p/504092#M1133803 <HTML><HEAD></HEAD><BODY><P>Hi Kumar,</P><P></P><P>Please see the script in the attached QVW.</P><P></P><P>Thanks,</P><P>Shruthi</P></BODY></HTML> Thu, 28 Nov 2013 11:15:38 GMT https://community.qlik.com/t5/QlikView/First-unique-value-from-different-Fields/m-p/504092#M1133803 2013-11-28T11:15:38Z Re: First unique value from different Fields https://community.qlik.com/t5/QlikView/First-unique-value-from-different-Fields/m-p/504093#M1133806 <HTML><HEAD></HEAD><BODY><P>Hi Thank you, appreciate the help Shruthi</P></BODY></HTML> Thu, 28 Nov 2013 14:15:01 GMT https://community.qlik.com/t5/QlikView/First-unique-value-from-different-Fields/m-p/504093#M1133806 2013-11-28T14:15:01Z