topic Re: Different barcolors in QlikView

Different barcolors

tomhovens — Wed, 18 Feb 2015 10:16:24 GMT

Dear Qlikviewer,

how could I give the red bars different colors in the bar, depending on an other field

Re: Different barcolors

Anonymous — Wed, 18 Feb 2015 10:23:18 GMT

Tom,

Go to your expression, clic on [+] icon to expand, and edit the background color, like this:

=if(sum(Sales)>0, rgb(0,183,0), rgb(194,0,0))

Marc.

Re: Different barcolors

Anonymous — Wed, 18 Feb 2015 10:23:18 GMT

In the Chart Properties on the expression for the bar expand the +to the left of it and enter your required expression for back ground with something like :

if ( [YouDim] = 'A' , Blue() , Yellow() )

Re: Different barcolors

Anonymous — Wed, 18 Feb 2015 10:24:59 GMT

Go to your expression. Click on the + symbol and give the condition for the color in the Background Color option.

Re: Different barcolors

jpenuliar — Wed, 18 Feb 2015 10:58:03 GMT

This might prove useful:

Re: Different barcolors

tomhovens — Thu, 19 Feb 2015 14:00:08 GMT

Not exactly what I tought, it has to be a sort of stacked bars and the Kontr-stplts depends the colour of the bar