Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

geminihzh
Valued Contributor

"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
Valued Contributor III

Re: "Show Alternatives" in list box not available

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

geminihzh
Valued Contributor

Re: "Show Alternatives" in list box not available

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.

Re: "Show Alternatives" in list box not available

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

geminihzh
Valued Contributor

Re: "Show Alternatives" in list box not available

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


Re: "Show Alternatives" in list box not available

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

geminihzh
Valued Contributor

Re: "Show Alternatives" in list box not available

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

Re: "Show Alternatives" in list box not available

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

geminihzh
Valued Contributor

Re: "Show Alternatives" in list box not available

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

Zhihong 

MVP
MVP

Re: "Show Alternatives" in list box not available

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
Community Browser