topic Pivot Table move dimension to the header by macro in QlikView

Pivot Table move dimension to the header by macro

Tue, 08 Jun 2010 07:41:24 GMT

Hi All,

Please provide how I can move dimension to the cells header by macro

Before

After

Thanks a lot

Pivot Table move dimension to the header by macro

pgamarra — Wed, 16 Jun 2010 05:30:51 GMT

Hi,

This procedure can help you:

sub Example

set

Chart = ActiveDocument.GetSheetObject("CH234")

Set

Prop = Chart.GetProperties

Prop.TableProperties.NumberOfLeftDimensions = 2

Chart.SetProperties Prop

end sub

By this procedure, the first two dimensions stay in the left side and the other ones go to the header.

Replace the objectID by your objectID, and change the number of left-dimensions according your requirements.

God bless you.

Percy

Pivot Table move dimension to the header by macro

Wed, 16 Jun 2010 06:21:59 GMT

Good example !!! it works .

One question here , how you get all these different properties alongwith description from ?

Bhushan N

Pivot Table move dimension to the header by macro

pgamarra — Mon, 21 Jun 2010 19:41:11 GMT

I found all information exploring the APIGuide.qvw aplication in the QlikView documentation directory (In my case:"C:\Program Files\QlikView\Documentacion") and looking for some threads in this forum.

God blessy you

Percy

Pivot Table move dimension to the header by macro

Mon, 06 Sep 2010 07:13:39 GMT

Hi,

I'm new to Qlikview and I have the same problem, but I don't know how to apply the procedure mentioned here.

Please help.

Thank you.

Re: Pivot Table move dimension to the header by macro

Thu, 04 Oct 2012 21:49:18 GMT

Hello,

I did the same thing you suggested and I was able to moved the dimension to the header row. But, now I am having a hard time making those dimension values bold. I tried the following code (using the api.qvw). However, the funny thing is it works when my dimension is vertical and when I move it to the header row, only 3 cells get the bold format and the rest don't. Any ideas? Appreciate your input on this. Thanks!

set chart = ActiveDocument.GetSheetObject("CH05")

chart.AddDimension x

set gp2 = chart.GetProperties

set dims2 = gp2.Dimensions

set bce = dims2(dims2.Count-1).AttributeExpressions.TextFmtExp

bce.Definition.v = "'<b>'"

gp2.TableProperties.NumberOfLeftDimensions = dims2.Count-1