topic regarding keys in QlikView https://community.qlik.com/t5/QlikView/regarding-keys/m-p/258259#M1204408 <HTML><HEAD></HEAD><BODY><P></P><DIV><P>Hi</P><P>In QlikView the links between tables are made based on the field names. A surrogate key is the best candidate for this.</P><P>Be careful to end up in correct links by unintentinally use the same field names (e.g. Short_Desc etc)</P><P>You can have the table name added to the fields using QUALIFY to prevent such unwanted links. You can also use a pattern for link fields, e.g. add a "%" in front, to make them stand out. In this case you can QUALIFY all fields but UNQUALIFY "%*". There are some examples in the documentation.</P><P>SCD handling is mostly left to your app with some built in functions that help to deal with them like intervalmatch.</P><DIV>I have attached a simple example of an SCD2 case.</DIV></DIV><DIV></DIV><DIV>Regards</DIV><DIV></DIV><DIV>Jürg</DIV><BR /><BR /></BODY></HTML> Wed, 19 May 2010 14:19:54 GMT 2010-05-19T14:19:54Z regarding keys https://community.qlik.com/t5/QlikView/regarding-keys/m-p/258258#M1204407 <HTML><HEAD></HEAD><BODY><P>How to generate a key field in qlikview??? How qlikview will handle the surrogate keys??? how does qlikview handle slowly changing dimensions???</P></BODY></HTML> Wed, 19 May 2010 12:20:31 GMT https://community.qlik.com/t5/QlikView/regarding-keys/m-p/258258#M1204407 2010-05-19T12:20:31Z regarding keys https://community.qlik.com/t5/QlikView/regarding-keys/m-p/258259#M1204408 <HTML><HEAD></HEAD><BODY><P></P><DIV><P>Hi</P><P>In QlikView the links between tables are made based on the field names. A surrogate key is the best candidate for this.</P><P>Be careful to end up in correct links by unintentinally use the same field names (e.g. Short_Desc etc)</P><P>You can have the table name added to the fields using QUALIFY to prevent such unwanted links. You can also use a pattern for link fields, e.g. add a "%" in front, to make them stand out. In this case you can QUALIFY all fields but UNQUALIFY "%*". There are some examples in the documentation.</P><P>SCD handling is mostly left to your app with some built in functions that help to deal with them like intervalmatch.</P><DIV>I have attached a simple example of an SCD2 case.</DIV></DIV><DIV></DIV><DIV>Regards</DIV><DIV></DIV><DIV>Jürg</DIV><BR /><BR /></BODY></HTML> Wed, 19 May 2010 14:19:54 GMT https://community.qlik.com/t5/QlikView/regarding-keys/m-p/258259#M1204408 2010-05-19T14:19:54Z