Skip to main content Skip to complementary content

Logic in databases

Several tables from a database application can be included simultaneously in the QlikView 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.

If Info display of a field is desired, a two-column table must be included in the script. The first column of the table must contain values of the field, the second the information associated with the field value.. The first column must have the field name as heading. A special script syntax of the LOAD/SELECT statement tells QlikView to treat this table as an Information table.

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!

Join the Analytics Modernization Program

Remove banner from view

Modernize without compromising your valuable QlikView apps with the Analytics Modernization Program. Click here for more information or reach out: ampquestions@qlik.com