Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld online is next week! REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
ranibosch
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
vvira1316
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
lironbaram
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

 

sunny_talwar

May be like this

Where Not Match([Global Dimension 2 Code], 'CF');
vvira1316
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