Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

Disable expression by a macro

Can a expression be disable with a macro???

Tags (1)
1 Reply
spsrk_84
Contributor III

Disable expression by a macro

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

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