topic Loop in the DB structure in QlikView https://community.qlik.com/t5/QlikView/Loop-in-the-DB-structure/m-p/1078295#M359589 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have an issue,</P><P></P><P>I have several big tables that can't be concatenated (because they are too big):</P><P></P><P>Table1</P><P>RegionA</P><P>YearA</P><P>MonthA</P><P>DimA</P><P>DimB</P><P>DimC</P><P></P><P>Table2</P><P>RegionB</P><P>YearB</P><P>MonthB</P><P>DimD</P><P>DimE</P><P>DimF</P><P></P><P>I want to create a common filter to be able to select the region, the year, the month for both of the tables.</P><P></P><P>If I use a Third&nbsp; table (inline) like this to create a link between the tables it works:</P><P></P><P>MasterFilterYear:</P><P>MasterYear, YearA, YearB</P><P>2015, 2015, 2015</P><P>2016, 2016, 2016</P><P></P><P>But if I do an other one for Region it creates a loop in the structure:</P><P></P><P>MasterFilterRegion:</P><P>MasterRegion, RegionA, RegionB</P><P>Asia, Asia, Asia,</P><P>America, America, America</P><P></P><P>Can you help me to create this "Master Filter" please ? Thanks</P></BODY></HTML> Thu, 21 Apr 2016 14:13:44 GMT 2016-04-21T14:13:44Z Loop in the DB structure https://community.qlik.com/t5/QlikView/Loop-in-the-DB-structure/m-p/1078295#M359589 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have an issue,</P><P></P><P>I have several big tables that can't be concatenated (because they are too big):</P><P></P><P>Table1</P><P>RegionA</P><P>YearA</P><P>MonthA</P><P>DimA</P><P>DimB</P><P>DimC</P><P></P><P>Table2</P><P>RegionB</P><P>YearB</P><P>MonthB</P><P>DimD</P><P>DimE</P><P>DimF</P><P></P><P>I want to create a common filter to be able to select the region, the year, the month for both of the tables.</P><P></P><P>If I use a Third&nbsp; table (inline) like this to create a link between the tables it works:</P><P></P><P>MasterFilterYear:</P><P>MasterYear, YearA, YearB</P><P>2015, 2015, 2015</P><P>2016, 2016, 2016</P><P></P><P>But if I do an other one for Region it creates a loop in the structure:</P><P></P><P>MasterFilterRegion:</P><P>MasterRegion, RegionA, RegionB</P><P>Asia, Asia, Asia,</P><P>America, America, America</P><P></P><P>Can you help me to create this "Master Filter" please ? Thanks</P></BODY></HTML> Thu, 21 Apr 2016 14:13:44 GMT https://community.qlik.com/t5/QlikView/Loop-in-the-DB-structure/m-p/1078295#M359589 2016-04-21T14:13:44Z Re: Loop in the DB structure https://community.qlik.com/t5/QlikView/Loop-in-the-DB-structure/m-p/1078296#M359590 <HTML><HEAD></HEAD><BODY><P>I just made an outer join between my main filter tables:</P><P></P><P>MasterFilterYear</P><P>MasterFilterRegion</P><P>MasterFilterMonth</P><P></P><P>It works. But is it a good practice ?</P></BODY></HTML> Thu, 21 Apr 2016 14:26:38 GMT https://community.qlik.com/t5/QlikView/Loop-in-the-DB-structure/m-p/1078296#M359590 2016-04-21T14:26:38Z