Discussion board where members can get started with QlikView.
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
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 ?
In your Expression, click the + sign next to the expression. Enter your color expression as the "Background Color" expression.
View solution in original post
you change the colors in the expression tab
As per your Requirement in the expression