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

Mon, 28 Mar 2011 06:58:45 GMT

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

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

erichshiino — Sat, 16 Apr 2011 04:03:54 GMT

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.

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

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

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