Skip to main content
Announcements
Qlik Connect 2025: 3 days of full immersion in data, analytics, and AI. May 13-15 | Orlando, FL: Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

AND-Mode - please help

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!

1 Solution

Accepted Solutions
Carlos_Reyes
Partner - Specialist
Partner - Specialist

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!

View solution in original post

2 Replies
Carlos_Reyes
Partner - Specialist
Partner - Specialist

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!

Not applicable
Author

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