topic list box - how to force to choose only one value in QlikView

list box - how to force to choose only one value

Thu, 02 Jul 2009 18:10:51 GMT

Hello,

I have a list box with a set of values, and I want to force the user to choose only one at a time, not as many as he wants, how can I do this?

Thanks

Alexandra

list box - how to force to choose only one value

amars — Thu, 02 Jul 2009 18:26:42 GMT

Hi alexandra,

Select a value in the list box & then go in Properties - > General Tab , there is a property "AtLeast one selected value" check that, which will force user to select at least one value at a time.

Regards

Amar

list box - how to force to choose only one value

Thu, 02 Jul 2009 19:46:19 GMT

Thank you for your reply Amar, but I don't want to force the user to select at least one value, he can choose no value at all, I just don't want him to choose more than one. And that option is greyed out...

Thanks

list box - how to force to choose only one value

andrus — Thu, 02 Jul 2009 19:51:54 GMT

This Box is selectible if you have selected only one value from the list.

list box - how to force to choose only one value

Thu, 02 Jul 2009 20:03:31 GMT

Hi andrus,

See, I have only one value selected from the list and still the option is greyed out...

list box - how to force to choose only one value

andrus — Thu, 02 Jul 2009 20:18:06 GMT

Hi,

Seems, that parameter doesn't work for expressions, but only for "regular" fields:-(

list box - how to force to choose only one value

Thu, 02 Jul 2009 20:41:03 GMT

Oh.... that's probably it... I'm not sure I can do it without being an expression though...

Thanks for your help

list box - how to force to choose only one value

andrus — Thu, 02 Jul 2009 20:46:58 GMT

Hi!

But maybe you can add this expression into your loading script.

list box - how to force to choose only one value

Anonymous — Thu, 02 Jul 2009 23:31:09 GMT

You cannot use "Always One..." in a calculated list box, but you can apply it to the underlying field, the one that you use in the expression.

list box - how to force to choose only one value

johnw — Fri, 03 Jul 2009 03:01:49 GMT

So you want either 0 or 1 value to be selected, but never more than one? Here's an example of using a macro to do it. If more than one value is selected, it immediately deselects all but the first selected value. There might be a better way than using a macro, and for this specific case, there's probably a simpler macro (this was adapted from a macro to allow 1 to 5 values to be selected).

list box - how to force to choose only one value

Fri, 03 Jul 2009 03:21:42 GMT

If you're using QlikView 9, it can be done with an Action. I still haven't decided if Actions are inherently easier than Macros.

On your field, set up an OnSelect Action. Choose Select in a Field. Choose your Field. And for the Select, use:

=SubField(GetFieldSelections(Field), ',', 1)

You could modify the Subfield function to choose a value other than the first. Replace the 1 with GetSelectedCount(Field) and you should get the last item selected.

list box - how to force to choose only one value

Fri, 31 Jul 2009 00:30:29 GMT

Hi nMiller,

I searched the Community and found your excellent solution to prevent users from selecting more than one single value from a listbox. It helped me a lot but I have (at least) one more issue to deal with: The field to be restricted exists on several other sheets but the restriction should just be valid for one singe sheet. I haved tried the following expression (the fieldname is "Make"):

=If(GetActiveSheetID()='Document\SH02',SubField(GetFieldSelections(Make), ',', 1),GetFieldSelections(Make))

But it only works on sheet SH02. On all other sheets, more than one selected value (which should be allowed) returns NULL.

I hope that you - or some other QV-Guru - can give me a good advise how to do!

list box - how to force to choose only one value

Fri, 31 Jul 2009 01:48:44 GMT

Okay, let me make sure I have this straight. On one sheet, you only want the user to be able to select one value (or none), but any other sheet, they can select multiple. What happens if the user selects multiple and then goes back to look at the Select One sheet?

One option may be to load the field in twice. One name it field_name and the other field_name_select1. On your Select One sheet, add field_name_select1 with the one select trigger. Then on your other sheets, use the normal one. In this case, multiple selections made on another sheet will affect the Select One sheet.

If you don't want multiple selections on the other sheets to affect the Select One sheet, then you'd probably need two separate datasets.

list box - how to force to choose only one value

Fri, 31 Jul 2009 02:16:22 GMT

Thanks for quick response. I think i'll load the field twice. I've done so in similar situations.

But - seen from a newbee's horizon - I thought that the "Else" option in my If-statement was a great idea! 😉

list box - how to force to choose only one value

Fri, 31 Jul 2009 02:55:43 GMT

Once you said that the expression didn't work, I kind of ignored it. I believe the problem is that GetFieldSelections returns a comma-separated list, but QlikView will not Select all values in a comma-separated list (it doesn't work using .Select in a macro either). It was a good idea, I wish it did work like that. Instead, we have to use ToggleSelect to select additional values (ToggleSelect is like keep the current selection and select).

I wonder if there is a way to handle this in a Trigger without double loading the field. I think it would be pretty easy in a macro, because you could do the conditional before doing the select.

list box - how to force to choose only one value

Mon, 08 Aug 2011 14:27:25 GMT

Do you have the exact solution for this?

Re: list box - how to force to choose only one value

sanjeeva_279 — Tue, 24 Sep 2019 23:54:32 GMT

hi soltuons works fine without ctrl+shift button at a time,

but if we select ctrl+shift button and all the values it select more then one value