topic AVOIDING SYN TABLES. SELF JOINING TABLE in QlikView https://community.qlik.com/t5/QlikView/AVOIDING-SYN-TABLES-SELF-JOINING-TABLE/m-p/319713#M117827 <HTML><HEAD></HEAD><BODY><P><SPAN lang="EN-US" style="font-family: 'Arial','sans-serif'; color: #333333; font-size: 10pt;">Hi:</SPAN></P><P><SPAN lang="EN-US" style="font-family: 'Arial','sans-serif'; color: #333333; font-size: 10pt;"> </SPAN></P><P><SPAN lang="EN-US" style="font-family: 'Arial','sans-serif'; color: #333333; font-size: 10pt;">I have a <STRONG>self joining </STRONG>table that I want to load in QV associative way. The result is that I get 7 syn. tables from only 3 tables and I think that is too much. Can anyone help me?</SPAN></P><P><SPAN lang="EN-US" style="font-family: 'Arial','sans-serif'; color: #333333; font-size: 10pt;">I’m attaching exact example. </SPAN></P><P><SPAN lang="EN-US" style="font-family: 'Arial','sans-serif'; color: #333333; font-size: 10pt;"> </SPAN></P><P><SPAN lang="EN-US" style="font-family: 'Arial','sans-serif'; color: #333333; font-size: 10pt;">Self joining explanation.</SPAN></P><P><SPAN lang="EN-US" style="font-family: 'Arial','sans-serif'; color: #333333; font-size: 10pt;"> </SPAN></P><P><SPAN lang="EN-US" style="font-family: 'Arial','sans-serif'; color: #333333; font-size: 10pt;">When nivelzona = 1, then zona = zona</SPAN></P><P><SPAN lang="EN-US" style="font-family: 'Arial','sans-serif'; color: #333333; font-size: 10pt;"><SPAN lang="EN-US" style="font-family: 'Arial','sans-serif'; color: #333333; font-size: 10pt;">When nivelzona = 2, then zona = sector</SPAN></SPAN></P><P><SPAN lang="EN-US" style="font-family: 'Arial','sans-serif'; color: #333333; font-size: 10pt;"><SPAN lang="EN-US" style="font-family: 'Arial','sans-serif'; color: #333333; font-size: 10pt;"><SPAN lang="EN-US" style="font-family: 'Arial','sans-serif'; color: #333333; font-size: 10pt;">When nivelzona = 3, then zona = base</SPAN></SPAN></SPAN></P><P><SPAN lang="EN-US" style="font-family: 'Arial','sans-serif'; color: #333333; font-size: 10pt;"><SPAN lang="EN-US" style="font-family: 'Arial','sans-serif'; color: #333333; font-size: 10pt;"><SPAN lang="EN-US" style="font-family: 'Arial','sans-serif'; color: #333333; font-size: 10pt;"> </SPAN></SPAN></SPAN></P><P><SPAN lang="EN-US" style="font-family: 'Arial','sans-serif'; color: #333333; font-size: 10pt;"><SPAN lang="EN-US" style="font-family: 'Arial','sans-serif'; color: #333333; font-size: 10pt;"><SPAN lang="EN-US" style="font-family: 'Arial','sans-serif'; color: #333333; font-size: 10pt;">Thanks.</SPAN></SPAN></SPAN></P></BODY></HTML> Fri, 24 Jun 2011 13:07:48 GMT christian77 2011-06-24T13:07:48Z AVOIDING SYN TABLES. SELF JOINING TABLE https://community.qlik.com/t5/QlikView/AVOIDING-SYN-TABLES-SELF-JOINING-TABLE/m-p/319713#M117827 <HTML><HEAD></HEAD><BODY><P><SPAN lang="EN-US" style="font-family: 'Arial','sans-serif'; color: #333333; font-size: 10pt;">Hi:</SPAN></P><P><SPAN lang="EN-US" style="font-family: 'Arial','sans-serif'; color: #333333; font-size: 10pt;"> </SPAN></P><P><SPAN lang="EN-US" style="font-family: 'Arial','sans-serif'; color: #333333; font-size: 10pt;">I have a <STRONG>self joining </STRONG>table that I want to load in QV associative way. The result is that I get 7 syn. tables from only 3 tables and I think that is too much. Can anyone help me?</SPAN></P><P><SPAN lang="EN-US" style="font-family: 'Arial','sans-serif'; color: #333333; font-size: 10pt;">I’m attaching exact example. </SPAN></P><P><SPAN lang="EN-US" style="font-family: 'Arial','sans-serif'; color: #333333; font-size: 10pt;"> </SPAN></P><P><SPAN lang="EN-US" style="font-family: 'Arial','sans-serif'; color: #333333; font-size: 10pt;">Self joining explanation.</SPAN></P><P><SPAN lang="EN-US" style="font-family: 'Arial','sans-serif'; color: #333333; font-size: 10pt;"> </SPAN></P><P><SPAN lang="EN-US" style="font-family: 'Arial','sans-serif'; color: #333333; font-size: 10pt;">When nivelzona = 1, then zona = zona</SPAN></P><P><SPAN lang="EN-US" style="font-family: 'Arial','sans-serif'; color: #333333; font-size: 10pt;"><SPAN lang="EN-US" style="font-family: 'Arial','sans-serif'; color: #333333; font-size: 10pt;">When nivelzona = 2, then zona = sector</SPAN></SPAN></P><P><SPAN lang="EN-US" style="font-family: 'Arial','sans-serif'; color: #333333; font-size: 10pt;"><SPAN lang="EN-US" style="font-family: 'Arial','sans-serif'; color: #333333; font-size: 10pt;"><SPAN lang="EN-US" style="font-family: 'Arial','sans-serif'; color: #333333; font-size: 10pt;">When nivelzona = 3, then zona = base</SPAN></SPAN></SPAN></P><P><SPAN lang="EN-US" style="font-family: 'Arial','sans-serif'; color: #333333; font-size: 10pt;"><SPAN lang="EN-US" style="font-family: 'Arial','sans-serif'; color: #333333; font-size: 10pt;"><SPAN lang="EN-US" style="font-family: 'Arial','sans-serif'; color: #333333; font-size: 10pt;"> </SPAN></SPAN></SPAN></P><P><SPAN lang="EN-US" style="font-family: 'Arial','sans-serif'; color: #333333; font-size: 10pt;"><SPAN lang="EN-US" style="font-family: 'Arial','sans-serif'; color: #333333; font-size: 10pt;"><SPAN lang="EN-US" style="font-family: 'Arial','sans-serif'; color: #333333; font-size: 10pt;">Thanks.</SPAN></SPAN></SPAN></P></BODY></HTML> Fri, 24 Jun 2011 13:07:48 GMT https://community.qlik.com/t5/QlikView/AVOIDING-SYN-TABLES-SELF-JOINING-TABLE/m-p/319713#M117827 christian77 2011-06-24T13:07:48Z AVOIDING SYN TABLES. SELF JOINING TABLE https://community.qlik.com/t5/QlikView/AVOIDING-SYN-TABLES-SELF-JOINING-TABLE/m-p/319714#M117828 <HTML><HEAD></HEAD><BODY><P>Ok, someone solved it for me using the function Hierarchy.</P></BODY></HTML> Mon, 27 Jun 2011 16:33:31 GMT https://community.qlik.com/t5/QlikView/AVOIDING-SYN-TABLES-SELF-JOINING-TABLE/m-p/319714#M117828 christian77 2011-06-27T16:33:31Z