topic Find the value by using wild match in QlikView https://community.qlik.com/t5/QlikView/Find-the-value-by-using-wild-match/m-p/1331139#M831860 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P></P><P>Guys i want to show the value by using wild match,</P><P>The data is :</P><P>Table </P><P>A B C *</P><P>C D E *</P><P>G H I *</P><P>A N D D</P><P>D F R R</P><P>Value must be shoe where star value is not present by using wild match.</P><P></P><P></P><P>o/p</P><P>ANDD</P><P>DFRR</P><P></P><P>Thanks</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT Anonymous 2020-11-25T16:16:04Z Find the value by using wild match https://community.qlik.com/t5/QlikView/Find-the-value-by-using-wild-match/m-p/1331139#M831860 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P></P><P>Guys i want to show the value by using wild match,</P><P>The data is :</P><P>Table </P><P>A B C *</P><P>C D E *</P><P>G H I *</P><P>A N D D</P><P>D F R R</P><P>Value must be shoe where star value is not present by using wild match.</P><P></P><P></P><P>o/p</P><P>ANDD</P><P>DFRR</P><P></P><P>Thanks</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Find-the-value-by-using-wild-match/m-p/1331139#M831860 Anonymous 2020-11-25T16:16:04Z Re: Find the value by using wild match https://community.qlik.com/t5/QlikView/Find-the-value-by-using-wild-match/m-p/1331140#M831861 <HTML><HEAD></HEAD><BODY><P>May be this?</P><P><STRONG>If(Not SubStringCount(Table,'*'), Table) as Table</STRONG></P></BODY></HTML> Wed, 21 Jun 2017 11:46:09 GMT https://community.qlik.com/t5/QlikView/Find-the-value-by-using-wild-match/m-p/1331140#M831861 Anil_Babu_Samineni 2017-06-21T11:46:09Z Re: Find the value by using wild match https://community.qlik.com/t5/QlikView/Find-the-value-by-using-wild-match/m-p/1331141#M831862 <HTML><HEAD></HEAD><BODY><P>Looking to do something in the script?</P></BODY></HTML> Wed, 21 Jun 2017 11:46:58 GMT https://community.qlik.com/t5/QlikView/Find-the-value-by-using-wild-match/m-p/1331141#M831862 sunny_talwar 2017-06-21T11:46:58Z Re: Find the value by using wild match https://community.qlik.com/t5/QlikView/Find-the-value-by-using-wild-match/m-p/1331142#M831866 <HTML><HEAD></HEAD><BODY><P>Using wild match .</P></BODY></HTML> Wed, 21 Jun 2017 11:52:44 GMT https://community.qlik.com/t5/QlikView/Find-the-value-by-using-wild-match/m-p/1331142#M831866 Anonymous 2017-06-21T11:52:44Z Re: Find the value by using wild match https://community.qlik.com/t5/QlikView/Find-the-value-by-using-wild-match/m-p/1331143#M831867 <HTML><HEAD></HEAD><BODY><P>Have you tried <A href="https://community.qlik.com/people/loveisfail">loveisfail</A>‌'s approach?</P></BODY></HTML> Wed, 21 Jun 2017 11:54:37 GMT https://community.qlik.com/t5/QlikView/Find-the-value-by-using-wild-match/m-p/1331143#M831867 sunny_talwar 2017-06-21T11:54:37Z Re: Find the value by using wild match https://community.qlik.com/t5/QlikView/Find-the-value-by-using-wild-match/m-p/1331144#M831868 <HTML><HEAD></HEAD><BODY><P>Yes, I got the answer it but condition is using wildmatch.</P></BODY></HTML> Wed, 21 Jun 2017 11:57:45 GMT https://community.qlik.com/t5/QlikView/Find-the-value-by-using-wild-match/m-p/1331144#M831868 Anonymous 2017-06-21T11:57:45Z Re: Find the value by using wild match https://community.qlik.com/t5/QlikView/Find-the-value-by-using-wild-match/m-p/1331145#M831869 <HTML><HEAD></HEAD><BODY><P>May be this</P><P><STRONG>If(Not WildMatch(Replace(Table, '*', '@'), '*@*'), Table) as Table</STRONG></P></BODY></HTML> Wed, 21 Jun 2017 12:03:34 GMT https://community.qlik.com/t5/QlikView/Find-the-value-by-using-wild-match/m-p/1331145#M831869 sunny_talwar 2017-06-21T12:03:34Z Re: Find the value by using wild match https://community.qlik.com/t5/QlikView/Find-the-value-by-using-wild-match/m-p/1331146#M831870 <HTML><HEAD></HEAD><BODY><P>haha, Sunny Can we use combination of FindOneOf() with WildMatch(). I know your intention but this is awesome !!</P></BODY></HTML> Wed, 21 Jun 2017 12:08:50 GMT https://community.qlik.com/t5/QlikView/Find-the-value-by-using-wild-match/m-p/1331146#M831870 Anil_Babu_Samineni 2017-06-21T12:08:50Z Re: Find the value by using wild match https://community.qlik.com/t5/QlikView/Find-the-value-by-using-wild-match/m-p/1331147#M831871 <HTML><HEAD></HEAD><BODY><P>But why you only need wildmatch?</P></BODY></HTML> Wed, 21 Jun 2017 12:11:08 GMT https://community.qlik.com/t5/QlikView/Find-the-value-by-using-wild-match/m-p/1331147#M831871 Kushal_Chawda 2017-06-21T12:11:08Z Re: Find the value by using wild match https://community.qlik.com/t5/QlikView/Find-the-value-by-using-wild-match/m-p/1331148#M831872 <HTML><HEAD></HEAD><BODY><P><A href="https://community.qlik.com/thread/264879">Wild Match ()</A></P></BODY></HTML> Wed, 21 Jun 2017 16:53:27 GMT https://community.qlik.com/t5/QlikView/Find-the-value-by-using-wild-match/m-p/1331148#M831872 Anonymous 2017-06-21T16:53:27Z