topic Re: Color Font Pivot Table in QlikView

Color Font Pivot Table

Wed, 03 Apr 2013 19:40:33 GMT

Hello, people!

I have a pivot table and set rules to color the font according to particular characteristics of each record. But when I do not find that selection in the expression value calculation, the colors are lost are changed to black.

How can I get around this?

Thank you for attention!

Stive

Re: Color Font Pivot Table

swuehl — Thu, 04 Apr 2013 08:53:04 GMT

But when I do not find that selection in the expression value calculation, the colors are lost are changed to black.

I am not sure I fully understood. I assume you are using a text color attribute expression in expression tab, right?

How does your current attribute expression look alike?

(Or, would make things even more simple: Could you upload a small sample application here to the forum?)

Re: Color Font Pivot Table

Thu, 04 Apr 2013 13:11:03 GMT

Hello swuehl,

It's a very specific context that would take too long to explain the details, but I am sending a sample that shows the problem. There you will see that one of my expressions "must" use Set Analysis (total) and thus independent of the selection made, this column will always be shown and the other can be changed according to the selection. I used a formula to color the first column, but when I select the colors change.

Sorry for the confusing English!

PS: Please do not reply with another qvw because my client purchased the server but does not have "Named Cal."

Thank you!

Stive

Re: Color Font Pivot Table

swuehl — Thu, 04 Apr 2013 18:32:53 GMT

Try something like this as text color attribute expression:

=If(only({1}F1)='A',RGB(0,127,0),

If(only({1}F1)='B',RGB(127,0,0),

If(only({1}F1)='C',RGB(0,0,127),RGB(255,255,0))))

Re: Color Font Pivot Table

Thu, 16 May 2013 11:00:11 GMT

swuehl,

Thanks for your help! Your solution is excellent!

Another solution that I developed, is to create a with values RGB field on load and then use the expression:

Only ({1 <1 = {1}>} DFC.RGB)

Greetings!

Stive - Brazil