topic Reference ListBox Show.Always/Show.Condition property in VB Macro. in QlikView

Reference ListBox Show.Always/Show.Condition property in VB Macro.

Tue, 09 Nov 2010 23:22:42 GMT

Hello,

I am using a macro, I want to be able to make a listbox visible and invisible:

How do I reference(and set)

Show.Always
Show.Condition

for a Listbox ?

Thank in Advance !

Tim

Reference ListBox Show.Always/Show.Condition property in VB Macro.

deepakk — Wed, 10 Nov 2010 10:22:56 GMT

check out this forum...

http://community.qlik.com/forums/t/36579.aspx

Reference ListBox Show.Always/Show.Condition property in VB Macro.

Wed, 10 Nov 2010 15:17:26 GMT

That worked for me, thanks Deepak!

(I would still like to know how to reference those properties directly though)

SV:Re: Reference ListBox Show.Always/Show.Condition property in VB Macro.

gandalfgray — Wed, 10 Nov 2010 16:08:18 GMT

You can do it like this:


sub setlb01
set LB = ActiveDocument.GetSheetObject("LB01")
set boxprop=LB.GetProperties
boxprop.Layout.Frame.Show.Always = false
boxprop.Layout.Frame.Show.Expression.v = "sum(Sales)>4000"
LB.SetProperties boxprop
end sub

SV:Re: Reference ListBox Show.Always/Show.Condition property in VB Macro.

Fri, 12 Nov 2010 22:15:39 GMT

Thank You

SV:Re: Reference ListBox Show.Always/Show.Condition property in VB Macro.

Mon, 13 Dec 2010 15:41:42 GMT

That worked for me too! A great way to control the show condition via macro.