topic Re: multiple Conditional in QlikView

multiple Conditional

Tue, 09 Sep 2014 21:32:37 GMT

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.

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

ecolomer — Tue, 09 Sep 2014 21:54:02 GMT

Can you upload an especific example, please

Tue, 09 Sep 2014 22:46:24 GMT

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 — Tue, 09 Sep 2014 23:38:49 GMT

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

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

Kind Regards

Daniel

Wed, 24 Sep 2014 17:45:41 GMT

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