topic Re: Having problem, with loading a document help in QlikView

Having problem, with loading a document help

qlikmpate0 — Fri, 15 Aug 2014 08:58:49 GMT

I have created a document with some selectors and three straight tables, but the data in the tables does not display, please find attached. I have tried renaming the doc but same thing happens any suggestions?

thanks in advance.

Re: Having problem, with loading a document help

tobias_klett — Fri, 15 Aug 2014 09:02:40 GMT

Hi,

the objects seem to be calculating. Try loading less data by where clause.
Example:

where Datefield > yearstart(today());

Hope this helps
Tobias

Re: Having problem, with loading a document help

Colin-Albert — Fri, 15 Aug 2014 10:40:59 GMT

Can you post an image of your data model from the Table Viewer?

Re: Having problem, with loading a document help

qlikmpate0 — Fri, 15 Aug 2014 10:49:40 GMT

Sorry unable to get table viewer as it just will not do anything.

Re: Having problem, with loading a document help

qlikmpate0 — Fri, 15 Aug 2014 10:50:47 GMT

Would the where clause hav eto be in scripting as I'm already restricting data there?

Re: Having problem, with loading a document help

Colin-Albert — Fri, 15 Aug 2014 11:07:15 GMT

Use Debug mode in the load script to just load 10 rows, then you can see if the data model is the cause of your problem.

Select Debug, tick Limited Load and set to 10 then click Run

Re: Having problem, with loading a document help

qlikmpate0 — Fri, 15 Aug 2014 11:23:14 GMT

Re: Having problem, with loading a document help

Colin-Albert — Fri, 15 Aug 2014 11:28:49 GMT

Hi Mina,

From your model you have some isolated sets of data -

(Shipping Or.. & WMSOrganis...)

and (FlexSets & Flex Values)

Including values from either isolated datasets with fields from other data sets will create a cartesian join between the values which I guess is the cause of your slow response.

You either need to set the correct links between the tables in your model, or remove the fields that are causing the cartesian join from your charts.

Re: Having problem, with loading a document help

Colin-Albert — Fri, 15 Aug 2014 11:30:27 GMT

Your Sales Order & Invoice data is also isolated from the customer data.