Exporting two straight tables on excel same sheet

[#1]

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?

[lironbaram · Accepted solution]

hi

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

[#3]

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?

[Chanty4u]

hi,

Hope this link will helps you go through it.

Export two reports into 2 tabs of one excel

[#5]

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.

[lironbaram]

hi

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

[Chanty4u]

use macros if not..

Useful Qlikview Macros

[gautik92]

have a look at this

[qlikviewwizard]

You can get this by using macros.

Please check this thread.

Export two reports into 2 tabs of one excel

[#10]

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