Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
kfahri342
New Contributor III

Format Colouring for one cell - Pivot Table

Hi All,

I have a pivot table, and I need to colour in only specific cells. The only way I have figured out colouring cells is by right-clicking and going on Custom Format Cell. But this method colours the entire dimension, rather than a specific value within that dimension.

Eg. I have a months column [dimension] and only want to colour in Jan & Feb

Month

Jan

Feb
Mar
Apr

Is there a way to do this?

Many Thanks

Kozan

1 Solution

Accepted Solutions
vishsaggi
Esteemed Contributor III

Re: Format Colouring for one cell - Pivot Table

Write a background expression for Month like

= IF(Match(Month, 'Jan', 'Feb'), Green(), White())

2 Replies
vishsaggi
Esteemed Contributor III

Re: Format Colouring for one cell - Pivot Table

Write a background expression for Month like

= IF(Match(Month, 'Jan', 'Feb'), Green(), White())

Sergey_Shuklin
Valued Contributor

Re: Format Colouring for one cell - Pivot Table

Hello, Kozan!

Background expression is here:

backgrnd_col.png