Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Connect 2026! Turn data into bold moves, April 13 -15: Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
renuka_sasikumar
Creator III
Creator III

Qualify, Synthetic key, Circular Reference

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

4 Replies
datanibbler
Champion
Champion


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

MK_QSL
MVP
MVP

Please check enclosed file.

For circular reference .....http://community.qlik.com/blogs/qlikviewdesignblog/2013/06/25/circular-references

Not applicable

Hi Renuka

find the attachement.

it helps you.

Regards

Mahesh T