exclude records

[yelin_nyu]

I have 2 qvds containing 2 lists: main & special. Main includes special and non special list.

I want to look at data in non special.

normally in sql i would do a where statement.

where item not in (select item from special_list_table)

but how do i do this in qlikview?

Thanks

[Anonymous · Accepted solution]

Hi,

You can use Where not exists(). Check it out in the F1 help.

Load Special, then load the Main where a key field does not exist in the special table and proceed to drop the special table I guess. Using Keep would be an option as well.