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

How To link 2 Tables with one unique Key to avoid synthetic key

Hi guys,

I have a problem with my model.

model1.PNG

I want to link two table "expéditions ventes" with "SalesInvoiceLine" with a unique key to avoid synthetic Key in my model, I want to concatenate ("Key Table with Order No") and use  AutoNumber but I don't know how to do it .

Here is the details of my 2 tables :

ExpéditionsVente:

Model2.PNG

SalesInvoiceLine:

model3.PNG

 Thank you guys for your help.

Kind Regards

2 Replies
Highlighted
Contributor III
Contributor III

Hi guys,

Any help please I really need it to complete my application.
Thanks.

Kind regards

Highlighted
Digital Support
Digital Support

The following Design Blog post should take care of helping you get things sorted:

https://community.qlik.com/t5/Qlik-Design-Blog/Synthetic-Keys/ba-p/1472634

Regards,
Brett

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.