Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
Highlighted
Not applicable

How to change to cell background color based on a value of a column in Pivot Table?

I want to change the background/foreground color of the row in a Pivot Table that matches the condition. (value of a certain column).

Is there a way i can do this without adding the expression for the the Background Color for every single dimension?

Also i found that if i add expression to the Background Color of a Dimension, it ignores my Expression based on which i am filtering the data.

1 Solution

Accepted Solutions

Re: How to change to cell background color based on a value of a column in Pivot Table?

6 Replies
greeshma_k
Contributor III

Re: How to change to cell background color based on a value of a column in Pivot Table?

Right click on the cell and select custom format cell. This might help. If this option is not visible then go to User Preferences >> Design tab >> Always show design menu options

Re: How to change to row color based on a value of a column in Pivot Table?

Would you be able to share some sample data with your expected output in an Excel file?

Re: How to change to cell background color based on a value of a column in Pivot Table?

Not applicable

Re: How to change to cell background color based on a value of a column in Pivot Table?

Option is visible but I do not see any option to add an expression in there.

Not applicable

Re: How to change to cell background color based on a value of a column in Pivot Table?

Works but ignores the "Expression" and thus shows all the data

Not applicable

Re: How to change to cell background color based on a value of a column in Pivot Table?

Never mind. I was getting over ambitious after seeing Dimensionality function and was trying to do little more than i can handle right now.