"Always One Selected Value" option is disabled when using expression

[Anonymous]

Hi

I have a dimension Account that has 3 values : Revenue, Expense and ACV. I want to create a list box that only shows Revenue and Expression and I use this expression. "=if(match(Account,'ACV','Revenue'),Account) ". I want to always have one value selected in the list box, but the option seemed to be disabled, even after I select one value in the list box.

Can someone help or find an alternative?

Thanks

Zixiao

[petter]

‌You have to have at least one value selected which will become the default selected value before the option will be selectable. But if you use an expression it might also disable the option.

[Gabriel]

Hi,

You have to make 1 selection first and then go to the list box properties then the 'Always one selected' will be available for selection in the properties.

[sunny_talwar]

You need to select a single value in the list box to activate that option. Once you click on one option from the list box, you can go into the properties and select 'Always One Selected Value'

HTH

Best,

Sunny

[Anonymous · Accepted solution]

Try this - create another list box (OK to hide it) with the field Account, make it "always one ...", and see how your calculated list box works.

[Gysbert_Wassenaar]

The problem is that an expression isn't guaranteed to return only one possible value. That's probably why the option is disabled when you use an expression for the listbox. I think you have to create another field in the load script. Or you could create some buttons or text boxes with Select in Field actions assigned to them.