topic Re: How to Ignore some data in a chart in QlikView https://community.qlik.com/t5/QlikView/How-to-Ignore-some-data-in-a-chart/m-p/428287#M564485 <HTML><HEAD></HEAD><BODY><P>yes, this is what I want..</P></BODY></HTML> Tue, 12 Feb 2013 14:41:59 GMT 2013-02-12T14:41:59Z How to Ignore some data in a chart https://community.qlik.com/t5/QlikView/How-to-Ignore-some-data-in-a-chart/m-p/428284#M564482 <HTML><HEAD></HEAD><BODY><P>Hi to everyone.</P><P></P><P>I need your help to know how to ignore some value in a calculated dimension in a linear chart.</P><P></P><P>example:</P><P></P><P>my calculated field in the expressions have value like</P><P></P><P>A</P><P></P><P>95%</P><P>85%</P><P>55%</P><P>130%</P><P>75%</P><P>120%</P><P></P><P>I want to ignore all the value more than 100% in my linear chart.</P><P>how can I do that?</P><P></P><P>thank a lot</P></BODY></HTML> Tue, 12 Feb 2013 14:04:25 GMT https://community.qlik.com/t5/QlikView/How-to-Ignore-some-data-in-a-chart/m-p/428284#M564482 2013-02-12T14:04:25Z Re: How to Ignore some data in a chart https://community.qlik.com/t5/QlikView/How-to-Ignore-some-data-in-a-chart/m-p/428285#M564483 <HTML><HEAD></HEAD><BODY><P><STRONG>If(Expression &lt;=<SPAN style="color: #ff0000;"> 1</SPAN></STRONG></P><P><STRONG>&nbsp;&nbsp;&nbsp;&nbsp; , Expression</STRONG></P><P><STRONG>)</STRONG></P></BODY></HTML> Tue, 12 Feb 2013 14:08:13 GMT https://community.qlik.com/t5/QlikView/How-to-Ignore-some-data-in-a-chart/m-p/428285#M564483 vivientexier 2013-02-12T14:08:13Z Re: How to Ignore some data in a chart https://community.qlik.com/t5/QlikView/How-to-Ignore-some-data-in-a-chart/m-p/428286#M564484 <HTML><HEAD></HEAD><BODY><P>"ignore" - You mean, You don't want them to appear in chart?</P></BODY></HTML> Tue, 12 Feb 2013 14:09:21 GMT https://community.qlik.com/t5/QlikView/How-to-Ignore-some-data-in-a-chart/m-p/428286#M564484 2013-02-12T14:09:21Z Re: How to Ignore some data in a chart https://community.qlik.com/t5/QlikView/How-to-Ignore-some-data-in-a-chart/m-p/428287#M564485 <HTML><HEAD></HEAD><BODY><P>yes, this is what I want..</P></BODY></HTML> Tue, 12 Feb 2013 14:41:59 GMT https://community.qlik.com/t5/QlikView/How-to-Ignore-some-data-in-a-chart/m-p/428287#M564485 2013-02-12T14:41:59Z Re: How to Ignore some data in a chart https://community.qlik.com/t5/QlikView/How-to-Ignore-some-data-in-a-chart/m-p/428288#M564486 <HTML><HEAD></HEAD><BODY><P>if I write on the condition this if, seems there are no effect in the chart, I still see the same data as before</P></BODY></HTML> Tue, 12 Feb 2013 15:34:08 GMT https://community.qlik.com/t5/QlikView/How-to-Ignore-some-data-in-a-chart/m-p/428288#M564486 2013-02-12T15:34:08Z Re: How to Ignore some data in a chart https://community.qlik.com/t5/QlikView/How-to-Ignore-some-data-in-a-chart/m-p/428289#M564487 <HTML><HEAD></HEAD><BODY><P>see the sample attached file</P><P></P><P></P><P>hope this helps</P></BODY></HTML> Tue, 12 Feb 2013 16:36:36 GMT https://community.qlik.com/t5/QlikView/How-to-Ignore-some-data-in-a-chart/m-p/428289#M564487 SunilChauhan 2013-02-12T16:36:36Z