topic Wildcard question in QlikView https://community.qlik.com/t5/QlikView/Wildcard-question/m-p/355066#M495117 <HTML><HEAD></HEAD><BODY><P>I have a straight table chart where I am trying to filter out a value using a wildcard.&nbsp; What I am trying to do is exclude any instances of where the field value has TEMPLATE somewhere within in it.</P><P></P><P>Here is an example of a field value that I am trying to exclude:</P><P></P><P>PRJ-10014 - TEMPLATE - Management Activities</P><P></P><P>I attempted to created a calculated dimension</P><P></P><P><SPAN style="font-family: 'Courier New'; color: black; font-size: 9pt;">=</SPAN><SPAN style="font-family: 'Courier New'; color: blue; font-size: 9pt;">If</SPAN><SPAN style="font-family: 'Courier New'; color: black; font-size: 9pt;"> (</SPAN><SPAN style="font-family: 'Courier New'; color: maroon; font-size: 9pt;">[Proj Number &amp; Name]</SPAN><SPAN style="font-family: 'Courier New'; color: black; font-size: 9pt;"> &lt;&gt;'*TEMPLATE*', </SPAN><SPAN style="font-family: 'Courier New'; color: maroon; font-size: 9pt;">[Proj Number &amp; Name]</SPAN><SPAN style="font-family: 'Courier New'; color: black; font-size: 9pt;">) </SPAN></P><P></P><P>but it is ignoring the wildcard.</P><P></P><P>Any help would be greatly appreciated.</P></BODY></HTML> Thu, 15 Mar 2012 16:59:49 GMT 2012-03-15T16:59:49Z Wildcard question https://community.qlik.com/t5/QlikView/Wildcard-question/m-p/355066#M495117 <HTML><HEAD></HEAD><BODY><P>I have a straight table chart where I am trying to filter out a value using a wildcard.&nbsp; What I am trying to do is exclude any instances of where the field value has TEMPLATE somewhere within in it.</P><P></P><P>Here is an example of a field value that I am trying to exclude:</P><P></P><P>PRJ-10014 - TEMPLATE - Management Activities</P><P></P><P>I attempted to created a calculated dimension</P><P></P><P><SPAN style="font-family: 'Courier New'; color: black; font-size: 9pt;">=</SPAN><SPAN style="font-family: 'Courier New'; color: blue; font-size: 9pt;">If</SPAN><SPAN style="font-family: 'Courier New'; color: black; font-size: 9pt;"> (</SPAN><SPAN style="font-family: 'Courier New'; color: maroon; font-size: 9pt;">[Proj Number &amp; Name]</SPAN><SPAN style="font-family: 'Courier New'; color: black; font-size: 9pt;"> &lt;&gt;'*TEMPLATE*', </SPAN><SPAN style="font-family: 'Courier New'; color: maroon; font-size: 9pt;">[Proj Number &amp; Name]</SPAN><SPAN style="font-family: 'Courier New'; color: black; font-size: 9pt;">) </SPAN></P><P></P><P>but it is ignoring the wildcard.</P><P></P><P>Any help would be greatly appreciated.</P></BODY></HTML> Thu, 15 Mar 2012 16:59:49 GMT https://community.qlik.com/t5/QlikView/Wildcard-question/m-p/355066#M495117 2012-03-15T16:59:49Z Wildcard question https://community.qlik.com/t5/QlikView/Wildcard-question/m-p/355067#M495118 <HTML><HEAD></HEAD><BODY><P> <SPAN style="font-family: 'Courier New'; color: black; font-size: 9pt;">=</SPAN><SPAN style="font-family: 'Courier New'; color: blue; font-size: 9pt;">If</SPAN><SPAN style="font-family: 'Courier New'; color: black; font-size: 9pt;"> (substringcount(</SPAN><SPAN style="font-family: 'Courier New'; color: maroon; font-size: 9pt;">[Proj Number &amp; Name],</SPAN><SPAN style="font-family: 'Courier New'; color: black; font-size: 9pt;">'TEMPLATE')=0, </SPAN><SPAN style="font-family: 'Courier New'; color: maroon; font-size: 9pt;">[Proj Number &amp; Name]</SPAN><SPAN style="font-family: 'Courier New'; color: black; font-size: 9pt;">) </SPAN></P></BODY></HTML> Thu, 15 Mar 2012 17:10:49 GMT https://community.qlik.com/t5/QlikView/Wildcard-question/m-p/355067#M495118 2012-03-15T17:10:49Z Wildcard question https://community.qlik.com/t5/QlikView/Wildcard-question/m-p/355068#M495119 <HTML><HEAD></HEAD><BODY><P> Perfect - thanks!</P></BODY></HTML> Thu, 15 Mar 2012 17:22:30 GMT https://community.qlik.com/t5/QlikView/Wildcard-question/m-p/355068#M495119 2012-03-15T17:22:30Z