Discussion board where members can get started with QlikView.
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?
Go to Solution.
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) <<<
View solution in original post
I solved it by making it an if statement.
=if(Product='RRMD' or Product='RZT'),Product)