topic Column Width in Pivot-Table in QlikView

Column Width in Pivot-Table

Thu, 01 Jul 2010 09:50:36 GMT

Hi to all, it's me again....

today i have a problem with the column width in a Pivot Table. I will show you:

Country is the Dimension, all other columns are formulars. Here I have no problems with different column width.

But my aim is a Pivot Table like the next picture,

And here, all columns have the same width. I tried with a macro, but any changes will effect all columns.

sub CAdjust
set ch = ActiveDocument.GetSheetObject("CH16")
ch.SetPixWidth 0, 200
end sub

Does anyone know a solution for that problem?

best regards

Stefan

Column Width in Pivot-Table

TK_ — Thu, 01 Jul 2010 13:27:08 GMT

I have the exact same problem.

If you use a straight table instead, it will work, but if you also have users with the the ajax client then you can't use the straight table because it won't show up correctly in ajax..

I have tested this on my client (64bit) in QV v9 SR3 and SR4, and also the latest beta 10 version, but I get the same problem in all versions.

Hope someone can help us on this one.

cheers

Terje

AW:Re: Column Width in Pivot-Table

Thu, 01 Jul 2010 14:06:22 GMT

I don't think so that a "straight" table would work with my data.

Or is there a opportunity to display the dimension horizontal and the data vertical?

best regards Stefan.

AW:Re: Column Width in Pivot-Table

TK_ — Thu, 01 Jul 2010 19:42:30 GMT

I'm not sure if I understand you correctly, but mark your chart as a straight table instead of a pivot table and go to the Presentation tab. Here you can set the horizontal flag and the result is the dimension horizontal og expressions vertical.

But this won't work in the ajax client for some strange reason.

regards

Terje

AW:Re: AW:Re: Column Width in Pivot-Table

Fri, 02 Jul 2010 08:57:18 GMT

ok, that's quite easy.....

... but exactly what I was looking for. Sometime we're thinking too complicated...

Thousand Thanks,

best regards

Stefan