Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

New Contributor

Color Coding Individual Cells in Pivot Table

Hi everyone!

I am currently working on creating a pivot table that has cells that are color coded by measure from max to min.

Below is an example of what it would look like in excel:

Color Coding Excel Example.PNG

I was already able to sort the rows from max to min by sum of the entire row.

Any recommendations for color expressions for the pivot table would be highly appreciated!


I am working in QlikSense.

I found the following tutorial for something similar, but in QlikView: Tile Grid Maps – Qlik Freak

The problem I believe is how I am loading the data in differently from the tutorial.

Here is another source I looked into, but it colors based on each row or column independently, not based on the entire table: Color a Pivot Table

Community Browser