Discussion Board for collaboration related to QlikView App Development.
I have a pivot table where expressions are rows and dimensions are columns (see the attached demo for illustration).
Is there a way to resize the first column (expression labels) without resizing dimension columns at the same time?
As seen you can see from the attached document there is a lot of wasted space if columns can't be resized separately.
I tried the following macro but it will resize all the columns including the first label column.
set chart = ActiveDocument.GetSheetObject("CH02")
Switching dimensions back to rows is not an option.
Indeed your solution is the good one but it has a side effect: you loose the ability to customize expression label.
For example I try to put some of the expression labels in Bold with a particular color background. Unfortunately the format and color apply only to data and not to the label.
Does anybody have any idea how I can do to customize these labels. I've tried using custom format cell without success. That's what happens when your client wants to do excel like Qlikview app : (
By the way sorry for being redundant because we can find a lot of posts on this problem but unfortunately I was unable to find the solution.
My eternal gratitude if someone know the trick.
I had the same problem but eventually got it right
You do it by formating background color/text color and/or text format in the Dimensionstab (pic1)
For color use the expression:
(this is light gray I think)
You can find the exact colornumbers by clicking on them (pic2)
Hop it helps