Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Announcing the newest addition to the Qlik Community, Qlik Gallery! Learn More
Highlighted
shaktisinghchau
New Contributor III

Remove sync keys

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.

Tags (1)
2 Replies
oknotsen
Honored Contributor III

Re: Remove sync keys

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?

May you live in interesting times!
idogridish2
Contributor II

Re: Remove sync keys

Hi Shakti,

you will need to build a Link Table.

See These posts:

Link Table in QlikView – Learn QlikView

or

how to create link table in Qlikview?

ido.