topic Re: Not equal to for normal expression in QlikView

Not equal to for normal expression

Anonymous — Wed, 08 Aug 2012 13:05:13 GMT

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

swuehl — Wed, 08 Aug 2012 13:11:55 GMT

Try

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

Anonymous — Thu, 09 Aug 2012 04:49:36 GMT

Excellent !!It works. Thanks a ton

Thu, 24 Jan 2013 09:21:35 GMT

/= 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

)