Conditional show of expressions in QV10

[#1]

Dear All,

I have to show and hide expression in a straight table,based on the user selection from a list box. In Qv11 we have option for that. Bt is there in any possible to achieve the samein Qv10?

Thanks in Advance..

[tresesco]

Unfortunately Not. However, alternate solution could be using multiple similar charts with conditional appearance.

[jagan]

Hi Reena,

You can try using Macro

Sub ShowHideExpression()

  set chartObj = ActiveDocument.GetSheetObject("CH01")

  set chartProp= chartObj.GetProperties

  set expr = chartProp.Expressions.Item(1).Item(0).Data.ExpressionData

  expr.Enable = False // Hides First expression

  set expr = chartProp.Expressions.Item(2).Item(0).Data.ExpressionData

  expr.Enable = True // Displays Second expression

End Sub

Regards,

Jagan.

[#4 · Accepted solution]

Hi,

I found the solution..since it is a straight table.it has conditional option available in Presentation Tab.

Thanks