topic Re: Improve data model in QlikView

Improve data model

Anonymous — Tue, 28 Jul 2015 09:30:00 GMT

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 ?

Re: Improve data model

marcus_sommer — Tue, 28 Jul 2015 09:41:32 GMT

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

- Marcus

Re: Improve data model

jonathandienst — Tue, 28 Jul 2015 09:54:37 GMT

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.