topic Primary Dimensions Labels in QlikView

Primary Dimensions Labels

Mon, 22 Aug 2011 07:57:17 GMT

Hi,

Is it possible to change the Primary Dimensions Labels angle/orientation of a (bar) chart with a VBScript macro?

Just as you would do in the property windows by selecting the "-", "/" or "|" modes!

Thanks, in advance, for your answers.

Lilian

Re: Primary Dimensions Labels

Mon, 22 Aug 2011 08:34:40 GMT

Hi,

See if the attached sample can help you.

Cheers.

Primary Dimensions Labels

Mon, 22 Aug 2011 09:19:28 GMT

Thanks for the quick answer BlackRockS.

I did find something interesting in your exemple but actually I've noticed that I was incomplete in my post!

What I try to do by macro is to change the primary (or secondary) dimension label orientation like you can do in the property box, you know the "-", "/" or "|" modes!

Thanks again BlackRockS.

Re: Primary Dimensions Labels

Tue, 23 Aug 2011 02:30:45 GMT

Hi,

See if the attached sample can help you.

Cheers.

Primary Dimensions Labels

Tue, 23 Aug 2011 08:27:15 GMT

Thanks a lot BlackRockS, that's what I wanted!

Cheers

-- Lilian

Primary Dimensions Labels

Tue, 23 Aug 2011 09:21:15 GMT

lilian You must mark blackrocks answer right, not your reply

Re: Primary Dimensions Labels

Fri, 12 Sep 2014 06:19:21 GMT

Just in case people have personal edition and can't open the file... this is the macro from the above attachment.

sub tst()

set chart = ActiveDocument.Sheets("Main").CreateBarChart

chart.AddDimension "Clients"

chart.AddExpression "sum(ConsultingAmount)"

set p = chart.GetProperties

'p.ChartProperties.MajorDimensionTextMode = 0 'horizontal -

'p.ChartProperties.MajorDimensionTextMode = 1 'vertical |

p.ChartProperties.MajorDimensionTextMode = 2 'inclined /

chart.SetProperties p

end sub