Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor III
Contributor III

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

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

1 Solution

Accepted Solutions
Highlighted
Champion III
Champion III

May be try like:

Where

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

View solution in original post

3 Replies
Highlighted
Champion III
Champion III

May be try like:

Where

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

View solution in original post

Highlighted
Contributor III
Contributor III

Thanks Vishwarath that worked.

Highlighted
Champion III
Champion III

Glad. Close the thread accordingly.