Logic in databases
Several tables from a database application can be included simultaneously in the Qlik Sense logic. When a field exists in more than one table, the tables are logically linked through this key field.
When a value is selected, all values compatible with the selection(s) are displayed as optional. All other values are displayed as excluded.
If values from several fields are selected, a logical AND is assumed.
If several values of the same field are selected, a logical OR is assumed.
In some cases, selections within a field can be set to logical AND.