Discussion board where members can get started with QlikView.
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?
Go to Solution.
=if( not match(Business_Source_Name,'R','M','D','C'), Business_Source_Name)
Excellent !!It works. Thanks a ton
/= 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