topic What does the dotted arrow line show in data model in QlikView

What does the dotted arrow line show in data model

Anonymous — Thu, 22 Jun 2017 03:33:42 GMT

What does the dotted arrow line show in data model

Re: What does the dotted arrow line show in data model

BalaBhaskar_Qlik — Thu, 22 Jun 2017 04:20:26 GMT

Circular References, on Circular References loosely coupled tables are created.

Re: What does the dotted arrow line show in data model

prma7799 — Thu, 22 Jun 2017 04:26:24 GMT

I think it is showing or representing curricular loop

Re: What does the dotted arrow line show in data model

prma7799 — Thu, 22 Jun 2017 04:27:48 GMT

Please check

Data Model

To find the exact cause of the above warning we can look at the data model by using the menu command for table viewer - Control+T. The following screen comes up, which clearly shows the circular reference. Here the join between RegionCountry and SalesRegion can be directly achieved using the field Region. It can also be achieved by first going to the table ProductCountry, using the field Country and then mapping ProdcutID with Salesregion.

Re: What does the dotted arrow line show in data model

Sergey_Shuklin — Thu, 22 Jun 2017 05:08:36 GMT

Hello!

For avoiding loops try to use unique keys for all fact tables and dimension tables (dictionaries). Multiple syntethic keys can be the reason why loop had appeared.

Re: What does the dotted arrow line show in data model

prma7799 — Thu, 22 Jun 2017 06:56:52 GMT

Hi dynamic_girl

You have been very active on the community but I find it hard to believe there is not one thread that you have received an answer to!

Can you take some time to mark correct / useful response's to your posts for the benefit of other people who may have a similar query?

Please check dynamic_girl

Read the below thread please.

Qlik Community Tip: Marking Replies as Correct or Helpful

Re: What does the dotted arrow line show in data model

Anonymous — Fri, 23 Jun 2017 05:47:20 GMT

i dont have multiple common fields ,there are only two tables in my data model,

and the two table are just associated with id field,

whats the reason

how i should associate or join my tables then to avoid this loop?

can any info be provided from table structure view?

Re: What does the dotted arrow line show in data model

prma7799 — Fri, 23 Jun 2017 05:56:05 GMT

Please check this

Circular References

Re: What does the dotted arrow line show in data model

Anonymous — Fri, 23 Jun 2017 08:10:52 GMT

i have a value in percentage displayed as :

123456.89%

i want to round off to 12.89%(eg two digits) ,how to do that?

Re: What does the dotted arrow line show in data model

Peter_Cammaert — Fri, 23 Jun 2017 08:20:22 GMT

Does this have anything to do with dotted lines or circular references? If not, please post a new question regarding the rounding of numbers, and close this one. Thanks.

Re: What does the dotted arrow line show in data model

prma7799 — Fri, 23 Jun 2017 08:37:27 GMT

Please close this thread marking helpful or correct answer.