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

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

multiple Conditional

10-09-14: Added an ex. file

!


Hi all

I'm having an issue with some conditionals I want to use in objects

I have a list box with multiple values, which should be used for the conditional.

ex.

1

2

3

4

5

I want the object to be shown if,

a. ex. 1 is selected (this is not a problem)

But I also want it to be shown if

b. ex. 1 is selected and one or more of the other values are selected. ex. selected 1 & 3 & 4 or  selected 1 & 2 (And this I can't get to Work)

I know I can get it to Work if I state all the combinations, but can I do it without doing that.

Hope someone can help

Thanks

Message was edited by: Niels Juel

1 Solution

Accepted Solutions
danieloberbilli
Specialist II
Specialist II

In objects properties, layout tab -> show conditional use the following expression:

GetSelectedCount(Value)>0 and wildmatch(GetFieldSelections(Value),'*1*')

Kind Regards

Daniel

View solution in original post

4 Replies
ecolomer
Master II
Master II

Can you upload an especific example, please

Not applicable
Author

Hi,

I'm not sure undersatand but if you want do it something when just ONE value of your list box is selected.... try something like this:

IF(GetSelectedCount(MyFieldInTheListBox)=1, expression1)

However if you can add an example it will be great.

Best regards.

danieloberbilli
Specialist II
Specialist II

In objects properties, layout tab -> show conditional use the following expression:

GetSelectedCount(Value)>0 and wildmatch(GetFieldSelections(Value),'*1*')

Kind Regards

Daniel

Not applicable
Author

Hi Daniel

Thanks, it works

Had found this too, a little of the same

GetselectedCount(Value)>0 and Wildmatch(Concat(Value,'/'),'*FieldVal*')

and it also worked fine

Regards

NJ