topic Color Bar Chart by calculated dimension in QlikView https://community.qlik.com/t5/QlikView/Color-Bar-Chart-by-calculated-dimension/m-p/1008146#M526100 <HTML><HEAD></HEAD><BODY><P>Hi everyone,</P><P></P><P>I have a little coloring problem within one of my bar charts. </P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/107624_Capture.PNG" style="height: auto;" /></P><P>My Dimension definition looks like:</P><PRE __default_attr="plain" __jive_macro_name="code" class="jive_macro_code _jivemacro_uid_14488890601043190 jive_text_macro" jivemacro_uid="_14488890601043190"> <P>=If(DATEDIFFERENCE &gt;=20,dual('20 or more',20),If(DATEDIFFERENCE &lt; -5,dual('-6 or less',-6),dual(DATEDIFFERENCE,DATEDIFFERENCE)))</P> </PRE><P></P><P>And my backgroundcolor definition on my expression states:</P><PRE __default_attr="plain" __jive_macro_name="code" class="jive_macro_code jive_text_macro _jivemacro_uid_144888921506780" jivemacro_uid="_144888921506780"> <P>If(DATEDIFFERENCE &lt;= 0,Green(),Red())</P> </PRE><P></P><P>Unfortunatly "-6 or less" is colored red, although I want it to be colored green. Everything else works just fine. Has anyone an idea, how to accomplish this?</P><P></P><P>Thanks in advance,</P><P>Claus</P></BODY></HTML> Mon, 30 Nov 2015 13:16:05 GMT 2015-11-30T13:16:05Z Color Bar Chart by calculated dimension https://community.qlik.com/t5/QlikView/Color-Bar-Chart-by-calculated-dimension/m-p/1008146#M526100 <HTML><HEAD></HEAD><BODY><P>Hi everyone,</P><P></P><P>I have a little coloring problem within one of my bar charts. </P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/107624_Capture.PNG" style="height: auto;" /></P><P>My Dimension definition looks like:</P><PRE __default_attr="plain" __jive_macro_name="code" class="jive_macro_code _jivemacro_uid_14488890601043190 jive_text_macro" jivemacro_uid="_14488890601043190"> <P>=If(DATEDIFFERENCE &gt;=20,dual('20 or more',20),If(DATEDIFFERENCE &lt; -5,dual('-6 or less',-6),dual(DATEDIFFERENCE,DATEDIFFERENCE)))</P> </PRE><P></P><P>And my backgroundcolor definition on my expression states:</P><PRE __default_attr="plain" __jive_macro_name="code" class="jive_macro_code jive_text_macro _jivemacro_uid_144888921506780" jivemacro_uid="_144888921506780"> <P>If(DATEDIFFERENCE &lt;= 0,Green(),Red())</P> </PRE><P></P><P>Unfortunatly "-6 or less" is colored red, although I want it to be colored green. Everything else works just fine. Has anyone an idea, how to accomplish this?</P><P></P><P>Thanks in advance,</P><P>Claus</P></BODY></HTML> Mon, 30 Nov 2015 13:16:05 GMT https://community.qlik.com/t5/QlikView/Color-Bar-Chart-by-calculated-dimension/m-p/1008146#M526100 2015-11-30T13:16:05Z