Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Talk to Experts, a LIVE Q&A Webinar. Bring your Qlik Sense Business questions on Aug. 4th. Register
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor III
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
Highlighted
Creator II
Creator II

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.

View solution in original post

2 Replies
Highlighted
Creator II
Creator II

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.

View solution in original post

Highlighted
Contributor III
Contributor III

It worked perfectly!

Many thanks for the help.