topic Re: Automatic Select in List Box in QlikView

Automatic Select in List Box

Anonymous — Thu, 24 Oct 2013 00:06:12 GMT

Hello! How can I automatic select a record from a field in my list box... I tried setting the sheet properties , then triggers and on select but it doesn't allow me to unselect and select a different record.

For Example :

Phones (field):

Apple

HTC

Samsung

In my example above, I just want to automatic select "Apple" the first thing I open the file but it will allow me to unselect and select another phones like SAMSUNG. Is this possible?

Re: Automatic Select in List Box

Thu, 24 Oct 2013 03:49:08 GMT

Select 'Apple' ,go to listbox properties & tick 'Always one selected value'.

Save and close the document.

Re: Automatic Select in List Box

tresB — Thu, 24 Oct 2013 04:22:54 GMT

Use 'OnOpen' event like attached sample.

Re: Automatic Select in List Box

sushil353 — Thu, 24 Oct 2013 04:28:45 GMT

Hi,

Try to setup a trigger in document property>Triggers>Document Event Triggers>OnOpen>Select in field

Specify your field name and search string.

HTH

Sushil

Re: Automatic Select in List Box

Anonymous — Thu, 24 Oct 2013 20:38:29 GMT

Thanks you, guys for the helpful advise.. all suggestions allows me to select and unselect but it does not allow me to clear all my selections.

Re: Automatic Select in List Box

Thu, 24 Oct 2013 20:48:08 GMT

create the OnOpen trigger as specified above but make sure 'Always one selected value' is *not* ticked

Re: Automatic Select in List Box

rustyfishbones — Thu, 24 Oct 2013 21:39:01 GMT

Create the open trigger and add an external action and choose run macro = SelectRandom

Sub SelectRandom

val = ActiveDocument.Evaluate("FieldValue('Phones', ceil(" & Rnd() _

& " * FieldValueCount('Phones')))")

ActiveDocument.Fields("Phones").Select val

End Sub

This means when the document opens each time it will randomly select a value from the field Phones

Re: Automatic Select in List Box

Anonymous — Fri, 25 Oct 2013 16:45:59 GMT

Kai,

I got it...This is what I exactly wanted.

Tks.