topic How to select from data in a field in QlikView https://community.qlik.com/t5/QlikView/How-to-select-from-data-in-a-field/m-p/144224#M23226 <HTML><HEAD></HEAD><BODY><P>Hello Fellow QV users,</P><P>How cann I select ,as shown below, in a field with a lot of data the product MFE2.</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 128pt; border-collapse: collapse;" width="171"><COLGROUP><COL style="width: 80pt; mso-width-source: userset; mso-width-alt: 3913;" width="107" /><COL style="width: 48pt;" width="64" /></COLGROUP><TBODY><TR height="17" style="height: 12.75pt;"><TD class="xl25" height="17" style="width: 80pt; height: 12.75pt; background-color: transparent; border: windowtext 0.5pt solid;" width="107"><STRONG>Product</STRONG></TD><TD class="xl25" style="border-right: windowtext 0.5pt solid; border-top: windowtext 0.5pt solid; border-left: windowtext; width: 48pt; border-bottom: windowtext 0.5pt solid; background-color: transparent;" width="64"><STRONG>Result</STRONG></TD></TR><TR height="17" style="height: 12.75pt;"><TD class="xl24" height="17" style="border-right: windowtext 0.5pt solid; border-top: windowtext; border-left: windowtext 0.5pt solid; border-bottom: windowtext 0.5pt solid; height: 12.75pt; background-color: transparent;" str="08d3630 MFE2 ">08d3630 MFE2</TD><TD class="xl24" style="border-right: windowtext 0.5pt solid; border-top: windowtext; border-left: windowtext; border-bottom: windowtext 0.5pt solid; background-color: transparent;">MFE2</TD></TR><TR height="17" style="height: 12.75pt;"><TD class="xl24" height="17" style="border-right: windowtext 0.5pt solid; border-top: windowtext; border-left: windowtext 0.5pt solid; border-bottom: windowtext 0.5pt solid; height: 12.75pt; background-color: transparent;">9999 DKKDP:F</TD><TD class="xl24" style="border-right: windowtext 0.5pt solid; border-top: windowtext; border-left: windowtext; border-bottom: windowtext 0.5pt solid; background-color: transparent;">Other</TD></TR><TR height="17" style="height: 12.75pt;"><TD class="xl24" height="17" style="border-right: windowtext 0.5pt solid; border-top: windowtext; border-left: windowtext 0.5pt solid; border-bottom: windowtext 0.5pt solid; height: 12.75pt; background-color: transparent;">09d dddef MFE2</TD><TD class="xl24" style="border-right: windowtext 0.5pt solid; border-top: windowtext; border-left: windowtext; border-bottom: windowtext 0.5pt solid; background-color: transparent;">MFE2</TD></TR></TBODY></TABLE><BR /><BR /> <P>I would like to create an IF-function. When in the field Product the data MFE2 appears, then I would like to see in the field Result, the value MFE2 and if not the value Other.</P><P></P><P>Regards,</P><P></P><P>Aissam</P></BODY></HTML> Fri, 15 May 2009 18:30:12 GMT 2009-05-15T18:30:12Z How to select from data in a field https://community.qlik.com/t5/QlikView/How-to-select-from-data-in-a-field/m-p/144224#M23226 <HTML><HEAD></HEAD><BODY><P>Hello Fellow QV users,</P><P>How cann I select ,as shown below, in a field with a lot of data the product MFE2.</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 128pt; border-collapse: collapse;" width="171"><COLGROUP><COL style="width: 80pt; mso-width-source: userset; mso-width-alt: 3913;" width="107" /><COL style="width: 48pt;" width="64" /></COLGROUP><TBODY><TR height="17" style="height: 12.75pt;"><TD class="xl25" height="17" style="width: 80pt; height: 12.75pt; background-color: transparent; border: windowtext 0.5pt solid;" width="107"><STRONG>Product</STRONG></TD><TD class="xl25" style="border-right: windowtext 0.5pt solid; border-top: windowtext 0.5pt solid; border-left: windowtext; width: 48pt; border-bottom: windowtext 0.5pt solid; background-color: transparent;" width="64"><STRONG>Result</STRONG></TD></TR><TR height="17" style="height: 12.75pt;"><TD class="xl24" height="17" style="border-right: windowtext 0.5pt solid; border-top: windowtext; border-left: windowtext 0.5pt solid; border-bottom: windowtext 0.5pt solid; height: 12.75pt; background-color: transparent;" str="08d3630 MFE2 ">08d3630 MFE2</TD><TD class="xl24" style="border-right: windowtext 0.5pt solid; border-top: windowtext; border-left: windowtext; border-bottom: windowtext 0.5pt solid; background-color: transparent;">MFE2</TD></TR><TR height="17" style="height: 12.75pt;"><TD class="xl24" height="17" style="border-right: windowtext 0.5pt solid; border-top: windowtext; border-left: windowtext 0.5pt solid; border-bottom: windowtext 0.5pt solid; height: 12.75pt; background-color: transparent;">9999 DKKDP:F</TD><TD class="xl24" style="border-right: windowtext 0.5pt solid; border-top: windowtext; border-left: windowtext; border-bottom: windowtext 0.5pt solid; background-color: transparent;">Other</TD></TR><TR height="17" style="height: 12.75pt;"><TD class="xl24" height="17" style="border-right: windowtext 0.5pt solid; border-top: windowtext; border-left: windowtext 0.5pt solid; border-bottom: windowtext 0.5pt solid; height: 12.75pt; background-color: transparent;">09d dddef MFE2</TD><TD class="xl24" style="border-right: windowtext 0.5pt solid; border-top: windowtext; border-left: windowtext; border-bottom: windowtext 0.5pt solid; background-color: transparent;">MFE2</TD></TR></TBODY></TABLE><BR /><BR /> <P>I would like to create an IF-function. When in the field Product the data MFE2 appears, then I would like to see in the field Result, the value MFE2 and if not the value Other.</P><P></P><P>Regards,</P><P></P><P>Aissam</P></BODY></HTML> Fri, 15 May 2009 18:30:12 GMT https://community.qlik.com/t5/QlikView/How-to-select-from-data-in-a-field/m-p/144224#M23226 2009-05-15T18:30:12Z How to select from data in a field https://community.qlik.com/t5/QlikView/How-to-select-from-data-in-a-field/m-p/144225#M23227 <HTML><HEAD></HEAD><BODY><P>=If(Index(Product,'MFE2')&gt;0,'MFE2','Other')</P></BODY></HTML> Fri, 15 May 2009 18:49:31 GMT https://community.qlik.com/t5/QlikView/How-to-select-from-data-in-a-field/m-p/144225#M23227 2009-05-15T18:49:31Z