topic Re: How do I set dimension limits with VBScript macro? in QlikView

How do I set dimension limits with VBScript macro?

Fri, 01 Feb 2013 17:08:10 GMT

Hello everyone,

please help me with setting up dimension limits with VBScript macro.

I can't find any reference in API how to do this.

If you have an example code please post it here.

If you have an idea where to look for documentation please respond as well.

Thanks in advance

Re: How do I set dimension limits with VBScript macro?

Wed, 17 Apr 2013 10:47:37 GMT

Hi Victor,

API Guide contains some information, but it is not documented well, there are no examples and description.

You should check IOtherTotalSpecProp class.

see the following example

Top 10 Largest values:

set chart = ActiveDocument.Activesheet.CreateStraightTable
chart.AddDimension "ProductType"
chart.AddExpression "sum(Amount)"
set cp = chart.GetProperties
set dims = cp.Dimensions
dims(0).OtherTotalSpec.OtherMode = 1
dims(0).OtherTotalSpec.OtherCounted.v = 10
chart.SetProperties cp

Best Regards,
Ruslan

Re: How do I set dimension limits with VBScript macro?

Thu, 18 Apr 2013 10:49:35 GMT

It works! Thank you very much!

Re: How do I set dimension limits with VBScript macro?

nivellen11 — Tue, 08 Apr 2014 10:10:05 GMT

Any idea how to set properties in this way?

Greater than or Equal to 40% exact amount

Show Others

Re: How do I set dimension limits with VBScript macro?

Thu, 20 Aug 2015 13:25:45 GMT

Hi,

what would you add to the script to tell it to reverse these dimension limits if they are set?

regards

Lukas