Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Customers, Partners & Luminaries only: You're invited to a Data Analytics Roadmap session. Read More
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
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

 

Highlighted

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