Export simultaneously in excel

[#1]

hello.

I need your help.

I attached an example on that discussion.(qvw file), and the final ouput i need(xls file)

I will explain you how it have to work.

I need to export simultaneously (with one or two buttons)

1) the Country name in the first sheet (with all the details),

2) and then starting from the second sheet the City name with the details.

I think it's better if you open the file xls to get it.

The xls file name should be the same of the country.

So i will have:

Italy.xls,

Spain.xls,

France.xls,

UK.xls,

German.xls

Hoping you can help me and u understood me.

Regards

[#2]

Please note that this is not possible to be done out of the box by QlikView, but you can write a macro to apply this.

Please see this blog by an internal colleague of Qlik: http://www.qlikblog.at/971/qliktip-32-exporting-multiple-objects-single-excel-document/

This may help you get started.