Solved: How to convert Excel Search logic into QlikView lo... - Qlik Community

vengadeshpalani · ‎2017-06-07

Hi All

in excel i have use this formula, how to convert into qlikview logic

=IF(ISNUMBER(SEARCH("outside",A2)),"Outside","Inside")

PFA

sunny_talwar · ‎2017-06-07

May be this

If(WildMatch(Input, '*Outside*'), 'Outside', 'Inside') as Output

View solution in original post

sunny_talwar · ‎2017-06-07

May be this

If(WildMatch(Input, '*Outside*'), 'Outside', 'Inside') as Output

Anil_Babu_Samineni · ‎2017-06-07

Or This?

If(SubStringCount(Input, 'OUTSIDE'),'Outside','Inside') as Output

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful

How to convert Excel Search logic into QlikView logic