Discussion Board for collaboration related to QlikView App Development.
I use the following a lot when selecting data from the SQL server:
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?
View solution in original post
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');