Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor III
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.

2 Replies
Highlighted
Master III
Master III

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?

Don't allow Perfection to be the enemy of Good Enough.
May you live in interesting times!
Highlighted
Creator II
Creator II

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.