topic Re: How to convert Excel Search logic into QlikView logic in QlikView https://community.qlik.com/t5/QlikView/How-to-convert-Excel-Search-logic-into-QlikView-logic/m-p/1330432#M833454 <HTML><HEAD></HEAD><BODY><P>Or This?</P><P><STRONG>If(SubStringCount(Input, 'OUTSIDE'),'Outside','Inside') as Output</STRONG></P></BODY></HTML> Wed, 07 Jun 2017 17:44:23 GMT Anil_Babu_Samineni 2017-06-07T17:44:23Z How to convert Excel Search logic into QlikView logic https://community.qlik.com/t5/QlikView/How-to-convert-Excel-Search-logic-into-QlikView-logic/m-p/1330430#M833452 <HTML><HEAD></HEAD><BODY><P>Hi All </P><P></P><P>in excel i have use this formula, how to convert into qlikview logic </P><P></P><P><STRONG>=IF(ISNUMBER(SEARCH("outside",A2)),"Outside","Inside")</STRONG></P><P></P><P>PFA </P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/How-to-convert-Excel-Search-logic-into-QlikView-logic/m-p/1330430#M833452 vengadeshpalani 2020-11-25T16:16:04Z Re: How to convert Excel Search logic into QlikView logic https://community.qlik.com/t5/QlikView/How-to-convert-Excel-Search-logic-into-QlikView-logic/m-p/1330431#M833453 <HTML><HEAD></HEAD><BODY><P>May be this</P><P></P><P><STRONG>If(WildMatch(Input, '*Outside*'), 'Outside', 'Inside') as Output</STRONG></P></BODY></HTML> Wed, 07 Jun 2017 17:39:11 GMT https://community.qlik.com/t5/QlikView/How-to-convert-Excel-Search-logic-into-QlikView-logic/m-p/1330431#M833453 sunny_talwar 2017-06-07T17:39:11Z Re: How to convert Excel Search logic into QlikView logic https://community.qlik.com/t5/QlikView/How-to-convert-Excel-Search-logic-into-QlikView-logic/m-p/1330432#M833454 <HTML><HEAD></HEAD><BODY><P>Or This?</P><P><STRONG>If(SubStringCount(Input, 'OUTSIDE'),'Outside','Inside') as Output</STRONG></P></BODY></HTML> Wed, 07 Jun 2017 17:44:23 GMT https://community.qlik.com/t5/QlikView/How-to-convert-Excel-Search-logic-into-QlikView-logic/m-p/1330432#M833454 Anil_Babu_Samineni 2017-06-07T17:44:23Z