Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

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

Not in statement

Hi,

 

I use the following a lot when selecting data from the SQL server:

SQL SELECT

FROM "Item Ledger Entry"

Where  "Global Dimension 2 Code" not in ('CF');

 

I would like to use this same function when loading from a "Table File" but it seems not to be working.

 

What is the solution for this?

 

 

 

Labels (2)
1 Solution

Accepted Solutions
Highlighted
Specialist II
Specialist II

Try "Global Dimension 2 Code" <> ('CF')

If that doesn't work then providing a sample mock data file would be helpful to assist you

View solution in original post

3 Replies
Highlighted
Partner
Partner

hi 

you can use not exists statement that only load values from a field if they aren't already exists in another field or the same field 

not exists help

 

May be like this

Where Not Match([Global Dimension 2 Code], 'CF');
Highlighted
Specialist II
Specialist II

Try "Global Dimension 2 Code" <> ('CF')

If that doesn't work then providing a sample mock data file would be helpful to assist you

View solution in original post