topic Problem with composite keys /Generic keys in QlikView https://community.qlik.com/t5/QlikView/Problem-with-composite-keys-Generic-keys/m-p/943893#M958486 <HTML><HEAD></HEAD><BODY><P>Initially I have the following design </P><P></P><P><IMG alt="Sans titre.png" class="jive-image" src="/legacyfs/online/104012_Sans titre.png" /></P><P>To avoid generic keys I create composite keys in both tables Budget and TempSales as follow </P><P>"Code Site"&amp;'|'&amp;"Code Structure"&amp;'|'&amp;&nbsp; 'O'&amp;'|'&amp;&nbsp;&nbsp;&nbsp; Date(Date#([Date Time],'YYYY-MM-DD'),'YYYYMMDD') as BudgetId</P><P></P><P><IMG alt="Sans titre.png" class="jive-image image-1" src="/legacyfs/online/104011_Sans titre.png" style="height: 356px; width: 620px;" /></P><P></P><P>Now I didn't get the best values of budget , How to resolve it ? </P></BODY></HTML> Thu, 05 Nov 2015 10:59:42 GMT Anonymous 2015-11-05T10:59:42Z Problem with composite keys /Generic keys https://community.qlik.com/t5/QlikView/Problem-with-composite-keys-Generic-keys/m-p/943893#M958486 <HTML><HEAD></HEAD><BODY><P>Initially I have the following design </P><P></P><P><IMG alt="Sans titre.png" class="jive-image" src="/legacyfs/online/104012_Sans titre.png" /></P><P>To avoid generic keys I create composite keys in both tables Budget and TempSales as follow </P><P>"Code Site"&amp;'|'&amp;"Code Structure"&amp;'|'&amp;&nbsp; 'O'&amp;'|'&amp;&nbsp;&nbsp;&nbsp; Date(Date#([Date Time],'YYYY-MM-DD'),'YYYYMMDD') as BudgetId</P><P></P><P><IMG alt="Sans titre.png" class="jive-image image-1" src="/legacyfs/online/104011_Sans titre.png" style="height: 356px; width: 620px;" /></P><P></P><P>Now I didn't get the best values of budget , How to resolve it ? </P></BODY></HTML> Thu, 05 Nov 2015 10:59:42 GMT https://community.qlik.com/t5/QlikView/Problem-with-composite-keys-Generic-keys/m-p/943893#M958486 Anonymous 2015-11-05T10:59:42Z Re: Problem with composite keys /Generic keys https://community.qlik.com/t5/QlikView/Problem-with-composite-keys-Generic-keys/m-p/943894#M958487 <HTML><HEAD></HEAD><BODY><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">"Code Site"&amp;'|'&amp;"Code Structure"&amp;'|'&amp;&nbsp; 'O'&amp;'|'&amp;&nbsp;&nbsp;&nbsp; Date(Date#([Date Time],'YYYY-MM-DD'),'YYYYMMDD') </SPAN></P><P></P><P>Is your BudgetID unique?</P></BODY></HTML> Thu, 05 Nov 2015 11:03:57 GMT https://community.qlik.com/t5/QlikView/Problem-with-composite-keys-Generic-keys/m-p/943894#M958487 Anonymous 2015-11-05T11:03:57Z Re: Problem with composite keys /Generic keys https://community.qlik.com/t5/QlikView/Problem-with-composite-keys-Generic-keys/m-p/943895#M958488 <HTML><HEAD></HEAD><BODY><P>no not unique </P></BODY></HTML> Thu, 05 Nov 2015 11:07:59 GMT https://community.qlik.com/t5/QlikView/Problem-with-composite-keys-Generic-keys/m-p/943895#M958488 Anonymous 2015-11-05T11:07:59Z Re: Problem with composite keys /Generic keys https://community.qlik.com/t5/QlikView/Problem-with-composite-keys-Generic-keys/m-p/943896#M958489 <HTML><HEAD></HEAD><BODY><P>Make sure it should be else you may get wrong data as well</P></BODY></HTML> Thu, 05 Nov 2015 11:13:38 GMT https://community.qlik.com/t5/QlikView/Problem-with-composite-keys-Generic-keys/m-p/943896#M958489 Anonymous 2015-11-05T11:13:38Z Re: Problem with composite keys /Generic keys https://community.qlik.com/t5/QlikView/Problem-with-composite-keys-Generic-keys/m-p/943897#M958490 <HTML><HEAD></HEAD><BODY><P>how to make it a unique key please ?</P></BODY></HTML> Thu, 05 Nov 2015 11:18:19 GMT https://community.qlik.com/t5/QlikView/Problem-with-composite-keys-Generic-keys/m-p/943897#M958490 Anonymous 2015-11-05T11:18:19Z Re: Problem with composite keys /Generic keys https://community.qlik.com/t5/QlikView/Problem-with-composite-keys-Generic-keys/m-p/943898#M958491 <HTML><HEAD></HEAD><BODY><P>For that post some sample data of Budget &amp; TempSales table...</P></BODY></HTML> Thu, 05 Nov 2015 11:21:04 GMT https://community.qlik.com/t5/QlikView/Problem-with-composite-keys-Generic-keys/m-p/943898#M958491 Anonymous 2015-11-05T11:21:04Z