Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
Is there a way to hide and show expressions in qlikview?
Regards,
Sab
expression_> check enable or uncheck enable
or
in straight table go to presentation-> seleect expression-> hide column
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
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
Hi Anand,
I have re-posted the question
Regards,
Sab