Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Coming Aug. 9: New Simplified Authoring for Qlik Sense SaaS – For Details, CLICK HERE
cancel
Showing results for 
Search instead for 
Did you mean: 
rupaliqlik
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
dplr-rn
Partner - Master III
Partner - Master III

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.

rwunderlich

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

-Rob

Brett_Bleess
Employee
Employee

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

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.