topic Bar Graph - Bar Colors based on Value in QlikView

Bar Graph - Bar Colors based on Value

Wed, 14 Nov 2012 11:12:12 GMT

Hey Guys,

Hope you all doing great,

Im a beginner and i was wondering if you could help me out with this simple issue.

I have a bar graph which displays bars of a value in percentage.

How do i make the bars turn green color for those above 90% value and red color for those below 90%?

Thanks a million!!

Justin

Re: Bar Graph - Bar Colors based on Value

Gysbert_Wassenaar — Wed, 14 Nov 2012 11:15:50 GMT

Set an expression for the background color. Click on the plus in front of the expression. The expression would be something like this: if( value > 0.9, green(), red() ). Replace 'value' with the field or expression that determines value.

Re: Bar Graph - Bar Colors based on Value

Wed, 14 Nov 2012 11:21:03 GMT

Thanks a million mate!