Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

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

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

1 Reply
erichshiino
Partner - Master
Partner - Master

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.