Improve data model

[Anonymous]

I have two facts

I use the following code to load from QVD

Vente:

LOAD PrixUnitaireArticle,

     PrixArticleHT,

     PrixRevientTTC,

     MargeHT,

     MargeTTC,

     ValeurRevientHT,

     ValeurRevientTTC,

     ValeurMargeHT,

     ValeurMargeTTC,

     PrixVenteHT,

FROM

E:\QVD TEST\VenteFULL.qvd

(qvd);

LOAD

  [idObjCA]

      ,[CA TTC]

      ,[VAL MRG TTC]

      ,[CA HT]

      ,[VAL MRG HT]

      ,[Rayon]

      , [Date Time Budget]

      ,[Code Site Budget]

      ,[Code Rayon]

FROM

E:\QVD TEST\Budget.qvd

(qvd)

When I load data , I got the following shema , there are too many loops .

How can I improve myn data model ?

[marcus_sommer · Accepted solution]

See especially the first 3 links within these posting: Get started with developing qlik datamodels.

- Marcus

[jonathandienst]

Your post is confusing - your script loads 2 tables with no common fields and therefore no associations. Your image shows 6 tables with at least one more off the image. If you want to improve the load script you will need to upload the entire loadscript.

But ultimately the schema depends on proper analysis to understand the data, and the relationships within the data, together with the measures/,metrics that you want to report, and the dimensions/attributes that you would use to build your sheet objects. So its easy to prevent the loops - but just adding qualifies and aliases may not give you a practical model from which you can report.