Having problem, with loading a document help

[qlikmpate0]

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.

[tobias_klett]

Hi,

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

where Datefield > yearstart(today());

Hope this helps
Tobias

[Colin-Albert]

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

[qlikmpate0]

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

[qlikmpate0]

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

[Colin-Albert]

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

[qlikmpate0]

[Colin-Albert]

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.

[Colin-Albert]

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