topic Re: Help creating a new field using existing fields in QlikView https://community.qlik.com/t5/QlikView/Help-creating-a-new-field-using-existing-fields/m-p/694555#M251145 <HTML><HEAD></HEAD><BODY><P>Try something like:</P><P></P><P>if(left([Read Product],5) = left(Project,5), 'Y','N')</P></BODY></HTML> Thu, 31 Jul 2014 19:48:56 GMT joshabbott 2014-07-31T19:48:56Z Help creating a new field using existing fields https://community.qlik.com/t5/QlikView/Help-creating-a-new-field-using-existing-fields/m-p/694554#M251144 <HTML><HEAD></HEAD><BODY><P>I have two fields:&nbsp; Product and Real Product</P><P></P><TABLE border="1" class="jiveBorder" height="109" jive-data-cell="{&quot;color&quot;:&quot;#000000&quot;,&quot;textAlign&quot;:&quot;left&quot;,&quot;padding&quot;:&quot;2&quot;}" jive-data-header="{&quot;color&quot;:&quot;#FFFFFF&quot;,&quot;backgroundColor&quot;:&quot;#6690BC&quot;,&quot;textAlign&quot;:&quot;center&quot;,&quot;padding&quot;:&quot;2&quot;,&quot;fontFamily&quot;:&quot;arial,helvetica,sans-serif&quot;,&quot;verticalAlign&quot;:&quot;baseline&quot;}" style="border: 1px solid rgb(0, 0, 0); width: 190px; height: 111px;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><SPAN style="font-size: 8pt;">Product</SPAN></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><SPAN style="font-size: 8pt;"><STRONG>Real Product</STRONG></SPAN></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><SPAN style="font-size: 8pt;">Match</SPAN></TH></TR><TR><TD style="padding: 2px;"><SPAN style="font-size: 8pt;">AL-111</SPAN></TD><TD style="padding: 2px;"><SPAN style="font-size: 8pt;">AL-111MO</SPAN></TD><TD style="padding: 2px;"><SPAN style="font-size: 8pt;">Y</SPAN></TD></TR><TR><TD style="padding: 2px;"><SPAN style="font-size: 8pt;">CA-172</SPAN></TD><TD style="padding: 2px;"><SPAN style="font-size: 8pt;">CA-183LA</SPAN></TD><TD style="padding: 2px;"><SPAN style="font-size: 8pt;">N</SPAN></TD></TR><TR><TD style="padding: 2px;"><SPAN style="font-size: 8pt;">MA-912</SPAN></TD><TD style="padding: 2px;"><SPAN style="font-size: 8pt;">MA-912MO</SPAN></TD><TD style="padding: 2px;"><SPAN style="font-size: 8pt;">Y</SPAN></TD></TR><TR><TD><SPAN style="font-size: 8pt;">MA-912</SPAN></TD><TD><SPAN style="font-size: 8pt;">MA-819MO</SPAN></TD><TD><SPAN style="font-size: 8pt;">N</SPAN></TD></TR></TBODY></TABLE><P></P><P>I want a new field, 'Match' that uses these two fields. If they first 5 characters are identical, I want the 'Match' field to say 'Y'. If not, 'N'</P></BODY></HTML> Thu, 31 Jul 2014 19:41:07 GMT https://community.qlik.com/t5/QlikView/Help-creating-a-new-field-using-existing-fields/m-p/694554#M251144 2014-07-31T19:41:07Z Re: Help creating a new field using existing fields https://community.qlik.com/t5/QlikView/Help-creating-a-new-field-using-existing-fields/m-p/694555#M251145 <HTML><HEAD></HEAD><BODY><P>Try something like:</P><P></P><P>if(left([Read Product],5) = left(Project,5), 'Y','N')</P></BODY></HTML> Thu, 31 Jul 2014 19:48:56 GMT https://community.qlik.com/t5/QlikView/Help-creating-a-new-field-using-existing-fields/m-p/694555#M251145 joshabbott 2014-07-31T19:48:56Z