How to NOT set the color of the Expression Heading in Pivot table
An expression is being used in my pivot chart. For the Text Color of one of the Expressions, I am also using an Expression. However, it is changing the color of the expression heading or Label as well, how to avoid changing the colomn label for the expression as well.
Re: How to NOT set the color of the Expression Heading in Pivot table
It's a bug, or as QlikTech tells us, a "Working As Designed". There's no good solution that I know of, but sometimes a workaround is to add a total line and put it at the top, between the data and the heading. Then change your color expression to add if(dimensionality(),...). That avoids ever coloring the total row, and since the total row is on top, it won't color the column heading either. This isn't always practical, of course.
Edit: Looks like you already got your answer. I didn't see it before posting. I'm leaving mine up as additional information.