Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
JoaquinLazaro
Partner - Specialist II
Partner - Specialist II

List Box and Always One Selected Value

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

1 Solution

Accepted Solutions
rustyfishbones
Master II
Master II

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,

View solution in original post

9 Replies
maxgro
MVP
MVP

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.

rustyfishbones
Master II
Master II

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,

manojkulkarni
Partner - Specialist II
Partner - Specialist II

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.

maxgro
MVP
MVP

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

manojkulkarni
Partner - Specialist II
Partner - Specialist II

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

JoaquinLazaro
Partner - Specialist II
Partner - Specialist II
Author

Thank you for your help

JoaquinLazaro
Partner - Specialist II
Partner - Specialist II
Author

Thank you Alan

Not applicable

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

Thanks in advance!

JoaquinLazaro
Partner - Specialist II
Partner - Specialist II
Author

Hi aanshi61

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

Good luck

Joaquín