topic Re: Calculated Dimension in QlikView https://community.qlik.com/t5/QlikView/Calculated-Dimension/m-p/1248393#M395490 <HTML><HEAD></HEAD><BODY><P>May be like this</P><P></P><P><STRONG>If(not Match(capLEVEL, '<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">100 Preferred Rinkside', '</SPAN>100 Level II Rinkside', '100 Level III Rinkside', 'Hockey Suite.'), capLEVEL)</STRONG></P></BODY></HTML> Mon, 14 Nov 2016 19:06:42 GMT sunny_talwar 2016-11-14T19:06:42Z Calculated Dimension https://community.qlik.com/t5/QlikView/Calculated-Dimension/m-p/1248392#M395489 <HTML><HEAD></HEAD><BODY><P>I have a field called 'capLEVEL'</P><P></P><P>I want to use this in a chart as a dimension, however when I use this field, i want to exclude the following, which are records in this field:</P><P></P><P>100 Preferred Rinkside</P><P>100 Level II Rinkside</P><P>100 Level III Rinkside</P><P>Hockey Suite.</P><P></P><P>How would I structure the 'expression' for my dimension</P></BODY></HTML> Mon, 14 Nov 2016 18:57:09 GMT https://community.qlik.com/t5/QlikView/Calculated-Dimension/m-p/1248392#M395489 evansabres 2016-11-14T18:57:09Z Re: Calculated Dimension https://community.qlik.com/t5/QlikView/Calculated-Dimension/m-p/1248393#M395490 <HTML><HEAD></HEAD><BODY><P>May be like this</P><P></P><P><STRONG>If(not Match(capLEVEL, '<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">100 Preferred Rinkside', '</SPAN>100 Level II Rinkside', '100 Level III Rinkside', 'Hockey Suite.'), capLEVEL)</STRONG></P></BODY></HTML> Mon, 14 Nov 2016 19:06:42 GMT https://community.qlik.com/t5/QlikView/Calculated-Dimension/m-p/1248393#M395490 sunny_talwar 2016-11-14T19:06:42Z Re: Calculated Dimension https://community.qlik.com/t5/QlikView/Calculated-Dimension/m-p/1248394#M395491 <HTML><HEAD></HEAD><BODY><P>Helpful as always, thank you</P></BODY></HTML> Mon, 14 Nov 2016 19:10:12 GMT https://community.qlik.com/t5/QlikView/Calculated-Dimension/m-p/1248394#M395491 evansabres 2016-11-14T19:10:12Z