Colors in bar chart

Thu, 10 Nov 2011 13:22:15 GMT

Hi,

I want to have two colors on the bars in a chart. The bars are calculated through a if statement:

if ( something * something = something, true, false )

in the case above I have a date dimension, so for all true I want the bar to be green and for all false I want the bar to be red. Is this possible and how should I write the script?

Thanks!

Colors in bar chart

Thu, 10 Nov 2011 13:43:30 GMT

Hi,

this can be done in following way:

in Expressions tab of the bar chart properties expand expression item and you will find there its 'Background color' attribute. In definition for that attribute add if(<your_date_condition>, RGB( 50, 140, 3), RGB( 250, 4, 3))

regards

topic Colors in bar chart in QlikView

Colors in bar chart

Colors in bar chart