Discussion board where members can get started with QlikView.
The clause I am using is below
left(Customer_Type,1) <> 5 or
left (Customer_Number,1) <> 'S';
S999981 is still showing up in the Customer_Number field
What am I doing wrong?
May be try like:
NOT MATCH(Left(Customer_Type,1), 5, 'S');
View solution in original post
Thanks Vishwarath that worked.
Glad. Close the thread accordingly.