Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
Highlighted
cole3481
New Contributor III

Multi-Box Expression

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?

1 Solution

Accepted Solutions
datanibbler
Esteemed Contributor

Re: Multi-Box Expression

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

View solution in original post

3 Replies
datanibbler
Esteemed Contributor

Re: Multi-Box Expression

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

View solution in original post

cole3481
New Contributor III

Re: Multi-Box Expression

I solved it by making it an if statement.

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

cole3481
New Contributor III

Re: Multi-Box Expression

Thank you!