topic Re: Exporting to Excel ... with a twist in QlikView

Exporting to Excel ... with a twist

Fri, 16 May 2014 13:34:14 GMT

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?

Re: Exporting to Excel ... with a twist

Fri, 16 May 2014 13:39:45 GMT

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

Re: Exporting to Excel ... with a twist

Mon, 19 May 2014 06:02:01 GMT

Unfrotunately it needs to be done by Qlikview

Re: Exporting to Excel ... with a twist

tresB — Mon, 19 May 2014 06:06:43 GMT

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

Re: Exporting to Excel ... with a twist

Mon, 19 May 2014 06:33:14 GMT

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

Re: Exporting to Excel ... with a twist

struniger — Mon, 19 May 2014 06:40:06 GMT

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

Re: Exporting to Excel ... with a twist

Mon, 19 May 2014 06:58:56 GMT

That is perfect! Thanx alot!