Re: color in label of pivot table - Qlik Community

giakoum · ‎2012-09-14

Hi.

I have a pivot table, and have set a background color calculation for the 1st expression. The expression's label gets the color of the first cell. I cannot use visual cues as I need more than 3 ranges. Any ideas?

Thank you.

Report Inappropriate Content · ‎2012-09-14

pfa,

hope it wil helps u

giakoum · ‎2012-09-14

Thank you but it does not help.

I know how to set a background color, I do not want it to affect the expression label.

BR

jonathandienst · ‎2012-09-14

Hi

Try custom formatting the label (I am not sure that this will override the colour incorrectly set). On the View menu, enable Design Grid. Then right click on the problem cell.

Hope that helps

Jonathan

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein

giakoum · ‎2012-09-15

unfortunately this does not work either.

tried that already.

thank you.

whiteline · ‎2012-09-15

Hi,

Can't reproduce the effect. What is your expression for background color ?

giakoum · ‎2012-09-16

Hi

I am including a sample. Note that it only happens if expressions are bellow each other. See attached.

whiteline · ‎2012-09-16

This issue with expressions aligned vertically exists for a few versions.

Don't know the solution.

giakoum · ‎2012-09-16

Very annoying. QlikView can be terrible in simple things...

whiteline · ‎2012-09-16

From the other hand it's powerful... while some other tools can be just annoying