topic Re: AutoNumberHash128 to Eliminate Synthetic Keys in QlikView https://community.qlik.com/t5/QlikView/AutoNumberHash128-to-Eliminate-Synthetic-Keys/m-p/1290131#M403513 <HTML><HEAD></HEAD><BODY><P>A synthetic key is linking two or more tables. You would need to create the new key field in all linked tables and if you need the originial key fields, only keep them in one of the tables, where all values are stored.</P><P></P><P>Maybe it's easier to help you if you describe your model a bit closer.</P></BODY></HTML> Tue, 14 Mar 2017 20:20:39 GMT swuehl 2017-03-14T20:20:39Z AutoNumberHash128 to Eliminate Synthetic Keys https://community.qlik.com/t5/QlikView/AutoNumberHash128-to-Eliminate-Synthetic-Keys/m-p/1290130#M403512 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have a synthetic table in my dashboard that has 2 dimensions - CourseId and ClassId. Can I use <SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: blue;">AutoNumberHash128</SPAN><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: black;">(</SPAN><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: maroon;">Field1</SPAN><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: black;">&amp;</SPAN><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: maroon;">Field2</SPAN><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: black;">&amp;) </SPAN><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: blue;">AS</SPAN> <SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: maroon;">New Field</SPAN><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: black;"> </SPAN>in my script to get rid of synthetic table and expect the dashboard to function correctly when a user filters the dashboard by CourseId and ClassId?</P><P></P><P>Kindly suggest!</P><P></P><P>Thanks!</P></BODY></HTML> Tue, 14 Mar 2017 19:51:49 GMT https://community.qlik.com/t5/QlikView/AutoNumberHash128-to-Eliminate-Synthetic-Keys/m-p/1290130#M403512 2017-03-14T19:51:49Z Re: AutoNumberHash128 to Eliminate Synthetic Keys https://community.qlik.com/t5/QlikView/AutoNumberHash128-to-Eliminate-Synthetic-Keys/m-p/1290131#M403513 <HTML><HEAD></HEAD><BODY><P>A synthetic key is linking two or more tables. You would need to create the new key field in all linked tables and if you need the originial key fields, only keep them in one of the tables, where all values are stored.</P><P></P><P>Maybe it's easier to help you if you describe your model a bit closer.</P></BODY></HTML> Tue, 14 Mar 2017 20:20:39 GMT https://community.qlik.com/t5/QlikView/AutoNumberHash128-to-Eliminate-Synthetic-Keys/m-p/1290131#M403513 swuehl 2017-03-14T20:20:39Z