Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Qlik Analytics Tour 2020 Online. Begins August 10th. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

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 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.
Highlighted
Specialist
Specialist

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.