topic Re: Exporting two straight tables on excel same sheet in QlikView

Exporting two straight tables on excel same sheet

Fri, 20 Nov 2020 18:02:30 GMT

Hi,

I want to add a functionality that would allow exporting two straight tables on excel same sheet. If that is not possible on same excel but different sheet is second preferred option. Both the straight tables are on same tab. Any thoughts on this?

Re: Exporting two straight tables on excel same sheet

lironbaram — Wed, 14 Oct 2015 06:13:28 GMT

you'll need to write a macro in order to do so

as qlikview exports each object to a different file

you can try follow this example

QlikTip #32: Exporting multiple QV objects to a single Excel document

but i for one would rather not use macros because they are unstable.

your other option is to use nprinting which is qlik reporting tool

Re: Exporting two straight tables on excel same sheet

Wed, 14 Oct 2015 06:20:20 GMT

Hi,

Thanks for your reply.. However if I checked the second scenario i.e. if not in the same excel but diff sheet? In that case, do I need to use nprinting? or is there any way?

Re: Exporting two straight tables on excel same sheet

Chanty4u — Wed, 14 Oct 2015 06:20:29 GMT

hi,

Hope this link will helps you go through it.

Export two reports into 2 tabs of one excel

Re: Exporting two straight tables on excel same sheet

Wed, 14 Oct 2015 06:22:37 GMT

I dont want to export 2 repots, I want to export 2 straight table on same excel.. if not on the same tab then in diff tab.

Re: Exporting two straight tables on excel same sheet

lironbaram — Wed, 14 Oct 2015 06:25:41 GMT

as in the first answer in order to do either scenario 1 or 2

you can use either macro which is free of charge , and work most of the time

but not at all in ajax client

or using nprinting to do so

Re: Exporting two straight tables on excel same sheet

Chanty4u — Wed, 14 Oct 2015 06:26:48 GMT

use macros if not..

Useful Qlikview Macros

Re: Exporting two straight tables on excel same sheet

gautik92 — Wed, 14 Oct 2015 06:29:25 GMT

have a look at this

Re: Exporting two straight tables on excel same sheet

qlikviewwizard — Wed, 14 Oct 2015 06:41:47 GMT

You can get this by using macros.

Please check this thread.

Export two reports into 2 tabs of one excel

Re: Exporting two straight tables on excel same sheet

Wed, 14 Oct 2015 07:00:11 GMT

Check if its usefull http://www.qlikblog.at/971/qliktip-32-exporting-multiple-objects-single-excel-document/