topic exclude some value from dimension in QlikView https://community.qlik.com/t5/QlikView/exclude-some-value-from-dimension/m-p/1239625#M393843 <HTML><HEAD></HEAD><BODY><P>HI i have a chart with QVW name as a dimension,&nbsp; which shows how manny user and session each QVW has,, but i want to exclude some QVW name from that chart,</P><P></P><P></P><P>like </P><P>i dont want Finance.qvw&nbsp;&nbsp; and Home graph.qvw&nbsp; in the chart </P></BODY></HTML> Wed, 08 Feb 2017 20:37:03 GMT everest226 2017-02-08T20:37:03Z exclude some value from dimension https://community.qlik.com/t5/QlikView/exclude-some-value-from-dimension/m-p/1239625#M393843 <HTML><HEAD></HEAD><BODY><P>HI i have a chart with QVW name as a dimension,&nbsp; which shows how manny user and session each QVW has,, but i want to exclude some QVW name from that chart,</P><P></P><P></P><P>like </P><P>i dont want Finance.qvw&nbsp;&nbsp; and Home graph.qvw&nbsp; in the chart </P></BODY></HTML> Wed, 08 Feb 2017 20:37:03 GMT https://community.qlik.com/t5/QlikView/exclude-some-value-from-dimension/m-p/1239625#M393843 everest226 2017-02-08T20:37:03Z Re: exclude some value from dimension https://community.qlik.com/t5/QlikView/exclude-some-value-from-dimension/m-p/1239626#M393844 <HTML><HEAD></HEAD><BODY><P>May be this:</P><P></P><P><STRONG>Replace(FieldName, '.qvw', '')</STRONG></P></BODY></HTML> Wed, 08 Feb 2017 20:38:53 GMT https://community.qlik.com/t5/QlikView/exclude-some-value-from-dimension/m-p/1239626#M393844 sunny_talwar 2017-02-08T20:38:53Z Re: exclude some value from dimension https://community.qlik.com/t5/QlikView/exclude-some-value-from-dimension/m-p/1239627#M393845 <HTML><HEAD></HEAD><BODY><P>hi sunny i am not trying to replace the field , i was trying not to include <SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 12px;">Finance.qvw&nbsp;&nbsp; and Home graph.qvw&nbsp; in the chart</SPAN></P></BODY></HTML> Wed, 08 Feb 2017 21:09:38 GMT https://community.qlik.com/t5/QlikView/exclude-some-value-from-dimension/m-p/1239627#M393845 everest226 2017-02-08T21:09:38Z Re: exclude some value from dimension https://community.qlik.com/t5/QlikView/exclude-some-value-from-dimension/m-p/1239628#M393846 <HTML><HEAD></HEAD><BODY><P>May be this:</P><P></P><P>= IF(Not Match(FieldName, 'Finance.qvw', 'Home Graph.qvw') , FieldName)</P></BODY></HTML> Wed, 08 Feb 2017 21:53:09 GMT https://community.qlik.com/t5/QlikView/exclude-some-value-from-dimension/m-p/1239628#M393846 vishsaggi 2017-02-08T21:53:09Z Re: exclude some value from dimension https://community.qlik.com/t5/QlikView/exclude-some-value-from-dimension/m-p/1239629#M393847 <HTML><HEAD></HEAD><BODY><P>Misunderstood the requirement, but <A href="https://community.qlik.com/people/vishsaggi">vishsaggi</A>‌'s response should work for you <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Wed, 08 Feb 2017 22:36:07 GMT https://community.qlik.com/t5/QlikView/exclude-some-value-from-dimension/m-p/1239629#M393847 sunny_talwar 2017-02-08T22:36:07Z Re: exclude some value from dimension https://community.qlik.com/t5/QlikView/exclude-some-value-from-dimension/m-p/1239630#M393848 <HTML><HEAD></HEAD><BODY><P>Thanks <A href="https://community.qlik.com/qlik-users/171708">stalwar1</A>‌ you always been helpful</P></BODY></HTML> Thu, 09 Feb 2017 18:46:07 GMT https://community.qlik.com/t5/QlikView/exclude-some-value-from-dimension/m-p/1239630#M393848 everest226 2017-02-09T18:46:07Z