Disable expression by a macro

Mon, 26 Apr 2010 08:45:08 GMT

Can a expression be disable with a macro???

Disable expression by a macro

spsrk_84 — Mon, 26 Apr 2010 10:40:30 GMT

Hi,

Yes expression can be disabled through macro.

I found this example in the API Guide.Qvw file.

Just go through the sample

//////////////////////////////////////////////////////// Below is the Sample Code which will create a straight table and disable's the first expression//////////////////////////

Set chart=Activedocument.activesheet.createStraightTable

Chart.AddDimension "Customer'

Chart.AddDimension "ProductType"

Chart.AddExpression "Sum(Amount)"

Chart.AddExpression "Count(Customer)'

Set Cp=Chart.GetProperties

Set Expr=Cp.Expressions.item(0).Item(0).Data.ExpressionData

Expr.Enable=False

Chart.Set Properties Cp

//////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////

topic Disable expression by a macro in QlikView

Disable expression by a macro

Disable expression by a macro