topic calculated dimension help in QlikView https://community.qlik.com/t5/QlikView/calculated-dimension-help/m-p/1152457#M376412 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-size: 14pt;">Hello ,</SPAN></P><P></P><P><SPAN style="font-size: 14pt;">trying to remove Data in Dimension that starts with "New".</SPAN></P><P></P><P><SPAN style="font-size: 14pt;">if( not match(County,'New*'),county) </SPAN></P><P></P><P></P><P><SPAN style="font-size: 14pt;">if(county='New*','NULL',county)</SPAN></P><P></P><P><SPAN style="font-size: 14pt;">tried above expressions but not working , pls help</SPAN></P></BODY></HTML> Mon, 22 Aug 2016 23:05:11 GMT arusanah 2016-08-22T23:05:11Z calculated dimension help https://community.qlik.com/t5/QlikView/calculated-dimension-help/m-p/1152457#M376412 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-size: 14pt;">Hello ,</SPAN></P><P></P><P><SPAN style="font-size: 14pt;">trying to remove Data in Dimension that starts with "New".</SPAN></P><P></P><P><SPAN style="font-size: 14pt;">if( not match(County,'New*'),county) </SPAN></P><P></P><P></P><P><SPAN style="font-size: 14pt;">if(county='New*','NULL',county)</SPAN></P><P></P><P><SPAN style="font-size: 14pt;">tried above expressions but not working , pls help</SPAN></P></BODY></HTML> Mon, 22 Aug 2016 23:05:11 GMT https://community.qlik.com/t5/QlikView/calculated-dimension-help/m-p/1152457#M376412 arusanah 2016-08-22T23:05:11Z Re: calculated dimension help https://community.qlik.com/t5/QlikView/calculated-dimension-help/m-p/1152458#M376413 <HTML><HEAD></HEAD><BODY><P>Try this with WildMatch instead of Match</P><P></P><P><STRONG>If(Not WildMatch(County, 'New*'), County)</STRONG></P></BODY></HTML> Mon, 22 Aug 2016 23:11:00 GMT https://community.qlik.com/t5/QlikView/calculated-dimension-help/m-p/1152458#M376413 sunny_talwar 2016-08-22T23:11:00Z Re: calculated dimension help https://community.qlik.com/t5/QlikView/calculated-dimension-help/m-p/1152459#M376414 <HTML><HEAD></HEAD><BODY><P>or</P><P></P><P><STRONG>If(County NOT LIKE 'New*', County)</STRONG></P></BODY></HTML> Mon, 22 Aug 2016 23:13:45 GMT https://community.qlik.com/t5/QlikView/calculated-dimension-help/m-p/1152459#M376414 sunny_talwar 2016-08-22T23:13:45Z