Qlik Community

Ask a Question

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
April 22, 2PM EST: Learn about GeoOperations in Qlik Sense SaaS READ MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
philip_radovich
Contributor III
Contributor III

Color Coding Pivot Table

Hi,

I am trying to color code the values of my pivot table based on the different dimensions in the column section. I have the AVG Value as the measure and I currently have this If (Avg(Value)>=1500, RGB(87,149,50), RGB(170,57,57)) for my background color expression but it highlights every single value instead of the specific one's I need in the column. Is there a way to set the color of each value different based on the parameters needed for the column?

Thanks,

Philip Radovich

1 Solution

Accepted Solutions
Chanty4u
Champion III
Champion III

I think this question about Qliksense .

Goto colur tab and give  colours based on expresion same  the expression what u have

View solution in original post

4 Replies
sunny_talwar

Is this not what you are expecting?

Capture.PNG

When Avg(Value) >=1500 the color is green and when it is below 1500 it is red?

Chanty4u
Champion III
Champion III

I think this question about Qliksense .

Goto colur tab and give  colours based on expresion same  the expression what u have

View solution in original post

sunny_talwar

My bad

Chanty4u
Champion III
Champion III

No worries bro.even though it is correct if he uses Qlikview