Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
Please provide how I can move dimension to the cells header by macro
Before
After
Thanks a lot
Hi,
This procedure can help you:
sub Example
set
Chart = ActiveDocument.GetSheetObject("CH234")Set
Prop = Chart.GetPropertiesProp.TableProperties.NumberOfLeftDimensions = 2
Chart.SetProperties Prop
end sub
Replace the objectID by your objectID, and change the number of left-dimensions according your requirements.
God bless you.
Percy
Good example !!! it works .
One question here , how you get all these different properties alongwith description from ?
Bhushan N
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
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.
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