topic Display only above 0 values in bar chart. in App Development https://community.qlik.com/t5/App-Development/Display-only-above-0-values-in-bar-chart/m-p/1034262#M15970 <HTML><HEAD></HEAD><BODY><P>I have a requirement where I need to display bottom 10 suppliers by the certain calculated measure. Added condition is that, those bottom 10 values should be above 0 values. </P><P></P><P>I have tried putting an IF condition in the measure, and dimension is bottom ordered and a limitation of 10. However this is not working.</P></BODY></HTML> Mon, 15 Feb 2016 11:10:38 GMT 2016-02-15T11:10:38Z Display only above 0 values in bar chart. https://community.qlik.com/t5/App-Development/Display-only-above-0-values-in-bar-chart/m-p/1034262#M15970 <HTML><HEAD></HEAD><BODY><P>I have a requirement where I need to display bottom 10 suppliers by the certain calculated measure. Added condition is that, those bottom 10 values should be above 0 values. </P><P></P><P>I have tried putting an IF condition in the measure, and dimension is bottom ordered and a limitation of 10. However this is not working.</P></BODY></HTML> Mon, 15 Feb 2016 11:10:38 GMT https://community.qlik.com/t5/App-Development/Display-only-above-0-values-in-bar-chart/m-p/1034262#M15970 2016-02-15T11:10:38Z Re: Display only above 0 values in bar chart. https://community.qlik.com/t5/App-Development/Display-only-above-0-values-in-bar-chart/m-p/1034263#M15971 <HTML><HEAD></HEAD><BODY><P>May be this:</P><P></P><P><STRONG>Sum({&lt;Suppliers = {"=Sum(Sales) &gt; 0"}&gt;}Sales)</STRONG></P><P></P><P>and then may be use the dimension limits tab to show the bottom 10 suppliers</P></BODY></HTML> Mon, 15 Feb 2016 16:25:12 GMT https://community.qlik.com/t5/App-Development/Display-only-above-0-values-in-bar-chart/m-p/1034263#M15971 sunny_talwar 2016-02-15T16:25:12Z