Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Attend QlikWorld 2020 and hear keynote speaker, Malcolm Gladwell. Register by February 29th to save $200. Learn More
Highlighted
rupaliqlik
Contributor

Datamodel

Hi Experts,

Here is my datamodel which contain synthetic key but don't know how to resolve this issue.Linktable will work here?

 
 
Labels (1)
4 Replies
Highlighted
Partner
Partner

Re: Datamodel

Link table may work but synthetic key s are effectively link tables that qlik creates automatically.

I dont know if there will be any performance benefits using link tables. You will need to try and see.

synthetic key (simple ones) it self does cause performance issues but looking at the data model it points to a data modelling issue. maybe you need to combine a few of the tables together.

to put simply there is no easy answer.

Highlighted
MVP & Luminary
MVP & Luminary

Re: Datamodel

Do the rows represent employees enrolled in those plans, or are they just plan data?

-Rob

Highlighted
Digital Support
Digital Support

Re: Datamodel

Have a look at the following Design Blog post, believe it should help you sort out the synthetic keys:

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

Here is the base Design Blog link in case you want to search for other posts that may be helpful on your own:

https://community.qlik.com/t5/Qlik-Design-Blog/bg-p/qlik-design-blog

Regards,
Brett

To help users find verified answers, please don't forget to use the "Accept as Solution" button on any posts that helped you resolve your problem or question.
Highlighted
jduenyas
Contributor III

Re: Datamodel

If all tables are supposed to be linked, create a unique field that is common for all of them by which they will be connected and rename each of these common fields specifically to each table. You cannot have the same column names appear in multiple tables because Qlik links table by fields that are named alike.