Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
how are you loading data through manager or load editor?
did you check data model viewer?
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?
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.
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