Hi,
You can go through the extract given in the book (Qlikview_Reference_Manual) at Page 385 of 942 to know about semantic load and their related examples.
Some of the extracts is as follows :
Semantic links are created by loading tables containing the relations between the objects.
- l The table must contain exactly three or four columns.
- l A semantic table must either contain relations between field values of different fields or between field
values of the same field. A mixture between the two is not accepted.
- l The load or select statement loading a semantic table must be preceded by a semantic qualifier to
show that it is not a logical table.
Normally four columns are used, the first one containing the field values that have a relation to some other
field value and the third one containing the related field value.
The second column must contain the names of the relations, and finally,
the fourth one must contain the names of the inverse relations.
If three columns are used, no explicit names for the inverse relations can be given. The names given in the
second column are used both for the relation and the inverse relation. The names are then preceded or followed
by arrows.
If the relations are between field values of the same field, the first and third columns must have the same
name. Also the names of the second and fourth column, i.e. the type of the relations, must be the same.
However,if the relations are between field values of different fields, all columns must have different names.
Please find the attachment for detailed understanding.
Thanks and Regards,
Geeta
