Qlik Community

Qlik Sense Cloud Discussions

Highlighted
DGO
New Contributor II

Pivot Table - Color one dimension of a column

I have set a color expression for the calculated field '% of # of Orders' to change the background to red if the value is less than 50%, but how can I apply it to just Column 1?

 

Screen Shot 2019-02-20 at 8.27.16 AM.png

Thanks in advance!

Labels (4)
2 Replies
alexandernatale
New Contributor III

Re: Pivot Table - Color one dimension of a column

Have you tried to set the expression on color only for the expression of column 1?

DGO
New Contributor II

Re: Pivot Table - Color one dimension of a column

Column 1 is actually the value of a calculated dimension. The dimension has 2 values so there are 2 columns. I don't see how I can set the color in the dimension. % of # of Orders is the Measure where I can set the color.