Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

giakoum
Honored Contributor 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

Re: color in label of pivot table

pfa,

hope it wil helps u

giakoum
Honored Contributor II

Re: color in label of pivot table

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

MVP
MVP

Re: color in label of pivot table

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
Honored Contributor II

Re: color in label of pivot table

unfortunately this does not work either.

tried that already.

thank you.

whiteline
Honored Contributor II

Re: color in label of pivot table

Hi,

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

giakoum
Honored Contributor II

Re: color in label of pivot table

Hi

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

whiteline
Honored Contributor II

Re: color in label of pivot table

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

Don't know the solution.

giakoum
Honored Contributor II

Re: color in label of pivot table

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

whiteline
Honored Contributor II

Re: color in label of pivot table

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

Community Browser