Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

More than 3 types of conditional formatting?

Morning,

I have a pivot table which contains various numeric values.

I'd like to colour code these to create a heatmap, by changing cell background colours.

It seems you can only set three different colours.

Is there anyway to get more colours?

Thanks,

R

Tags (1)
3 Replies
Not applicable

More than 3 types of conditional formatting?

Hi,

you can define the background colour with an expression. Open the + before the expression and there you find a field "background colour".

Regards

vicky

Not applicable

More than 3 types of conditional formatting?

Do you have an example of a condition?

I'm new to the syntax of QlikView expressions :-)

IAMDV
Not applicable

Re: More than 3 types of conditional formatting?

Hi,

Under the Expression Tab, click on the sign which is on the left hand side of the expression. Then you can use the BackGround Color and Text Color options. You can write nested IF statements based on number conditions/colors you wanted to specify. Also, you can use the Pick function to get this working.

I am attaching a screenshot for you reference. I hope this helps!

Conditional formatting.png

Cheers - DV