topic Re: Qualify, Synthetic key, Circular Reference in QlikView

Qualify, Synthetic key, Circular Reference

renuka_sasikumar — Tue, 18 Feb 2014 10:50:44 GMT

Hi,

Can anyone please help me with good explanation on Qualify, Synthetic key, Circular Reference in brief

Wen to use, Y to use n How to use

As I am new to Qlikview

Re: Qualify, Synthetic key, Circular Reference

datanibbler — Tue, 18 Feb 2014 11:00:39 GMT

Hi Renuka,

- "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.

HTH

Best regards,

DataNibbler