I am new to Qlikview and am trying to exclude some values in a Where clause in the load statement

[jmcdermott]

The clause I am using is below

Where

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?

Thanks,

Josh

[vishsaggi · Accepted solution]

May be try like:

Where

NOT MATCH(Left(Customer_Type,1), 5, 'S');

[jmcdermott]

Thanks Vishwarath that worked.

[vishsaggi]

Glad. Close the thread accordingly.