Qlik Community

QlikView Publisher

Discussion Board for collaboration on QlikView Publisher.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

How to Export QlikView Objects like Pivot,Straight Tables into Excel

Hi Friends we have a Crucial Requirement to Export QlikView Objects to Excel,while normally exporting to excel all Values are coming in a single table.While looking into Excel it is not capturing  Exact Format of QlikView.

1)How to solve Exporting QlikView objects problem please dont suggest Macros.Please tell is there any possiblity with 3rd party tool.

2)We have Publisher for Organization we need to send Reports in pdf format in Dynamic way.Generating reports with Publisher is best approach or else we need to go for Nprinting like 3 rd Party tools.

Waiting for best solution

Tags (2)
12 Replies
Highlighted

Re: How to Export QlikView Objects like Pivot,Straight Tables into Excel

Hi Srikath Readdy,

Sorry, go with NPrinting tool this will serve all your need 

Can I apply Excel formatting to my Excel reports? – Customer Feedback for Vizubi

Highlighted
Not applicable

Re: How to Export QlikView Objects like Pivot,Straight Tables into Excel

Hi Srikanth,

Right Click on the object You want to Export.

> Copy to Clipboard

> Object/Full Table/ Cell Value

Open a Plain Excel Sheet

>Ctrl+V

This will export Your Object to Excel

Warm Regards,

Joshmi

Highlighted
Contributor
Contributor

Re: How to Export QlikView Objects like Pivot,Straight Tables into Excel

Hi,

Not sure if  I understand you correctly. If you want to export objects to excel and not able to do it in a normal way,  you can try creating a button and writing an Action/trigger on it.

About printing reports in pdf format, I think Nprinting is a good option.

Hope this helps!


Highlighted
Not applicable

Re: How to Export QlikView Objects like Pivot,Straight Tables into Excel

what is main difference of using QlikView Distribution and Nprinting?

pros and cons of each individuals

-->Exporting Qlikview objects into  Excel is there any best way then above solutions.If so please guide into it

Highlighted
Contributor
Contributor

Re: How to Export QlikView Objects like Pivot,Straight Tables into Excel

Sorry but I am not an expert on Nprinting.

Although, I found something on community which may help you in deciding whether to go for Nprinting or not.

http://community.qlik.com/message/635295

Hope this helps!

Highlighted

Re: How to Export QlikView Objects like Pivot,Straight Tables into Excel

"Excel not capturing exact format of QlikView" is not always true. It depends on when your are exporting what from which client. Also, QlikView will only export to .XLS format (BIFF) which brings its own set of limitations. Values and dates will survive the transfer just fine, if your regional settings in both products are the same.

I don't know if this is a problem for you, but "exporting to excel all Values are coming in a single table" seems perfectly logical to me for a single QV object. If you want to export multiple objects on a sheet to a single Excel worksheet, then you'll have to use either a macro or an external tool.

In addition to wat S P said about NPrinting being the right tool for automatically creating and distributing PDF documents, this tool is also able to export to Excel with filtering and formatting, optionally putting multiple objects on a single sheet or even collecting objects from multiple QV documents onto the same sheet. It also outputs to Word and PowerPoint with the same ease. Moreover, NPrinting is a solid product that has proven its worth in Enterprise Environments.

Peter

Highlighted

Re: How to Export QlikView Objects like Pivot,Straight Tables into Excel

Hi srikanth,

NPrinting is a third party tool, which is used to export Qlikview reports into other formats like word,excel, image, Html, ppt etc. Using this tool you can send the Qlikview reports directly to clients periodically so need to visit the Qlikview dashboard again and again to generate required reports 

Highlighted
Partner
Partner

Re: How to Export QlikView Objects like Pivot,Straight Tables into Excel

Hi, Avinash.

Do you mean 'no need to visit' rather than 'need to visit' ?

Cheers,

Neil

Highlighted

Re: How to Export QlikView Objects like Pivot,Straight Tables into Excel

Hello,

I've been working with NPrinting for a couple of month now and I must say it's a superb tool. The features and performance are way beyond my expectations so I recommend you to try it. (it comes with a 14 days trail period if I'm not complete wrong). Also you have the full toolbox from both Excel, Word and PowerPoint when you create the reports.

No more macros that doesn't work every day, no more trying to create reports that changes every time they are generated.

Buy it, use it, love it!

//Stellan