topic Re: Conditional Coloring in a Bar Chart in QlikView

Conditional Coloring in a Bar Chart

Fri, 11 Jul 2014 08:27:22 GMT

Hi,
How can I make the bars pointing to the left (negative value) to be colored as RED rather than all bars are blue in this bar chart?

Re: Conditional Coloring in a Bar Chart

Gysbert_Wassenaar — Fri, 11 Jul 2014 08:37:06 GMT

Click on the + in front of the expression, select Background Color and enter an expression in the Definition field to calculate the color: =if(sum(Amount)<0, red())

Re: Conditional Coloring in a Bar Chart

aveeeeeee7en — Fri, 11 Jul 2014 08:43:25 GMT

Hi Ronnie

Go to your expression and write the Condition eg. Sum(Value)

Expand the Expression and on Background Color write the condition if(Sum(Value)>=0,Blue(),Red())

It will work for you.

See the Snapshots and Attachment.

Regards

Aviral Nag

Re: Conditional Coloring in a Bar Chart

Fri, 11 Jul 2014 09:11:27 GMT

Thank you both, I got the color now. Works like charm.

Now, if only I could get those long numbers shorten into millions, that would be perfect. Any idea?

Re: Conditional Coloring in a Bar Chart

Gysbert_Wassenaar — Fri, 11 Jul 2014 09:13:47 GMT

num(sum(Amount)/1000000, '#,##0 M')

Re: Conditional Coloring in a Bar Chart

Mon, 14 Jul 2014 00:51:52 GMT

It works! Thank you Gysbert.