topic bar chart color based on threshold in QlikView

bar chart color based on threshold

Sat, 11 Jan 2014 07:13:05 GMT

hi all,

i have my bar chart having threshold which shows avg(value).i had given the condition in the expression for the background color of bar chart like color blue if less than 400 else red.its working fine.

But my question is can i show blue color on the bars(red) which are below the green line? that is like this

Re: bar chart color based on threshold

Gysbert_Wassenaar — Sat, 11 Jan 2014 08:01:48 GMT

See my solution in this discussion: Different color for a bar based on Reference Value

Re: bar chart color based on threshold

whiteline — Sat, 11 Jan 2014 08:04:57 GMT

Hi.

For almost static charts you can create two objects: background 'red' chart and transparent overlay 'blue' chart.

Another way, create additional Calculated dimension: ValueList(1,2)

And expression that splits the values:

=pick(rowno(), RangeMin(Value, 400), RangeMax (Value, 400)-400)

Re: bar chart color based on threshold

Sat, 11 Jan 2014 10:52:51 GMT

Thank you..