Exporting to Excel ... with a twist

[#1]

Hi guys, looking for some help around this:

Example of my data table:

I display this with a pivot in qlikview:

Now i need to be able to export this to an excel sheet by use of a macro which is not the most difficult task, but i need it to do some fancy footwork, each Category must be exported to its own sheet in the workbook.

Example > Kitchen sheet will have to look like this:

Example > Linen sheet will have to look like this:

etc etc

Can somebody please help me with this?

[#2]

Create an excel macro to do the jiggery pokery and call that within the Qlikview Macro

[#3]

Unfrotunately it needs to be done by Qlikview

[tresesco]

Qlikview can't do it by it's own. There has to be a macro for that.

[#5]

Possible to give me an example using the data table i provided?

[struniger · Accepted solution]

Hi Ruan,

Here's a macro that will loop through a dimension, export a specific chart into excel, name the tab according to the chosen entry in the dimension and continue on.

http://community.qlik.com/docs/DOC-3481

Good luck

Stefan

[#7]

That is perfect! Thanx alot!