topic Set Object ID using Macro in QlikView

Set Object ID using Macro

kaushiknsolanki — Wed, 02 Mar 2011 09:32:17 GMT

HI everyone,

I have written following macro for creating new chart

sub Create_Chart

set Graph = ActiveDocument.Sheets("Main").CreateLineChart
Graph.AddDimension "OrderDate"
Graph.AddExpression "sum({BM1}Total)"

end sub

But i dont know how can i set or change the object id of this chart...

If anyone can help me, that will be a valuable help to me..

Thanks in advance..

Fri, 04 Mar 2011 00:59:12 GMT

Hi,

Add the following to your macro, it should do the trick

Dim gProps

gProps = Graph.GetProperties

gProps.GraphLayout.Frame.ObjectID = "NewChart"

Graph.SetProperties gProps

Thanks

Nick

kaushiknsolanki — Fri, 04 Mar 2011 10:20:25 GMT

Hi NIck,

Thanks for your valuable help..

It worked for me..

Hey NICK i want to ask you one more thing is API guide is available in PDF format... ?

If yes pls let me know the Download link..

Thanks

Fri, 04 Mar 2011 11:39:10 GMT

Hi,

As far as I am aware there is no PDF version of the API Guide. There is a pdf reference that is installed with the SDK but it is not as in depth.

Thanks

Nick

kaushiknsolanki — Fri, 04 Mar 2011 14:22:06 GMT

Thanks NIck for your valuable time and support..