Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

"Show Alternatives" in list box not available

Hi, all,

I had a problem to display the list box object. I do not want the un-selected value be gray, And seems  the "Show Alternatives" can help. But in my list this option is gray. May I know how to make it available again?

Thanks

9 Replies
jpenuliar
Partner - Specialist III
Partner - Specialist III

Open List box Property>> General>> tick/untick Show Alternatives

Anonymous
Not applicable
Author

Hi, Jonathan,

Thanks for your reply. As I mentioned, the "Show Alternatives" in the property of that list box object is grey, and I can not tick/untick it.

alexandros17
Partner - Champion III
Partner - Champion III

Show Alternative checkbox is greyed if you have used an expression.

Let me know if you have used it, if this, ypou should compute the expression in the script as a new field and then use that new field in the list box

Hope it helps

Anonymous
Not applicable
Author

@Alessandro, you caught the point. Yes, I use Expression. But the filed is a conditional show Filed, and expression is needed.  Otherwise, 7 more list box objects need to be created to display each Filed. And I do not think that is a good idea.


alexandros17
Partner - Champion III
Partner - Champion III

Please Send me the conditional expression to better understand it ...

Anonymous
Not applicable
Author

Hi, Alessandro,

Thanks for your patience.

The expression I use is:

if(_state='OV'

or _state='ST'

or _state='RE'

or _state='SI'

or _state='CR'

or _state='CO',

or _state='AD', $(_tableMetricFiled), 'EROOR:NON-EXIST TAB')

And the _state variable  can be changed in the dash when user click on different buttons.  That is why I need to keep this in the expression.

Zhihong

alexandros17
Partner - Champion III
Partner - Champion III

yes, i UNDERSTAND, I think there isn't a easy solution ....

Anonymous
Not applicable
Author

Is there any other setting to define the font color of the selected and unselected item in the list box?

Zhihong 

jonathandienst
Partner - Champion III
Partner - Champion III

There is no way to control the colours in a list box, other than what you already tried. Is it possible to create new field in the load script with these values?

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein