I have a Qlikview application that has several charts, in particular CH10, that are pivot tables. I have a Company list box with all my companies 180, 160, etc. I click 180 to get the information in CH10 to populate.
I then go to Qlikview Designer, add a connection to the .QVW, and click 'Reports' to create an Excel report.
I add the table to excel in designer, and I preview it. All of the information in CH10 is visible even though I ONLY wanted Company 180 to show up.