topic How to apply filter on Fact table and export to excel in QlikView https://community.qlik.com/t5/QlikView/How-to-apply-filter-on-Fact-table-and-export-to-excel/m-p/268037#M1178348 <HTML><HEAD></HEAD><BODY><P>My data model contains huge fact table, I am planning to export that facts to excel but because of huge data I am unable to do that. How can I apply filter on fact table and then export to Excel.</P></BODY></HTML> Thu, 09 Feb 2012 14:52:11 GMT 2012-02-09T14:52:11Z How to apply filter on Fact table and export to excel https://community.qlik.com/t5/QlikView/How-to-apply-filter-on-Fact-table-and-export-to-excel/m-p/268037#M1178348 <HTML><HEAD></HEAD><BODY><P>My data model contains huge fact table, I am planning to export that facts to excel but because of huge data I am unable to do that. How can I apply filter on fact table and then export to Excel.</P></BODY></HTML> Thu, 09 Feb 2012 14:52:11 GMT https://community.qlik.com/t5/QlikView/How-to-apply-filter-on-Fact-table-and-export-to-excel/m-p/268037#M1178348 2012-02-09T14:52:11Z How to apply filter on Fact table and export to excel https://community.qlik.com/t5/QlikView/How-to-apply-filter-on-Fact-table-and-export-to-excel/m-p/268038#M1178349 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>There's a lot of ways to do that, but depends on wich dimension you want to filter on. Please explain further...</P><P></P><P></P><P>Best regards</P><P>Torbjörn Ungavll (@Ungvall)</P><P>Senior Business Discovery Manager @ Advectas AB</P></BODY></HTML> Thu, 09 Feb 2012 17:47:13 GMT https://community.qlik.com/t5/QlikView/How-to-apply-filter-on-Fact-table-and-export-to-excel/m-p/268038#M1178349 2012-02-09T17:47:13Z How to apply filter on Fact table and export to excel https://community.qlik.com/t5/QlikView/How-to-apply-filter-on-Fact-table-and-export-to-excel/m-p/268039#M1178350 <HTML><HEAD></HEAD><BODY><P>I have Year Dimension, How can I use on year dimension and I nedd all the fact table fields to be filtered.</P></BODY></HTML> Thu, 09 Feb 2012 18:12:21 GMT https://community.qlik.com/t5/QlikView/How-to-apply-filter-on-Fact-table-and-export-to-excel/m-p/268039#M1178350 2012-02-09T18:12:21Z How to apply filter on Fact table and export to excel https://community.qlik.com/t5/QlikView/How-to-apply-filter-on-Fact-table-and-export-to-excel/m-p/268040#M1178351 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>If you publish a listbox with your year dimension, and select a year, then QlikView will by default filter all other post that not have a relation to the slected year. Publish all the fields from your fact table that you want, in an table box or a straight table and export to Excel.</P><P>If this doesn't help - please elaborate explanation...</P><P></P><P></P><P style="background-color: #ffffff; font-size: 12px; color: #636363; font-family: Arial;">Best regards</P><P style="background-color: #ffffff; font-size: 12px; color: #636363; font-family: Arial;">Torbjörn Ungavll (@Ungvall)</P><P style="background-color: #ffffff; font-size: 12px; color: #636363; font-family: Arial;">Senior Business Discovery Manager @ Advectas AB</P></BODY></HTML> Thu, 09 Feb 2012 19:23:00 GMT https://community.qlik.com/t5/QlikView/How-to-apply-filter-on-Fact-table-and-export-to-excel/m-p/268040#M1178351 2012-02-09T19:23:00Z How to apply filter on Fact table and export to excel https://community.qlik.com/t5/QlikView/How-to-apply-filter-on-Fact-table-and-export-to-excel/m-p/268041#M1178352 <HTML><HEAD></HEAD><BODY><P>Tq so much.</P></BODY></HTML> Thu, 09 Feb 2012 19:30:29 GMT https://community.qlik.com/t5/QlikView/How-to-apply-filter-on-Fact-table-and-export-to-excel/m-p/268041#M1178352 2012-02-09T19:30:29Z