Discussion Board for collaboration on QlikView Layout & Visualizations.
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?
hope it wil helps u
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.
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
unfortunately this does not work either.
tried that already.
Can't reproduce the effect. What is your expression for background color ?
I am including a sample. Note that it only happens if expressions are bellow each other. See attached.
This issue with expressions aligned vertically exists for a few versions.
Don't know the solution.
Very annoying. QlikView can be terrible in simple things...
From the other hand it's powerful... while some other tools can be just annoying