topic Re: Datamodel in QlikView

Datamodel

rupaliqlik — Sat, 16 Nov 2024 19:28:41 GMT

Hi Experts,

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

Re: Datamodel

dplr-rn — Wed, 11 Dec 2019 17:28:24 GMT

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.

Re: Datamodel

rwunderlich — Wed, 11 Dec 2019 17:51:39 GMT

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

-Rob

Re: Datamodel

Brett_Bleess — Wed, 18 Dec 2019 16:53:51 GMT

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

Re: Datamodel

jduenyas — Wed, 18 Dec 2019 17:39:49 GMT

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.