Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor III
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
Highlighted
Champion III
Champion III

Write a background expression for Month like

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

View solution in original post

2 Replies
Highlighted
Champion III
Champion III

Write a background expression for Month like

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

View solution in original post

Highlighted
Specialist
Specialist

Hello, Kozan!

Background expression is here:

backgrnd_col.png