Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Highlighted
GabrielOtet
New Contributor III

Current cell in a Pivot table

Dear all,

I have to color the cells in a Pivot table if a condition is in place.

The tricky part is that I want to collor every cell in a different collor (based on the value which is inside).

I know how to color it based on the Row or Collumn condition but it will color the complete line and not only a cell.

Do you know if something like this is possible?

I'm thinking of something that enables me to operate into the current cell, like:

If (current cell value > something, rgb(...), rgb (...)) - unfortunately I'm not able to do it

1 Solution

Accepted Solutions
skamath1_metlif
Contributor II

Re: Current cell in a Pivot table

Put the same expression as that on the measures in the if condition.
For example, if your measure expression is Sum(Sales) then in the background color expression enter the following.

IF ( Sum(Sales) > 5000000 ,LightGreen(),LightBlue())

You can add nested IF function for different color conditions.
2 Replies
skamath1_metlif
Contributor II

Re: Current cell in a Pivot table

Put the same expression as that on the measures in the if condition.
For example, if your measure expression is Sum(Sales) then in the background color expression enter the following.

IF ( Sum(Sales) > 5000000 ,LightGreen(),LightBlue())

You can add nested IF function for different color conditions.
GabrielOtet
New Contributor III

Re: Current cell in a Pivot table

It worked perfectly!

Many thanks for the help.