topic Re: How to Remove synthetic keys ???? in QlikView https://community.qlik.com/t5/QlikView/How-to-Remove-synthetic-keys/m-p/641924#M235164 <HTML><HEAD></HEAD><BODY><P>Could you be more specific about your requirement?</P></BODY></HTML> Fri, 06 Jun 2014 06:08:34 GMT senpradip007 2014-06-06T06:08:34Z How to Remove synthetic keys ???? https://community.qlik.com/t5/QlikView/How-to-Remove-synthetic-keys/m-p/641923#M235163 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>Please find attached QVW and QVD files.</P><P></P><P>I have data model with many synthetic keys generated.</P><P>It shows its ambiguous when data is loaded.</P><P></P><P>Please someone help me how to work on it.</P><P></P><P>Detailed explanation is required. I worked only on dashboard designing not on the model.</P><P></P><P>Thanks &amp; Regards,</P><P>Keerthi</P></BODY></HTML> Fri, 06 Jun 2014 06:05:25 GMT https://community.qlik.com/t5/QlikView/How-to-Remove-synthetic-keys/m-p/641923#M235163 2014-06-06T06:05:25Z Re: How to Remove synthetic keys ???? https://community.qlik.com/t5/QlikView/How-to-Remove-synthetic-keys/m-p/641924#M235164 <HTML><HEAD></HEAD><BODY><P>Could you be more specific about your requirement?</P></BODY></HTML> Fri, 06 Jun 2014 06:08:34 GMT https://community.qlik.com/t5/QlikView/How-to-Remove-synthetic-keys/m-p/641924#M235164 senpradip007 2014-06-06T06:08:34Z Re: How to Remove synthetic keys ???? https://community.qlik.com/t5/QlikView/How-to-Remove-synthetic-keys/m-p/641925#M235165 <HTML><HEAD></HEAD><BODY><P>Many synthetic keys are generated when i load data. </P><P>How to remove the synthetic keys without affecting the data model.</P><P></P><P>Please check data model in QVW.</P></BODY></HTML> Fri, 06 Jun 2014 06:12:26 GMT https://community.qlik.com/t5/QlikView/How-to-Remove-synthetic-keys/m-p/641925#M235165 2014-06-06T06:12:26Z Re: How to Remove synthetic keys ???? https://community.qlik.com/t5/QlikView/How-to-Remove-synthetic-keys/m-p/641926#M235166 <HTML><HEAD></HEAD><BODY><P>I'm very sorry to say that Its very difficult to understand the data model. You can remove the synthetic key by renaming the field. Please explain your desire result for which data model may be changed in that scenario.</P></BODY></HTML> Fri, 06 Jun 2014 06:18:08 GMT https://community.qlik.com/t5/QlikView/How-to-Remove-synthetic-keys/m-p/641926#M235166 senpradip007 2014-06-06T06:18:08Z Re: How to Remove synthetic keys ???? https://community.qlik.com/t5/QlikView/How-to-Remove-synthetic-keys/m-p/641927#M235167 <HTML><HEAD></HEAD><BODY><P>Actually i am not getting proper results in the dashboard and data filtering is not happening for few fields.</P><P></P><P>I heard somewhere that&nbsp; there should be a centralized table. Even i dunno exactly </P></BODY></HTML> Fri, 06 Jun 2014 06:23:53 GMT https://community.qlik.com/t5/QlikView/How-to-Remove-synthetic-keys/m-p/641927#M235167 2014-06-06T06:23:53Z Re: How to Remove synthetic keys ???? https://community.qlik.com/t5/QlikView/How-to-Remove-synthetic-keys/m-p/641928#M235168 <HTML><HEAD></HEAD><BODY><P>As per my understanding you might have two fact tables named <STRONG>Fact_Limit, Fact_Claim</STRONG>. Merge these two tables into one single fact table and other master tables might be linked with the fact table.</P><P>You may follow this way and might get the desired data model.</P></BODY></HTML> Fri, 06 Jun 2014 06:42:09 GMT https://community.qlik.com/t5/QlikView/How-to-Remove-synthetic-keys/m-p/641928#M235168 senpradip007 2014-06-06T06:42:09Z Re: How to Remove synthetic keys ???? https://community.qlik.com/t5/QlikView/How-to-Remove-synthetic-keys/m-p/641929#M235169 <HTML><HEAD></HEAD><BODY><P>You have to follow one of the model for your data model like Start or Snow flake schema but you need to check from your end which model gives a desire output as you want by cross check the sum value for any month or year by the model. There are many threads in the community for the data modelling related see some of them i mentioned</P><P></P><P></P><P><A href="https://community.qlik.com/docs/DOC-4957">Creating a Data Model</A></P></BODY></HTML> Fri, 06 Jun 2014 06:50:09 GMT https://community.qlik.com/t5/QlikView/How-to-Remove-synthetic-keys/m-p/641929#M235169 its_anandrjs 2014-06-06T06:50:09Z