topic Re: How to export tables from multiple tabs to one excel sheet? in QlikView

How to export tables from multiple tabs to one excel sheet?

chiranjivdas — Tue, 21 Oct 2014 17:16:35 GMT

I have three tabs and each tab has one object each that needs to be exportable by the user (there are other objects in tabs like current selections, filter multi-box, clear button, text boxes, etc that I do not want the user to export)

I want the following to be exportable at once without having to export them individually

Tab 1: CH01

Tab 2: CH02

Tab 3: CH03

I want the user to be able to export all three objects to an excel at once. When these get exported to excel, I want them to appear in separate tabs on the Excel file. So, CH01 should be in Sheet1, CH02 in Sheet2 and CH03 in Sheet3 of the excel file.

Is this possible to do? If so, how?

Thanks,

Re: How to export tables from multiple tabs to one excel sheet?

kuba_michalik — Tue, 21 Oct 2014 17:30:07 GMT

Only with a macro, I think. But if you are not familiar with VBScript macros already, it might be a tad difficult. Also, I think it would have to be an unsafe macro, so the user will get warnings every time they open the QV app, and I'm not sure if it would work via the AJAX client at all.

Re: How to export tables from multiple tabs to one excel sheet?

Anonymous — Tue, 21 Oct 2014 20:55:29 GMT

Another option would be NPrinting by Vizubi. We use it here. It's a tad intimidating at first but you can quickly get a handle on it. If you need to do what you're suggesting in your post, you'll likely need it in the future for doing something else.

Re: How to export tables from multiple tabs to one excel sheet?

ecolomer — Tue, 21 Oct 2014 20:58:59 GMT

here you have some examples

Re: How to export tables from multiple tabs to one excel sheet?

kuba_michalik — Tue, 21 Oct 2014 21:00:20 GMT

Yeah, NPrinting is nice. And it's on demand functionality is actually designed for Ajax, being based around extensions.