Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Need to do one-to-one mapping between the fact tables and link table

Hi,

    I'm new to qlikview,to avoid synthetic keys I created the link table by renaming the  fields  using resident load as per the discussion

Qlik Tips: Rules for creating a Key/Link Table in QlikView

As a result I got the data model like this (fact.png).As per the requirement the dimension tables and link table is connected through the key columns but the fact tables are left alone.I need that fact tables to be connected with link tables through key columns.

3 Replies
Anonymous
Not applicable
Author

Hello,

Maybe put some of your code so that we can have a look at it.

If you rename the fields into dummy values, then no worries about privacy

Antoine

Not applicable
Author

Hi,

    PFB attachment.

Not applicable
Author

Hi,

PFA For Example QVW For Creating Link Table.

Regards,

Damu