export one pivot table to multiple excel files with other selections??

[#1]

Hi,

In my company i have different divisions and i was asked to add a button in qlikview that would export for each division an other excel file... is this possible?

my pivot table is like this: 'division' - 'financesource' - 'subdivision' - 'name employee' - 'money'. So i need excel files for each division, but i don't really know how to set other parameters in the macro... or do i need to make seperate tables for each division?

thx

[erichshiino]

Hi,

You need a macro with a loop to make selections and export excel files.

Please, check this thread:

http://community.qlik.com/forums/t/26622.aspx

You can adapt the code for your business needs.