Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

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.

The Label is called:  TestExpression

The formula for Text Color in the pivot table is: 

     if(       (SUM(If(Phone='superphone', Results))) =0           ,rgb(255,0,0)                                                                                                                    )

1 Solution

Accepted Solutions
Not applicable

How to NOT set the color of the Expression Heading in Pivot table

Tim Benoit replied in http://community.qlik.com/message/105948#105948 that the problem is that the heading takes the color or the first row. 

I changed the load order so that one of the items that always pass the expression test are on top and ok for now.  hmm... works this time...

3 Replies
Not applicable

How to NOT set the color of the Expression Heading in Pivot table

Tim Benoit replied in http://community.qlik.com/message/105948#105948 that the problem is that the heading takes the color or the first row. 

I changed the load order so that one of the items that always pass the expression test are on top and ok for now.  hmm... works this time...

MVP
MVP

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.

Not applicable

Re: How to NOT set the color of the Expression Heading in Pivot table

Thanks John….

I have a row that always passes the muster, so I loaded that on top and used Sort Load Order. Hmm.. Said, but worked.

I will keep your response in mind, for likely will need it later.

Don

Community Browser