topic Filtering data of Fact using fields of two Dim tables in QlikView https://community.qlik.com/t5/QlikView/Filtering-data-of-Fact-using-fields-of-two-Dim-tables/m-p/263075#M711415 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I've an requirement of filtering records of fact table by looking at relationship between 2 dimension tables.</P><P>I've attached the Excel file with this which contains the problem statement and the QVW with sample data.</P><P>Pleaes go through it and let me know how to do it in QlikView.</P></BODY></HTML> Fri, 03 Jun 2011 11:03:42 GMT AbhijitBansode 2011-06-03T11:03:42Z Filtering data of Fact using fields of two Dim tables https://community.qlik.com/t5/QlikView/Filtering-data-of-Fact-using-fields-of-two-Dim-tables/m-p/263075#M711415 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I've an requirement of filtering records of fact table by looking at relationship between 2 dimension tables.</P><P>I've attached the Excel file with this which contains the problem statement and the QVW with sample data.</P><P>Pleaes go through it and let me know how to do it in QlikView.</P></BODY></HTML> Fri, 03 Jun 2011 11:03:42 GMT https://community.qlik.com/t5/QlikView/Filtering-data-of-Fact-using-fields-of-two-Dim-tables/m-p/263075#M711415 AbhijitBansode 2011-06-03T11:03:42Z Filtering data of Fact using fields of two Dim tables https://community.qlik.com/t5/QlikView/Filtering-data-of-Fact-using-fields-of-two-Dim-tables/m-p/263076#M711416 <HTML><HEAD></HEAD><BODY><P>Abhjit,</P><P>Just include the date in the fact table and create a master calendar for the date selection.</P><P>There are several posts relating to calendars on this board.</P><P>Hope that helps</P></BODY></HTML> Fri, 03 Jun 2011 11:35:31 GMT https://community.qlik.com/t5/QlikView/Filtering-data-of-Fact-using-fields-of-two-Dim-tables/m-p/263076#M711416 2011-06-03T11:35:31Z