topic Macro code to set conditional show formula in QlikView

Macro code to set conditional show formula

Mon, 26 Sep 2011 18:36:35 GMT

Can anyone help with a bit of code to set the formula for conditional show for a textbox?

Macro code to set conditional show formula

jonathandienst — Mon, 26 Sep 2011 20:40:32 GMT

You don't need macro code to conditionally display a text box. Simply enter an expression that tests the criteria for displaying the text box into the Properties | Layout | Show Conditional box.

I cannot help with the expression as you have not described any of the display criteria.

Hope that helps

Jonathan

Macro code to set conditional show formula

Mon, 26 Sep 2011 21:19:34 GMT

Thanks for the reply. I needed the code because I had >100 text objects that needed the same conditional display expression. QV doesn't let you set that for multiple object selections.

I found the answer:

prop = obj.GetProperties

prop.Layout.Frame.Show.Always = False

prop.Layout.Frame.Show.Expression.v = "expression"

obj.SetProperties prop