topic Re: Limit Legend (characters) in a Bar chart using Macro in QlikView

Limit Legend (characters) in a Bar chart using Macro

Tue, 22 Oct 2013 14:12:12 GMT

Hi,

Can someone tell me how I can limit the number of characters in legends in a bar chart using macro? (Basically set the value which can be accessed using Properties > Presentation > Legend > Limit Legend. )

Checked the available APIs, but couldn't find any relevant API.

Re: Limit Legend (characters) in a Bar chart using Macro

Tue, 22 Oct 2013 14:42:52 GMT

Hi Balaji,

may be you can define the space area of your legend to get your goal.

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

Graph.AddDimension "ProductType"

Graph.AddDimension "Customer"

Graph.AddExpression "sum(Amount)"

set p = Graph.GetProperties

set leg = p.ChartProperties.Legend

leg.DockedPosition = 4 'free floating

leg.Position.Top = 100

leg.Position.Left = 100

leg.Position.Height = 200

leg.Position.Width = 200

leg.OnTop = true

leg.UserSized = true

Graph.SetProperties p

Regards

Corrado.

Re: Limit Legend (characters) in a Bar chart using Macro

Tue, 22 Oct 2013 14:43:27 GMT

Found out the answer, need to use the API MaxStringLength to limit the number of characters in a chart.

Re: Limit Legend (characters) in a Bar chart using Macro

Thu, 25 Sep 2014 20:42:48 GMT

Hi,

Could you please share the code that worked for you? I'm working on something similar (displaying the legend, on/off).

thanks!