topic Creating ranges in a bar chart in QlikView https://community.qlik.com/t5/QlikView/Creating-ranges-in-a-bar-chart/m-p/320611#M118155 <HTML><HEAD></HEAD><BODY><P>Hi, </P><P>I've go a bar chart with "sold goods" and their percentage. But there are to many different percentages so I want to create ranges (e.g. 0%-5%, 5%-10% and so on).</P><P></P><P>What is the easiest way to do this? </P><P></P><P>Could anyone help? </P></BODY></HTML> Thu, 22 Dec 2011 14:41:56 GMT 2011-12-22T14:41:56Z Creating ranges in a bar chart https://community.qlik.com/t5/QlikView/Creating-ranges-in-a-bar-chart/m-p/320611#M118155 <HTML><HEAD></HEAD><BODY><P>Hi, </P><P>I've go a bar chart with "sold goods" and their percentage. But there are to many different percentages so I want to create ranges (e.g. 0%-5%, 5%-10% and so on).</P><P></P><P>What is the easiest way to do this? </P><P></P><P>Could anyone help? </P></BODY></HTML> Thu, 22 Dec 2011 14:41:56 GMT https://community.qlik.com/t5/QlikView/Creating-ranges-in-a-bar-chart/m-p/320611#M118155 2011-12-22T14:41:56Z Creating ranges in a bar chart https://community.qlik.com/t5/QlikView/Creating-ranges-in-a-bar-chart/m-p/320612#M118156 <HTML><HEAD></HEAD><BODY><P>I think this should work: </P><P></P><P>create a new dimension:</P><P></P><P>=If(percentage_goods &lt; 1.0 or percentage_goods &lt;&gt;0 , Class(percentage_goods , 0.05),'&gt;=1')</P></BODY></HTML> Thu, 22 Dec 2011 14:48:16 GMT https://community.qlik.com/t5/QlikView/Creating-ranges-in-a-bar-chart/m-p/320612#M118156 2011-12-22T14:48:16Z