QlikView load not exists in

[#1]

Hi,

I am creating a QlikView dashboard with sales data tables dependent on a series of filters.

For example.

Sales based on keywords in the product name

Sales from website search words

Sales based on the page path the customer went through before making the sale

These tables will have some overlap of sales dependent  on a customers behaviour, so if a customer searched a word and then bought a product with a keyword in it, they would be in the search and the keyword tables.

The distinct order number is in each table. 

How do I exclude orders from the search and pagepath tables if they are in any of the other tables.  I wan't to keep orders in the search table that are not in the keywords table and keep orders in the pagepath table that are not in the search or keywords table?

Thanks in advance

Michelle

[swuehl]

I think you can use NOT EXISTS() for this:

KEYWORDS:

LOAD Keyword,

          OrderNo

FROM ....;

SEARCH:

LOAD Search,

          OrderNo

FROM ....

WHERE NOT EXISTS(OrderNo);

PAGEPATH:

LOAD PagePath,

          OrderNo

FROM ....

WHERE NOT EXISTS(OrderNo);

EXISTS() will check existince of the value in field OrderNo, i.e. if the specific OrderNo has already been loaded into QV in a previous or the current LOAD.

This does also mean that these tables need to load OrderNo first in your app, if there is another table loading OrderNo, you should load this table after the above three tables (or, alternatively you need to use EXISTS() with two arguments and a renamed field).

Hope this helps,

Stefan

[#3]

Thanks Stefan, I'll try this!