topic Conditionally Clear list Box in QlikView

Conditionally Clear list Box

Wed, 23 Sep 2009 20:36:24 GMT

Hi There

I have a basic year and month list boxes, i want to clear the month list box if there is no year selected, how can i do this ?

Thanx

Conditionally Clear list Box

Wed, 23 Sep 2009 20:46:40 GMT

You can create a macro that will fire when there is a change to the Year field. On the Trigger tab under Document Properties, you want to add a macro for the OnChange of the Year field. I'd also set up a variable (vYear) with the formula:

=GetSelectedCount(Year)

For the macro, use something like:

If ActiveDocument.Variables("vYear").GetContent.String>0 Then
ActiveDocument.Fields("Month").Clear
End If

Conditionally Clear list Box

Wed, 23 Sep 2009 21:20:57 GMT

Thanx NMiller and for the opther post as well 🙂