topic Re: List Box and Always One Selected Value in QlikView

List Box and Always One Selected Value

Joaquin_Lazaro — Tue, 25 Feb 2014 12:02:25 GMT

Hello:

I've a ListBox that shows one expression (FieldA & ' - ' & FieldB), I want to check "Always One Selected Value" but is disabled all the time.

I've selected one value, saved the document and open again, before open the ListBox properties dialog, and trying other possibilities like create the LB with a field and select one value ... then check the "Always One Selected Value" item and save the document and open again to convert the LB to show the expressión.

Always I've tried with one value selected.

Ara there any trick to enable this checkbox?

Thank you

Joaquín

Re: List Box and Always One Selected Value

maxgro — Tue, 25 Feb 2014 12:10:41 GMT

from online help

Checking this option assures that one value will always be selected, which is useful in documents where the data only makes sense when one value is already selected, such as one currency rate. This option is enabled after one value is already selected in the list box. This option is not available for calculated fields.

Re: List Box and Always One Selected Value

rustyfishbones — Tue, 25 Feb 2014 12:11:24 GMT

Hi,

I am not sure this is possible.

Have you tried concatenating both fields in the Script and then creating a list box with the new field

So it would be

FieldA & ' - ' & FieldB AS FieldAB,

Re: List Box and Always One Selected Value

manojkulkarni — Tue, 25 Feb 2014 12:12:22 GMT

List box with "Always one selected" option is enabled when you have single field selected from available fields dropdown. It is not available for expressions.

Re: List Box and Always One Selected Value

maxgro — Tue, 25 Feb 2014 12:15:39 GMT

I think it should work as FieldAB is not a calculated field at the user interface level

Re: List Box and Always One Selected Value

manojkulkarni — Tue, 25 Feb 2014 12:15:55 GMT

As mentioned by RustyFishBones, concatenating at script level will work. Finally you will be selecting a single field in LB

Re: List Box and Always One Selected Value

Joaquin_Lazaro — Tue, 25 Feb 2014 12:24:13 GMT

Thank you for your help

Re: List Box and Always One Selected Value

Joaquin_Lazaro — Tue, 25 Feb 2014 12:25:49 GMT

Thank you Alan

Re: List Box and Always One Selected Value

Thu, 16 Oct 2014 07:31:43 GMT

Is there any way we can enable always one selected option for calculated fields in list box?

Thanks in advance!

Re: List Box and Always One Selected Value

Joaquin_Lazaro — Fri, 17 Oct 2014 06:44:08 GMT

Hi aanshi61

Try what told us RustyFishBones, it's marked as correct answer; at least for me it worked.

Good luck

Joaquín