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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
george55
Partner - Creator III
Partner - Creator III

Display datamodel (links & tables) problem

Hi all,

Would like to show the datamodel with its links and tables in the datamanager tab. It works, but in one case not. Suppose the datamodel is to big or complex. Run and have been waiting for 6 hours with no results. No error was published during the waiting process (see attachment). It there an other possibility to display the datamodel?

Thanks for your help.

George

1 Solution

Accepted Solutions
marcus_sommer

It sounds that there is something wrong within your datamodel probably there are (multiple) synthetic keys and/or circular loops. If so Qlik tries to resolve them as good as possible but it might need enormous amounts of resources and if there is isn't enough RAM available it will swap multiple calculations to the virtual RAM.

To find these is not to difficult - you need just to reduce the number of records in your data maybe to a few hundreds with some where-clauses, FIRST statements or with an appropriate setting in the debugger (I assume Sense has one similar to View). After that you should see what's happening and could adjust it and the loading the full data-set again.

- Marcus

View solution in original post

4 Replies
asinha1991
Creator III
Creator III

how are you loading data through manager or load editor?

did you check data model viewer?

george55
Partner - Creator III
Partner - Creator III
Author

as I am a newbie, can you please give me more Inputs to be able to answer you?

btw, my Clik Sense is in German. To make it easier to cummunicate to you, it would be better to change the Qlik Sense language to English. How can I do that?

george55
Partner - Creator III
Partner - Creator III
Author

Find out that Data will be loaded through load Editor (in German: Dateneditor).

>"did you check data model Viewer?"

That is the reason why I opened this ticket. Would like to see the tables in de data model Viewer.

marcus_sommer

It sounds that there is something wrong within your datamodel probably there are (multiple) synthetic keys and/or circular loops. If so Qlik tries to resolve them as good as possible but it might need enormous amounts of resources and if there is isn't enough RAM available it will swap multiple calculations to the virtual RAM.

To find these is not to difficult - you need just to reduce the number of records in your data maybe to a few hundreds with some where-clauses, FIRST statements or with an appropriate setting in the debugger (I assume Sense has one similar to View). After that you should see what's happening and could adjust it and the loading the full data-set again.

- Marcus