Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Check if value is in a listbox

Hi!

I have a ListBox with values:

value1

value2

value3

....

I have a chart with many expression:

exp1 is show when value1 is cheked

exp2 is show when value2 is cheked

exp2 is show when value3 is cheked

everything works when I have only 1 value checked in the listbox, but when there is more then 1 value checked the chart is empty.

I would like that if I check value1 and value2, exp1 and exp2 are shown

as Conditional expression (for expX) I use

- ListBox='valueX'

- =if(match(GetFieldSelections(ListBox),'valueX'),1,0)

- =count({<ListBox = {'ValueX'}>}  valueX)

but all of them give me the same problem....

Some Idea?

1 Solution

Accepted Solutions
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

Try =if(maxstring({<ListBox*={'ValueX'}>}ListBox)='ValueX',1,0)


talk is cheap, supply exceeds demand

View solution in original post

2 Replies
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

Try =if(maxstring({<ListBox*={'ValueX'}>}ListBox)='ValueX',1,0)


talk is cheap, supply exceeds demand
Not applicable
Author

Perfect! thank u very much!