Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

shubham_kumar
Contributor III

Not equal to for normal expression

Hi,

Could you please let me know, how to make this as not equal to for the same expression.

 

=

if(Business_Source_Name='R' or Business_Source_Name='M' or Business_Source_Name='D"or Business_Source_Name='C',Business_Source_Name

)

This give me correct only based on the given list but if I want to not take all those except all then how to take?

Need help.

Best Regards,

Skumar

1 Solution

Accepted Solutions
MVP
MVP

Re: Not equal to for normal expression

Try

=if( not match(Business_Source_Name,'R','M','D','C'), Business_Source_Name)

3 Replies
MVP
MVP

Re: Not equal to for normal expression

Try

=if( not match(Business_Source_Name,'R','M','D','C'), Business_Source_Name)

shubham_kumar
Contributor III

Re: Not equal to for normal expression

Excellent !!It works. Thanks a ton

Not applicable

Re: Not equal to for normal expression

/= works well for not equal to

if(Business_Source_Name/='R' or Business_Source_Name/='M' or Business_Source_Name/='D"or Business_Source_Name/='C',Business_Source_Name

)

Community Browser