topic how to set default selection in list box? in QlikView

how to set default selection in list box?

Anonymous — Tue, 28 Oct 2014 08:47:40 GMT

Hi..

Can any one help me how to set default selection in listbox..

Thaks.

Re: how to set default selection in list box?

vardhancse — Tue, 28 Oct 2014 08:49:43 GMT

Select the value in list box-.

list box properties->General->Always one selected value(Check box)

Re: how to set default selection in list box?

ali_hijazi — Tue, 28 Oct 2014 08:52:33 GMT

or you can add an action to the on activate sheet trigger to select in field;

you select your field and the desired value

if you want to select more than one value you have to put '(' & value1 & '|' & value2 &... & ')'

Re: how to set default selection in list box?

its_anandrjs — Tue, 28 Oct 2014 08:54:04 GMT

For doing this follow steps

1. Select any value in the list box.

2. Then go to properties and select General >> Always One value selected.

Regards

Aannd

Re: how to set default selection in list box?

Anonymous — Tue, 28 Oct 2014 08:55:18 GMT

Hi sasi..

Thanks for your reply..

Its working fine in list box .how we set same property in multibox.

Thanks.

Re: how to set default selection in list box?

salto — Tue, 28 Oct 2014 08:56:38 GMT

Hi,

Do the next: right clik on that sheet and go to trigger tab.

Then, add action on ActiveSheet, click -->Add-->selection-->select in field

then select the fields above and in search string write the values of the fields.

(From Setting default values in List box)

Hope this helps.

Re: how to set default selection in list box?

Anonymous — Tue, 28 Oct 2014 08:58:35 GMT

Hi..

Can you give me example ..

Thanks.

Re: how to set default selection in list box?

vardhancse — Tue, 28 Oct 2014 09:01:38 GMT

Multibox->Properties->Presentation-

Select the field.

Always one selected Value(Check box)

Hope this help you out.

If yes, please mark as correct and close the thread.

Re: how to set default selection in list box?

ali_hijazi — Tue, 28 Oct 2014 09:03:24 GMT

ok right-click on the sheet and go to trigger tab

click AddAction on the OnActivateSheet Trigger then click on Add Action button

select the SELECTION action type and then select select in field

write down your field name suppose it is F1 then in the search string write down the desired values as such

='(' & value1 & '|' & value2 &')'

then click add action again and write down your second desired field and write the desired values to select by default

Re: how to set default selection in list box?

alkesh_sharma — Tue, 28 Oct 2014 09:06:20 GMT

Put a trigger for 'section field' Pass the field name and the value you want it to be selected.

This trigger can be added to the sheet or you can add it to the whole document.

Re: Re: how to set default selection in list box?

salto — Tue, 28 Oct 2014 09:06:24 GMT

Hi,

ItemA and ItemC are the default selections for this Listbox, via a trigger. The event is on the document opening but can be changed to any other event.

Hth.

Re: how to set default selection in list box?

Anonymous — Tue, 28 Oct 2014 11:56:07 GMT

Hi..

Thanks for your reply..

What is my exact need is when ever i open the sheet defaultly it has some selection after that it will apllicapable user selections means if we set the field trigger it will applicable in static way but i want to change selections of listbox and multibox after default selections..

Thanks,

Re: how to set default selection in list box?

alkesh_sharma — Tue, 28 Oct 2014 12:04:35 GMT

No, Trigger on document opening will work the same way as you require.

YOu will get default selections as per r trigger and than the user can change them as per his requirement