The script is executed with the Generic prefix (visible in the exhibit).

Generic LOAD makes Qlik Sense create a separate data table for every distinct value that appears in the second field of the LOAD statement and an additional link-table that contains only the key field(s).

In the script the second field, Measure, contains five distinct values (Sales, Cost, Discount, Margin, Quantity).

Therefore, Qlik Sense produces:

• 5 measure tables (one for each value of Measure)

• 1 key/link table (OrderID)

Total = 6 tables.

A. 1 – Generic LOAD never results in a single table; at least two are produced (key + one distinct value).

B. 3 – Would require exactly two distinct Measure values; the script shows five.

C. 4 – Would require exactly three distinct Measure values; the script shows five.

1. Qlik Sense Help, “Generic – script prefix”, May 2023 release, paragraphs 1–3: “…one data table for each distinct value of the second field… plus one table containing the key field(s).”

2. Qlik Sense Data Modeling guide, section “Using the Generic prefix”, pp. 37-38: example demonstrates 5 attributes → 6 tables.

3. Qlik Continuous Classroom, course “Advanced Data Modeling”, lesson “Pivoting with Generic Load”, timestamp 02:10–02:45 confirms formula N attributes + 1 key table.