AND-Mode - please help

[#1]

in And TAB of attached qvw...

1) this andModeJoin: is not working ---> I don't understand why and could use support to explain & fix:

  andModeJoin:

     Load Food,

     Rating

     Resident Health;

     andMode:

     Load Distinct

     Food,

     Rating as andRating

     Resident andModeJoin;

     DROP Table andModeJoin;

2) this andModeJoin: is working, but it is limited to the [Applebees Menu] table ---> how do we extend the andModeJoin: to include the [TGIF Menu] table?

andModeJoin:

Load Item, Customer Resident POS;

Join (andModeJoin) Load Item, Food Resident [Applebee Menu];

andMode:

Load Distinct

Customer,

Food as andFood

Resident andModeJoin;

DROP Table andModeJoin;

...thanks in advance!

[Carlos_Reyes · Accepted solution]

I don't really get what you're trying to do... but I think that when you look for the table "andModeJoin" it doesn't exists since its records have already been concantenated to the Health table.

That happens because QlikView detects that there are two tables with equal number of columns equal column names, so it automatically concatenates the records of the second table to the first.

In order to avoid this automatic concatenation you must use the KEYWORD "NoConcatenate" before the LOAD. Like this:

andModeJoin:
      NoConcatenate
    Load Food,
    Rating
    Resident Health;

Or you can change at least one column name so that this table is different from the Health table.

Hope it helps!

[#3]

Carlos,

Thanks for your response and help.

Your answer made me realize that AND-mode may not be necessary.

The goal was to exclude "healthy" or "not-healthy" foods. But your answer made me realize by selecting one the other is excluded. In other words, there are only 2 values, they are, by definition, mutually exclusive. Which makes me see that AND-mode should be used when there are 3 or more values in a field.

Oliver