topic Remove sync keys in QlikView

Remove sync keys

shaktisinghchau — Wed, 25 Nov 2020 16:16:04 GMT

I have two facts and 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 attached schema in that there are too many loops, please help me optimize this data model.

Re: Remove sync keys

oknotsen — Sun, 12 Jun 2016 11:03:58 GMT

The attached images does not show any Sync Keys. It does show indications of Circular References, but even for that the screenshot is too limited to figure out what your actual data model is.

In other words:

The data you are providing is too limited to try and help you and the title of your topic does not seem to have anything to do with your problem. Could you tell us more and show us more?

Re: Remove sync keys

idogridish2 — Sun, 12 Jun 2016 12:57:47 GMT

Hi Shakti,

you will need to build a Link Table.

See These posts:

Link Table in QlikView – Learn QlikView

how to create link table in Qlikview?

ido.