Enable and disable expressions in qlikview

[#1]

Hi,

Is there a way to hide and show expressions in qlikview?

Regards,

Sab

[SunilChauhan]

expression_> check enable or uncheck enable

or

in straight table go to presentation-> seleect expression-> hide column

[its_anandrjs]

Hi,

You are asking about the Expression code or the value which is view on the charts if so you are able Enable or Disable it from chart.

Let me know

Rgds

Anand

[#4]

Hi,

Thanks for the reply.

Apologies my question did not depict the scenario corrrectly.

What I am trying to achieve is as follows,

1.)I have a few variables based on which I want to hide and show expressions in a pivot table.

2.)I am trying to write a macro using which I want to achieve point 1.

So,the macro i am writing looks something this but failing when I am trying to get the value of the variable

Sub ShowVars

varNo = ActiveDocument.GetVariableDescriptions.Count - 1
For i = 0 to varNo    

--This is the part where i m failing

     IF ActiveDocument.GetVariableDescriptions.Item(i) .GetContent.String = "1" THEN

          Chart.SetPixWidth (4), 100

     ELSE

          Chart.SetPixWidth (4), 0

     END IF

Next

End Sub

Thanks for your help in advance.

Regards,

Sab

[#5]

Hi Anand,

I have re-posted the question

Regards,

Sab