- "Qualify" - that is a script_command that will cause all fields specified (or all but those specified) to be "qualified" with the name of the table whence they come
=> If field_name is "seesaw" and table_name is "playground", then after that command, it will be
>> playground.seesaw << - practical if you have equal field_names in several tables, to avoid QlikView automatically linking.
- "Synthetic key" - is something to avoid whenever possible. It just means that two or more tables are linked by two or more common fields (that have the same name across tables).
=> Avoid that either by renaming fields, dropping temporary tables or by creating a compound_key (which actually does the same, but in a controlled way)
- "Circular reference" - is also something you should avoid. It just means, when you have tables A, B and C, that table A is linked to table B and to table C, so you already have all three tables linked, ok? - And additionally, table C is linked to table B via another field - so you have a circular reference from A to B to C to A - which will cause QlikView to break up your data_structure.
