topic Re: Need an instr equivalent in QlikView https://community.qlik.com/t5/QlikView/Need-an-instr-equivalent/m-p/1102892#M365594 <HTML><HEAD></HEAD><BODY><P>Have a look at the Index() function e.g.</P><P></P><P>=if(Index('112&amp;113&amp;162&amp;183', 112)&gt;0,'Y','N')</P></BODY></HTML> Fri, 12 Aug 2016 15:09:57 GMT stigchel 2016-08-12T15:09:57Z Need an instr equivalent https://community.qlik.com/t5/QlikView/Need-an-instr-equivalent/m-p/1102889#M365591 <HTML><HEAD></HEAD><BODY><P>I am trying to see if a code is in a series of codes.</P><P></P><P>If 112 is in 112&amp;113&amp;162&amp;183 set Y else N.&nbsp; I need to display this in chart</P><P></P><P>thanks</P></BODY></HTML> Fri, 12 Aug 2016 15:05:57 GMT https://community.qlik.com/t5/QlikView/Need-an-instr-equivalent/m-p/1102889#M365591 fcecconi 2016-08-12T15:05:57Z Re: Need an instr equivalent https://community.qlik.com/t5/QlikView/Need-an-instr-equivalent/m-p/1102890#M365592 <HTML><HEAD></HEAD><BODY><P>If(SubstringCount( '<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">112&amp;113&amp;162&amp;18', '112'), 'Y', 'N')</SPAN></P></BODY></HTML> Fri, 12 Aug 2016 15:07:48 GMT https://community.qlik.com/t5/QlikView/Need-an-instr-equivalent/m-p/1102890#M365592 Gysbert_Wassenaar 2016-08-12T15:07:48Z Re: Need an instr equivalent https://community.qlik.com/t5/QlikView/Need-an-instr-equivalent/m-p/1102891#M365593 <HTML><HEAD></HEAD><BODY><P>For this you could use index() or wildmatch() or maybe a substringcount().</P><P></P><P>- Marcus</P></BODY></HTML> Fri, 12 Aug 2016 15:08:01 GMT https://community.qlik.com/t5/QlikView/Need-an-instr-equivalent/m-p/1102891#M365593 marcus_sommer 2016-08-12T15:08:01Z Re: Need an instr equivalent https://community.qlik.com/t5/QlikView/Need-an-instr-equivalent/m-p/1102892#M365594 <HTML><HEAD></HEAD><BODY><P>Have a look at the Index() function e.g.</P><P></P><P>=if(Index('112&amp;113&amp;162&amp;183', 112)&gt;0,'Y','N')</P></BODY></HTML> Fri, 12 Aug 2016 15:09:57 GMT https://community.qlik.com/t5/QlikView/Need-an-instr-equivalent/m-p/1102892#M365594 stigchel 2016-08-12T15:09:57Z Re: Need an instr equivalent https://community.qlik.com/t5/QlikView/Need-an-instr-equivalent/m-p/1102893#M365595 <HTML><HEAD></HEAD><BODY><P>thanks.&nbsp; this worked as I needed</P></BODY></HTML> Fri, 12 Aug 2016 15:23:48 GMT https://community.qlik.com/t5/QlikView/Need-an-instr-equivalent/m-p/1102893#M365595 fcecconi 2016-08-12T15:23:48Z