topic More bar chart questions in QlikView https://community.qlik.com/t5/QlikView/More-bar-chart-questions/m-p/577831#M214862 <HTML><HEAD></HEAD><BODY><P>Pls see attached.</P><P></P><P>Bars were too far apart so I clicked the Continuous checkbox which moved the bars closer together, but changed the dates from a normal format to Julian!</P><P></P><P>Also, in the Color tab, setting Value &gt; 0 for green works well, but Value &lt; 0 for red, doesn't work, all the bar remain green.&nbsp; Why?</P><P></P><P>Thx,</P><P></P><P>Brooks</P></BODY></HTML> Fri, 14 Mar 2014 16:39:40 GMT 2014-03-14T16:39:40Z More bar chart questions https://community.qlik.com/t5/QlikView/More-bar-chart-questions/m-p/577831#M214862 <HTML><HEAD></HEAD><BODY><P>Pls see attached.</P><P></P><P>Bars were too far apart so I clicked the Continuous checkbox which moved the bars closer together, but changed the dates from a normal format to Julian!</P><P></P><P>Also, in the Color tab, setting Value &gt; 0 for green works well, but Value &lt; 0 for red, doesn't work, all the bar remain green.&nbsp; Why?</P><P></P><P>Thx,</P><P></P><P>Brooks</P></BODY></HTML> Fri, 14 Mar 2014 16:39:40 GMT https://community.qlik.com/t5/QlikView/More-bar-chart-questions/m-p/577831#M214862 2014-03-14T16:39:40Z Re: More bar chart questions https://community.qlik.com/t5/QlikView/More-bar-chart-questions/m-p/577832#M214863 <HTML><HEAD></HEAD><BODY><P>1. On the number tab you can change the formatting of the continuous axis. Change it to the date format you want.</P><P></P><P>2. No, idea. Try clicking on the + in front of the expression, choose Background Color and enter in the Definition field an expression to calculate the color. Something like if( <EM>sum(Amount)</EM> &gt; 0, green(), red() ). Replace sum(Amount) with the expression that calculates the values of the bars.</P></BODY></HTML> Fri, 14 Mar 2014 16:44:50 GMT https://community.qlik.com/t5/QlikView/More-bar-chart-questions/m-p/577832#M214863 Gysbert_Wassenaar 2014-03-14T16:44:50Z Re: More bar chart questions https://community.qlik.com/t5/QlikView/More-bar-chart-questions/m-p/577833#M214864 <HTML><HEAD></HEAD><BODY><P>Thanks Gysbert, you fixed #1.&nbsp; I don't see just a Background color.&nbsp; There is Background Color under Frame Background but that turns the background, not the bars, a different color.</P></BODY></HTML> Fri, 14 Mar 2014 16:57:21 GMT https://community.qlik.com/t5/QlikView/More-bar-chart-questions/m-p/577833#M214864 2014-03-14T16:57:21Z Re: More bar chart questions https://community.qlik.com/t5/QlikView/More-bar-chart-questions/m-p/577834#M214865 <HTML><HEAD></HEAD><BODY><P><IMG alt="comm110737.png" class="jive-image" src="https://community.qlik.com/legacyfs/online/55077_comm110737.png" style="width: 620px; height: 317px;" /></P></BODY></HTML> Fri, 14 Mar 2014 17:03:12 GMT https://community.qlik.com/t5/QlikView/More-bar-chart-questions/m-p/577834#M214865 Gysbert_Wassenaar 2014-03-14T17:03:12Z Re: More bar chart questions https://community.qlik.com/t5/QlikView/More-bar-chart-questions/m-p/577835#M214866 <HTML><HEAD></HEAD><BODY><P>Super, that did it.&nbsp; Thanks!</P></BODY></HTML> Fri, 14 Mar 2014 17:19:51 GMT https://community.qlik.com/t5/QlikView/More-bar-chart-questions/m-p/577835#M214866 2014-03-14T17:19:51Z