topic Multi Box with a condition in QlikView

Multi Box with a condition

Nourrahmcnean — Mon, 30 Aug 2021 09:43:15 GMT

Hey, I want to exclude Z from in the list of the multibox and show only Items from Type E

I added this expression =if( not Match (Item,'Z') AND Match(Type,"E"), Item)

But it prints an empty list.

Re: Multi Box with a condition

Or — Mon, 30 Aug 2021 10:11:23 GMT

You've got the wrong quotes around the 'E', but otherwise that should work. Keep in mind that using this multibox will apply selections to both the Item and Type field at the same time, not just the item, e.g. selecting 'X' will select Item = X, Type = E.

Re: Multi Box with a condition

Nourrahmcnean — Mon, 30 Aug 2021 10:59:37 GMT

Thank you for the explanation