topic How to enable and disable expression of chart by code(macro)? in QlikView https://community.qlik.com/t5/QlikView/How-to-enable-and-disable-expression-of-chart-by-code-macro/m-p/156538#M32377 <HTML><HEAD></HEAD><BODY><P>I have understood your demo. And I add your code in to my qvw file, It works!</P><P>Thank you very much !</P></BODY></HTML> Thu, 06 Jan 2011 05:31:34 GMT 2011-01-06T05:31:34Z How to enable and disable expression of chart by code(macro)? https://community.qlik.com/t5/QlikView/How-to-enable-and-disable-expression-of-chart-by-code-macro/m-p/156536#M32375 <HTML><HEAD></HEAD><BODY><P>hi, I have a bar chart with 3 expessions(expression: A B C). I want to use macro to control enable and disable expression. How can I do this?</P><P>I want to use a button. when click shows expression A and B, when click another time shows expression B and C.</P><P>thanks a lot !</P><P></P></BODY></HTML> Thu, 06 Jan 2011 03:09:33 GMT https://community.qlik.com/t5/QlikView/How-to-enable-and-disable-expression-of-chart-by-code-macro/m-p/156536#M32375 2011-01-06T03:09:33Z How to enable and disable expression of chart by code(macro)? https://community.qlik.com/t5/QlikView/How-to-enable-and-disable-expression-of-chart-by-code-macro/m-p/156537#M32376 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I have attached the appliocation as per ur requirment.</P><P>first create a variable in ur application as VClikCount</P><P>then paste the macro and assign to button</P><P>sub ends<BR />set myobj = ActiveDocument.GetSheetObject("CH01")<BR />set v = ActiveDocument.GetVariable("VClikCount") '' first create a varible using setting<BR />Cnt= v.getcontent.String<BR />prop = myobj.GetProperties<BR />if Cnt=0 then<BR /> set expr = prop.Expressions.Item(0).Item(0).Data.ExpressionData<BR /> expr.Enable = true 'enable first expression<BR /> set expr1 = prop.Expressions.Item(1).Item(0).Data.ExpressionData<BR /> expr1.Enable = true 'enable second expression<BR /> set expr1 = prop.Expressions.Item(2).Item(0).Data.ExpressionData<BR /> expr1.Enable = false 'disable second expression<BR /> v.setContent "1",true<BR />else<BR /> set expr = prop.Expressions.Item(0).Item(0).Data.ExpressionData<BR /> expr.Enable = false 'disable first expression<BR /> set expr1 = prop.Expressions.Item(1).Item(0).Data.ExpressionData<BR /> expr1.Enable = true 'enable second expression<BR /> set expr1 = prop.Expressions.Item(2).Item(0).Data.ExpressionData<BR /> expr1.Enable = true 'enable second expression<BR /><BR /> v.setContent "0",true<BR />end if<BR />myobj.SetProperties prop<BR />end sub</P><P></P><P>good luck.</P></BODY></HTML> Thu, 06 Jan 2011 04:24:12 GMT https://community.qlik.com/t5/QlikView/How-to-enable-and-disable-expression-of-chart-by-code-macro/m-p/156537#M32376 maneshkhottcpl 2011-01-06T04:24:12Z How to enable and disable expression of chart by code(macro)? https://community.qlik.com/t5/QlikView/How-to-enable-and-disable-expression-of-chart-by-code-macro/m-p/156538#M32377 <HTML><HEAD></HEAD><BODY><P>I have understood your demo. And I add your code in to my qvw file, It works!</P><P>Thank you very much !</P></BODY></HTML> Thu, 06 Jan 2011 05:31:34 GMT https://community.qlik.com/t5/QlikView/How-to-enable-and-disable-expression-of-chart-by-code-macro/m-p/156538#M32377 2011-01-06T05:31:34Z