Not in statement

[ranibosch]

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?

[sunny_talwar · Accepted solution]

Look here

https://community.qlik.com/t5/New-to-Qlik-Community/Not-in-statement/m-p/1529981/highlight/false#M82...