I am new to QlikView and appreciate any suggestions that can be provided. I am using a multi-box and wanted to eliminate any records/rows base on a column value. I tried going into the properties and put in the below fuction on the Dimensions tab but it does not work. In the below function, I wanted to inlcude the row/record when the Category is 'Non-Equivalent Values' or 'Not in To System' value.
=if(match([Category], 'Non-Equivalent Values', 'Not in To System'), [Category])
![Capture.PNG](/legacyfs/online/37174_Capture.PNG)
Thanks,
Tak