topic WildMatch and If statement in App Development https://community.qlik.com/t5/App-Development/WildMatch-and-If-statement/m-p/1224705#M23824 <HTML><HEAD></HEAD><BODY><P>I'm having a mental block today on WildMatch parameter.&nbsp; Any suggestions on how to write an expression to EXCLUDE a userID prefix from a data set.&nbsp; I assume I could use a &lt;&gt; parameter, but can't figure it out.&nbsp; </P><P></P><P>Example to include anything 'Test*' but would like to exclude test from the data set.&nbsp; </P><P>if(WildMatch([UserId],'Test*'), [UserId])&nbsp; </P></BODY></HTML> Tue, 10 Jan 2017 15:47:24 GMT joshakehurst 2017-01-10T15:47:24Z WildMatch and If statement https://community.qlik.com/t5/App-Development/WildMatch-and-If-statement/m-p/1224705#M23824 <HTML><HEAD></HEAD><BODY><P>I'm having a mental block today on WildMatch parameter.&nbsp; Any suggestions on how to write an expression to EXCLUDE a userID prefix from a data set.&nbsp; I assume I could use a &lt;&gt; parameter, but can't figure it out.&nbsp; </P><P></P><P>Example to include anything 'Test*' but would like to exclude test from the data set.&nbsp; </P><P>if(WildMatch([UserId],'Test*'), [UserId])&nbsp; </P></BODY></HTML> Tue, 10 Jan 2017 15:47:24 GMT https://community.qlik.com/t5/App-Development/WildMatch-and-If-statement/m-p/1224705#M23824 joshakehurst 2017-01-10T15:47:24Z Re: WildMatch and If statement https://community.qlik.com/t5/App-Development/WildMatch-and-If-statement/m-p/1224706#M23825 <HTML><HEAD></HEAD><BODY><P>It's not quite clear for me what do you are meaning with "exclude test from the data set"? Here a variance to your expression which might be more suitable:</P><P></P><P>if(<STRONG>not</STRONG> WildMatch([UserId],'Test*'), [UserId], null()) </P><P></P><P>- Marcus</P></BODY></HTML> Tue, 10 Jan 2017 16:41:31 GMT https://community.qlik.com/t5/App-Development/WildMatch-and-If-statement/m-p/1224706#M23825 marcus_sommer 2017-01-10T16:41:31Z