topic Problem with bars coloring in calculated dimensions chart in QlikView https://community.qlik.com/t5/QlikView/Problem-with-bars-coloring-in-calculated-dimensions-chart/m-p/309822#M114405 <HTML><HEAD></HEAD><BODY><P>Hello everyone,</P><P></P><P>I need to show how many sales are 'Good', 'Average' or 'Poor' in each state, I have a bar chart with 2 dimensions state, and a calculated dimension "</P><P></P><P><EM>=if(sales&gt;2,'Good', if(sales&gt;=0,'Average', If(sales&lt;0,'Poor')))</EM>".</P><P></P><P>For each rate, they have different colors, 'Good' - green, 'Average' - Yellow, 'Poor' - Red. Currently, I am using</P><P></P><P> "<EM>=if(sales2&gt;2,RGB(0,255,0), if(sales2&gt;=0,RGB(255,255,0), If(sales2&lt;0,RGB(255,0,0))))</EM>"</P><P></P><P>in calculated colors expression, it worked well when all the rates 'Good', 'Average' and 'Poor' have value but I have problem when there is no any sales in 'Good' rate which mean greater than 2 in my data. Please help, thanks.</P><P></P><P>I apologize if my explanation is not clear, below I have attatched with the sample document to help you for better understanding.</P></BODY></HTML> Wed, 22 Jun 2011 09:26:27 GMT Anonymous 2011-06-22T09:26:27Z Problem with bars coloring in calculated dimensions chart https://community.qlik.com/t5/QlikView/Problem-with-bars-coloring-in-calculated-dimensions-chart/m-p/309822#M114405 <HTML><HEAD></HEAD><BODY><P>Hello everyone,</P><P></P><P>I need to show how many sales are 'Good', 'Average' or 'Poor' in each state, I have a bar chart with 2 dimensions state, and a calculated dimension "</P><P></P><P><EM>=if(sales&gt;2,'Good', if(sales&gt;=0,'Average', If(sales&lt;0,'Poor')))</EM>".</P><P></P><P>For each rate, they have different colors, 'Good' - green, 'Average' - Yellow, 'Poor' - Red. Currently, I am using</P><P></P><P> "<EM>=if(sales2&gt;2,RGB(0,255,0), if(sales2&gt;=0,RGB(255,255,0), If(sales2&lt;0,RGB(255,0,0))))</EM>"</P><P></P><P>in calculated colors expression, it worked well when all the rates 'Good', 'Average' and 'Poor' have value but I have problem when there is no any sales in 'Good' rate which mean greater than 2 in my data. Please help, thanks.</P><P></P><P>I apologize if my explanation is not clear, below I have attatched with the sample document to help you for better understanding.</P></BODY></HTML> Wed, 22 Jun 2011 09:26:27 GMT https://community.qlik.com/t5/QlikView/Problem-with-bars-coloring-in-calculated-dimensions-chart/m-p/309822#M114405 Anonymous 2011-06-22T09:26:27Z