topic Re: Not in statement in QlikView

Not in statement

ranibosch — Sat, 16 Nov 2024 04:45:59 GMT

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?

lironbaram — Mon, 14 Jan 2019 12:50:13 GMT

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

sunny_talwar — Mon, 14 Jan 2019 12:55:19 GMT

May be like this

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

vvira1316 — Mon, 14 Jan 2019 13:14:51 GMT

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

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