topic Re: AND-Mode - please help in QlikView

AND-Mode - please help

Fri, 31 Jan 2014 23:11:20 GMT

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!

Re: AND-Mode - please help

Carlos_Reyes — Fri, 31 Jan 2014 23:55:56 GMT

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!

Re: AND-Mode - please help

Sat, 01 Feb 2014 19:44:23 GMT

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