topic Only selection in list box in QlikView

Only selection in list box

sergio0592 — Wed, 25 Nov 2020 16:16:04 GMT

Hi all,

I can't remember how to allow for user to select only one item in a selection list.

Regards

Re: Only selection in list box

Anil_Babu_Samineni — Tue, 25 Apr 2017 07:42:38 GMT

Are you talking about Always One Selected Value

Re: Only selection in list box

avinashelite — Tue, 25 Apr 2017 07:49:10 GMT

Try like this

*Make a selection in the List box

*Properties >General > Always one selected value

NOTE: If you are using expression in list box this doesn't work

Re: Only selection in list box

sergio0592 — Tue, 25 Apr 2017 07:50:50 GMT

Always one selected value don't allows selection of more than one item. Ok, it was my goal, but i'd like to get not always a selected value.

Re: Only selection in list box

Anonymous — Tue, 25 Apr 2017 07:55:09 GMT

Do you mean, Clear all should clear the selection of the list box??

Re: Only selection in list box

sergio0592 — Tue, 25 Apr 2017 07:58:54 GMT

I'd like the following things :

-user can't select more than one item

-user can select no item

Re: Only selection in list box

Anonymous — Tue, 25 Apr 2017 08:11:49 GMT

Am not sure if its possible As a work around,

Add a trigger in the Document properties for field selection - > select in field, if getselectedcount()>1 then choose some value from the selections.

Re: Only selection in list box

rahulpawarb — Tue, 25 Apr 2017 09:08:02 GMT

Hello Jean-Baptiste RENAULT,

Trust that you are doing well!

As a workaround, you can follow below steps:

1. Open Triggers tab of Document Properties (Settings Menu -> Document Properties -> Triggers Tab).

2. Add an event on OnSelect event (Field Event Triggers Section -> On Select - Add Actions)

Press Add button, select Action Type as Selection & Action as Select in Field. Enter Field Name and Search String as below:

Field Name: Category

Search String: =If(GetSelectedCount(Category), MaxString(Category))

Field Name: Year

Search String: =If(GetSelectedCount(Year), Max(Year))

Hope this will be of help.

Regards!

Rahul

Re: Only selection in list box

chhavi376 — Tue, 25 Apr 2017 09:24:15 GMT

Hi Jean,

You can add a trigger(On OnSelect/OnChange) on the field you want to be always one value selected:

=If(GetSelectedCount(FieldName)=0,MaxString({$1}FieldName),'('&Concat(FieldName,'|')&')').

(This expression would make sure that always one value is selected, and multiple values can also be selected)

=If(GetSelectedCount(FieldName)=1,FieldName,MaxString({$1}FieldName)).

(This would make sure that one and only one value is selected)

This should cater to your requirement.

Make sure that always one selected value is disabled.

Thanks,

Chhavi