Pivot table column width problem

[#1]

Hi,

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.

sub resize
 set chart = ActiveDocument.GetSheetObject("CH02")
  chart.SetPixWidth 1,100
 end sub

Switching dimensions back to rows is not an option.

[Gysbert_Wassenaar · Accepted solution]

Try using a straight table with the Horizontal option checked on the Presentation tab. See attached qvw

[#3]

Nice, thank you.

That works just fine.

[jonathan_dau]

Hi Gysbert,

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 : (

Jonathan

[jonathan_dau]

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.

Jonathan

[#6]

Hi Jonathan

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:

=RGB(220,220,220)

(this is light gray I think)

You can find the exact colornumbers by clicking on them (pic2)

Hop it helps

Cheers

Bruno

[qlikviewforum]

When I do that I am getting expression values is coming twice!

[qlikviewforum]

Any update from anyone on this?

[qlikviewforum]

Sorry it was my mistake it was looking good now!

[#10]

If I am having another dimension which i want to show as row along with the expressions...