Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

nsnybs21qv
New Contributor III

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

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

Tags (1)
1 Solution

Accepted Solutions
mov
Esteemed Contributor III

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

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.

View solution in original post

5 Replies
MVP
MVP

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

‌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.

Partner
Partner

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

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.


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

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

mov
Esteemed Contributor III

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

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.

View solution in original post

MVP & Luminary
MVP & Luminary

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

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.


talk is cheap, supply exceeds demand