Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

Conditionnal formatting - Block chart

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

1 Solution

Accepted Solutions
Highlighted
MVP & Luminary
MVP & Luminary

Re: Conditionnal formatting - Block chart

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

2015-03-25_18-25-54.jpg

-Rob

http://masterssummit.com

http://robwunderlich.com

View solution in original post

2 Replies
Highlighted
MVP & Luminary
MVP & Luminary

Re: Conditionnal formatting - Block chart

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

2015-03-25_18-25-54.jpg

-Rob

http://masterssummit.com

http://robwunderlich.com

View solution in original post

Highlighted
Not applicable

Re: Conditionnal formatting - Block chart

Hi

you  change the colors in the expression tab

2.jpg

As per your Requirement in the expression

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