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

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

Anonymous — Thu, 21 May 2015 16:35:45 GMT

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

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

petter — Thu, 21 May 2015 16:38:17 GMT

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

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

Gabriel — Thu, 21 May 2015 16:38:51 GMT

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

sunny_talwar — Thu, 21 May 2015 16:38:51 GMT

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

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

Anonymous — Thu, 21 May 2015 16:39:34 GMT

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.

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

Gysbert_Wassenaar — Thu, 21 May 2015 16:45:01 GMT

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.