topic Re: Pivot table column width problem in QlikView

Pivot table column width problem

Tue, 18 Dec 2012 10:32:36 GMT

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.

Re: Pivot table column width problem

Gysbert_Wassenaar — Tue, 18 Dec 2012 10:36:25 GMT

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

Re: Pivot table column width problem

Tue, 18 Dec 2012 10:51:04 GMT

Nice, thank you.

That works just fine.

Re: Pivot table column width problem

jonathan_dau — Mon, 22 Apr 2013 16:52:44 GMT

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

Re: Pivot table column width problem

jonathan_dau — Mon, 22 Apr 2013 16:58:08 GMT

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

Re: Pivot table column width problem

Wed, 01 May 2013 11:45:30 GMT

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

Re: Pivot table column width problem

qlikviewforum — Mon, 22 Sep 2014 18:17:59 GMT

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

Re: Pivot table column width problem

qlikviewforum — Tue, 23 Sep 2014 03:06:44 GMT

Any update from anyone on this?

Re: Pivot table column width problem

qlikviewforum — Tue, 23 Sep 2014 07:15:12 GMT

Sorry it was my mistake it was looking good now!

Re: Pivot table column width problem

Wed, 16 Sep 2015 10:39:53 GMT

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