topic Is it possible to change colour of bar chart depending if +ve or -ve? (QV v8.5) in QlikView https://community.qlik.com/t5/QlikView/Is-it-possible-to-change-colour-of-bar-chart-depending-if-ve-or/m-p/219242#M72288 <HTML><HEAD></HEAD><BODY><P>Muito obrigado para isso! exactly what I was looking for, and wasn't sure how to define the "column(1)"</P><P>Many thanks!</P><P>Kind regards,</P><P>Rich</P></BODY></HTML> Wed, 16 Feb 2011 20:05:35 GMT 2011-02-16T20:05:35Z Is it possible to change colour of bar chart depending if +ve or -ve? (QV v8.5) https://community.qlik.com/t5/QlikView/Is-it-possible-to-change-colour-of-bar-chart-depending-if-ve-or/m-p/219240#M72286 <HTML><HEAD></HEAD><BODY><P>Was wondering how to change the color of a bar chart, depending on whether values are positive or negative...?</P><P>Noticed within the "Expressions" tab, you can define "Background Color", but not exactly sure how to use this?</P><P>Any tips appreciated!</P><P>Kind regards,</P><P>Rich</P><P></P></BODY></HTML> Wed, 16 Feb 2011 19:38:31 GMT https://community.qlik.com/t5/QlikView/Is-it-possible-to-change-colour-of-bar-chart-depending-if-ve-or/m-p/219240#M72286 2011-02-16T19:38:31Z Is it possible to change colour of bar chart depending if +ve or -ve? (QV v8.5) https://community.qlik.com/t5/QlikView/Is-it-possible-to-change-colour-of-bar-chart-depending-if-ve-or/m-p/219241#M72287 <HTML><HEAD></HEAD><BODY><P>See example.</P><P>For eache expression put</P><P>If(Column(1)&gt;0,green(),red())</P><P><A href="http://community.qlik.com/cfs-file.ashx/__key/CommunityServer.Discussions.Components.Files/11/8473.PrintScreen_5F00_2011_2D00_02_2D00_16-16-45-00.gif"><IMG alt="" border="0" src="http://community.qlik.com/resized-image.ashx/__size/550x0/__key/CommunityServer.Discussions.Components.Files/11/8473.PrintScreen_5F00_2011_2D00_02_2D00_16-16-45-00.gif" /></A></P></BODY></HTML> Wed, 16 Feb 2011 19:46:06 GMT https://community.qlik.com/t5/QlikView/Is-it-possible-to-change-colour-of-bar-chart-depending-if-ve-or/m-p/219241#M72287 2011-02-16T19:46:06Z Is it possible to change colour of bar chart depending if +ve or -ve? (QV v8.5) https://community.qlik.com/t5/QlikView/Is-it-possible-to-change-colour-of-bar-chart-depending-if-ve-or/m-p/219242#M72288 <HTML><HEAD></HEAD><BODY><P>Muito obrigado para isso! exactly what I was looking for, and wasn't sure how to define the "column(1)"</P><P>Many thanks!</P><P>Kind regards,</P><P>Rich</P></BODY></HTML> Wed, 16 Feb 2011 20:05:35 GMT https://community.qlik.com/t5/QlikView/Is-it-possible-to-change-colour-of-bar-chart-depending-if-ve-or/m-p/219242#M72288 2011-02-16T20:05:35Z Is it possible to change colour of bar chart depending if +ve or -ve? (QV v8.5) https://community.qlik.com/t5/QlikView/Is-it-possible-to-change-colour-of-bar-chart-depending-if-ve-or/m-p/219243#M72289 <HTML><HEAD></HEAD><BODY><P> Hello,</P><P></P><P>Can we have a different color for each bar on the chart,irrespective of the value, means even if the adjacent bars have same value they should have different colors ? </P><P></P><P></P><P>Regards</P></BODY></HTML> Thu, 10 May 2012 01:46:09 GMT https://community.qlik.com/t5/QlikView/Is-it-possible-to-change-colour-of-bar-chart-depending-if-ve-or/m-p/219243#M72289 2012-05-10T01:46:09Z