Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
giakoum
Partner - Master II
Partner - Master II

color in label of pivot table

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.

11 Replies
Not applicable

pfa,

hope it wil helps u

giakoum
Partner - Master II
Partner - Master II
Author

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
Partner - Champion III
Partner - Champion III

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
Partner - Master II
Partner - Master II
Author

unfortunately this does not work either.

tried that already.

thank you.

whiteline
Master II
Master II

Hi,

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

giakoum
Partner - Master II
Partner - Master II
Author

Hi

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

whiteline
Master II
Master II

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

Don't know the solution.

giakoum
Partner - Master II
Partner - Master II
Author

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

whiteline
Master II
Master II

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