In this case it's better if you start reading the reference manual.
27.1 Generic Databases
A generic database is a table in which the field names are stored as field values in one column, while the
field values are stored in a second. Generic databases are usually used for attributes of different objects.
Consider the example below. It is a generic database containing two objects, a ball and a box. Obviously
some of the attributes, like color and weight, are common to both the objects, while others, like diameter,
height length and width are not.
object attribute value ball color red ball diameter 10 cm ball weight 100 g box color black box height 16 cm box length 20 cm box weight 500 g box width 10 cm
since many of the attributes are not relevant for a specific object.On one hand it would be awkward to store the data in a way giving each attribute a column of its own,
On the other hand, it would look messy displaying it in a way that mixed lengths, colors and weights.
If this database is loaded into QlikView using the standard way, we get three different list boxes on the
However, if the table is loaded as a generic database, QlikView will split up column two and three into different
list boxes. QlikView will then generate one field for each unique value of the second column.
QlikView 11 SR2, 11414 379
The syntax for doing this is simple:
Generic select * from GenericTable;
It does not matter whether a load or select statement is used to load the generic database.