topic Require a Minimum of one value selected in a list Box in QlikView

Require a Minimum of one value selected in a list Box

Wed, 07 Jul 2010 22:43:57 GMT

I have an application which has many list boxes for selecting values. One of the list boxes has 100+ entries. If a user does not select at least one value from this list and at least one YEAR the server bogs down for all apps. The database has millions of rows with many fields and values. The General Tab for List Box Properties has a check box for requiring one value to be selected but only one value. I need the ability to require AT LEAST one value, but to have the option of selecting two or more selections.

Any suggestions?

Require a Minimum of one value selected in a list Box

matt_crowther — Wed, 07 Jul 2010 23:05:48 GMT

Under the list box properties look under the Presentation tab (I think) there's a check box 'Always One Value Selected' - check it and even after a 'clear' one value will remain. Hope that helps. Matt

Require a Minimum of one value selected in a list Box

matt_crowther — Wed, 07 Jul 2010 23:07:57 GMT

Apologies: I should have read the post twice - you've already tried that. Apologies- Matt

Require a Minimum of one value selected in a list Box

Wed, 07 Jul 2010 23:13:16 GMT

In the document properties, set an "On Open" action of "Select in Field" that pre-selects a value from the list field (lets call it BigList), i usually find either

=max(Biglist)

=min(BigList) works fine

On all your other objects within the document set a "caluclation condition" of

GetSelectedCount(Year)>0 and GetSelectedCount(BigList)>0

and that object wont even attempt to calculate until something is elected in either field

Require a Minimum of one value selected in a list Box

johnw — Wed, 07 Jul 2010 23:46:39 GMT

You could do it with a macro OnSelect and OnChange of the field:

sub AtLeastOne()
set field = ActiveDocument.GetField("ID")
if field.GetSelectedValues.Count < 1 then
field.select ActiveDocument.Evaluate("=minstring(ID)")
end if
end sub

Better if there's a way to do it with an action, but I'm not thinking of how. Not very experienced with actions yet.

Require a Minimum of one value selected in a list Box

rwunderlich — Fri, 09 Jul 2010 00:23:26 GMT

The approach I usually take is to place a calulation condition on the objects that are slow if the selections are not made. Then set a custom message that informs the user "Please select at least one Year and a value".

-Rob