topic Re: Conditionnal formatting - Block chart in QlikView

Conditionnal formatting - Block chart

Wed, 25 Mar 2015 21:46:17 GMT

Hi the community,

I'm trying to build a block chart made of 40+ blocks. The color of each block will depend wether it's 'yes' (green), 'no' (red)

I wrote the formula (see below) under color tab/dataapperance/calculatedcolor but it doesnt work + it only applies to one dimension and not the 39 others.

if (Expression) = 'yes', RGB (255, 0, 0), RGB (0, 255, 0))

unit A, yes

unit B, yes

unit C, no

unit D, yes

unit E, no

etc

An other pbm I'm facing: the condition is a variable and might change from yes to no every other month.

Does anyone of you know how to proceed ?

Thank you

Re: Conditionnal formatting - Block chart

rwunderlich — Wed, 25 Mar 2015 22:27:13 GMT

In your Expression, click the + sign next to the expression. Enter your color expression as the "Background Color" expression.

-Rob

http://masterssummit.com

http://robwunderlich.com

Re: Conditionnal formatting - Block chart

Thu, 26 Mar 2015 12:32:16 GMT

you change the colors in the expression tab

As per your Requirement in the expression

if (Expression) = 'yes', RGB (255, 0, 0), RGB (0, 255, 0))