topic create scatter chart through macro in QlikView

create scatter chart through macro

Tue, 13 Dec 2011 15:32:53 GMT

hi all,

How can we create an new scatter chart in macro by providing Dimensions and Expressions ?

In my current app's i provided two Buttons, first button when i click that it should create a new sheet and in that new sheet scatter chart should create.

And when second button i click then it should delete the recently created scatter chart object and sheet.

Is it possible ?

Thanks in advance.

Regards

Venkat

create scatter chart through macro

m_woolf — Tue, 13 Dec 2011 15:47:24 GMT

This is one of eighteen sample scripts from the API Guide:

set chart = ActiveDocument.Activesheet.CreateScatterChart

chart.AddDimension "Customer"

chart.AddDimension "ProductType"

chart.AddExpression "avg(Amount)"

chart.AddExpression "avg(Price)"

cset col = ActiveDocument.GetApplication.GetSolidColorArea(255,0,0) 'red

chart.AddFractLine 0,0,col

set p = chart.GetProperties

set rl = p.ChartProperties.RefLines.Item(0)

rl.Fractile = true

rl.FractileLevel = 50

rl.Legend.v = "median"

rl.Color.PrimaryCol.Col = RGB(255,0,0)

rl.XAxis = true

rl.YAxis = true

chart.SetProperties p

Re: create scatter chart through macro

Wed, 14 Dec 2011 07:15:09 GMT

Hi,

when i used your macro i is showing an error Type Mismatch in below line.

cset col = ActiveDocument.GetApplication.GetSolidColorArea(255,0,0)

what i need to change in the above line not get the Type Mismatch error ?

Thanks in advance

Regards

venkat

Re: create scatter chart through macro

m_woolf — Wed, 14 Dec 2011 11:56:34 GMT

cset should just be set

You should look at the other 17 sample scripts in the API Guide.