topic Datamodel in QlikView https://community.qlik.com/t5/QlikView/Datamodel/m-p/611325#M478188 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>My datamodel have three tables.both the dimension tables are linked to the fact table with an <STRONG>Product_R_ID</STRONG> as key.</P><P>I have given an alias as [<STRONG>Product R ID</STRONG>] to avoid synthetic key.I need to have this field in all three tables.</P><P>Though it's giving correct results with a (star schema datamodel structure too) but does it affect anything/ is it wrong to give alias as i used this field as filter (in one sheet as <STRONG>Product_R_ID</STRONG> and in another [<STRONG>Product R ID</STRONG>]).</P><P></P><P>Thanks in advance.</P></BODY></HTML> Sun, 23 Mar 2014 18:35:05 GMT 2014-03-23T18:35:05Z Datamodel https://community.qlik.com/t5/QlikView/Datamodel/m-p/611325#M478188 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>My datamodel have three tables.both the dimension tables are linked to the fact table with an <STRONG>Product_R_ID</STRONG> as key.</P><P>I have given an alias as [<STRONG>Product R ID</STRONG>] to avoid synthetic key.I need to have this field in all three tables.</P><P>Though it's giving correct results with a (star schema datamodel structure too) but does it affect anything/ is it wrong to give alias as i used this field as filter (in one sheet as <STRONG>Product_R_ID</STRONG> and in another [<STRONG>Product R ID</STRONG>]).</P><P></P><P>Thanks in advance.</P></BODY></HTML> Sun, 23 Mar 2014 18:35:05 GMT https://community.qlik.com/t5/QlikView/Datamodel/m-p/611325#M478188 2014-03-23T18:35:05Z Re: Datamodel https://community.qlik.com/t5/QlikView/Datamodel/m-p/611326#M478189 <HTML><HEAD></HEAD><BODY><P>Can Qualify solve this problem?Instead of giving Alias, how better Qualify ll be??</P></BODY></HTML> Sun, 23 Mar 2014 18:56:44 GMT https://community.qlik.com/t5/QlikView/Datamodel/m-p/611326#M478189 2014-03-23T18:56:44Z Re: Datamodel https://community.qlik.com/t5/QlikView/Datamodel/m-p/611327#M478190 <HTML><HEAD></HEAD><BODY><P>If you only have one field common to three different tables, then you should not get a synthetic key at all.</P><P>Therefore I don't think you need this alias field.</P><P></P><P><IMG __jive_id="55652" alt="QlikCommunity_Thread_111631_Pic1.JPG.jpg" class="jive-image" src="https://community.qlik.com/legacyfs/online/55652_QlikCommunity_Thread_111631_Pic1.JPG.jpg" /></P><P></P><P>regards</P><P></P><P>Marco</P></BODY></HTML> Sun, 23 Mar 2014 22:32:52 GMT https://community.qlik.com/t5/QlikView/Datamodel/m-p/611327#M478190 MarcoWedel 2014-03-23T22:32:52Z