topic Multi-Box Expression in QlikView

Multi-Box Expression

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hello,

I am trying to write an expression in a multi-box to only include certain products in the product drop-down.

Write now I have:

=Product='RRMD' or Product ='RZT'

This works, but instead of the text showing up, the product drop-down only shows 0 and -1. How can I get this to show the text values in the drop-down?

Re: Multi-Box Expression

datanibbler — Thu, 07 Jun 2018 12:41:06 GMT

Hi,

well, 0 and -1 are the boolean values for FALSE and TRUE, respectively. Just change your expression to

>>> = IF((Product='RRMD' OR Product='RZT'), Product) <<<

HTH

Best regards,

DataNibbler

Re: Multi-Box Expression

Anonymous — Thu, 07 Jun 2018 12:42:09 GMT

I solved it by making it an if statement.

=if(Product='RRMD' or Product='RZT'),Product)

Re: Multi-Box Expression

Anonymous — Thu, 07 Jun 2018 12:42:31 GMT

Thank you!