Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I loaded some table which is contain 1 common field and there is no fact table.
in this data model we can Travers from one table to another by using many path then why circular reference is not formed here.
thank you.
Accepted Solutions
Hi Prachi,
Circular reference would not happen because of the special structure of tables (All tables are connected with key). Hence, Qlikview engine in this case would not require to go through any intermediate table. Although you may have same columns to query in different tables but path would remain same and that would be direct.
By just breaking this key in table 'P' and adding a column, Now there is a circular loop. Because, Now QV engine has different path to access same column.
Hi Prachi,
Circular reference would not happen because of the special structure of tables (All tables are connected with key). Hence, Qlikview engine in this case would not require to go through any intermediate table. Although you may have same columns to query in different tables but path would remain same and that would be direct.
By just breaking this key in table 'P' and adding a column, Now there is a circular loop. Because, Now QV engine has different path to access same column.
