topic Re: How to export data into excel from dasboard and store it on sharepoint in Qlik NPrinting

How to export data into excel from dasboard and store it on sharepoint

kvr9 — Wed, 20 Jun 2018 08:23:11 GMT

Hello Experts, I have a requirement where the data in one of the table in the qlikview dashboard need to be exported into a excel and store it on a share point path.Condition is it needs to be updated every week probably on Friday and the sheet should contain the weekly data for comparison so the user can give their comments in the sheet. Could someone help me out to identify solution for it.

Thanks,

Vijaya

Re: How to export data into excel from dasboard and store it on sharepoint

manoj217 — Wed, 20 Jun 2018 11:56:04 GMT

use the store tablename into path\file.xls (Xls);

Re: How to export data into excel from dasboard and store it on sharepoint

kvr9 — Thu, 21 Jun 2018 09:10:51 GMT

Hi Manoj,

Thank you for your response.

As I'm new to qlikview,Could you please elaborate it where I have to give this syntax

Thanks,

Vijaya

Re: How to export data into excel from dasboard and store it on sharepoint

manoj217 — Tue, 26 Jun 2018 06:23:53 GMT

In edit script you have your updated table.

there you have to write a store command as i mentioned in above.

Re: How to export data into excel from dasboard and store it on sharepoint

Lech_Miszkiewicz — Tue, 26 Jun 2018 23:42:46 GMT

you are wrong Manoj! manoj217 - there is not such thing like store to XLS in Qlik script and you will get error

you can only store to qvd or text files (like csv or delimited files) which is different to what you are writing...

Also - your data will not be aggregated to the level it could be required (as UI mainly does aggregation)

This is where you would use NPrinting tool. However to give you steps how to produce Excel report in NPrinting would take me ages as it highly advanced separate tool.

Go to google and type: "How to build Excel reports in NPrinitng" and you will get few video tutorials about NPrinitng and ecel capabilities.

If you have not used NPrinitng before - there is a lot to learn before you can start!

cheers

Lech

Re: How to export data into excel from dasboard and store it on sharepoint

manoj217 — Wed, 27 Jun 2018 06:40:17 GMT

try this

Lech Miszkiewicz

STORE MyTable into Export.xls (txt);

it will store the table in excel file

Re: How to export data into excel from dasboard and store it on sharepoint

manoj217 — Wed, 27 Jun 2018 06:43:08 GMT

if your data have in qlik objects there you have a export option. you can save the data in excel file

Re: How to export data into excel from dasboard and store it on sharepoint

Lech_Miszkiewicz — Wed, 27 Jun 2018 06:52:23 GMT

that is not correct mate manoj217‌

I agree that it will create a text file with xls extension and script will not fail BUT this however is not an excel file!!!

It is a TEXT File

see screenshots below - it is comma delimited text file with xls extension...

but as soon as you try use excel type you will get error

Re: How to export data into excel from dasboard and store it on sharepoint

Lech_Miszkiewicz — Wed, 27 Jun 2018 07:04:15 GMT

manoj217‌

Manoj - please read the question of the topic and If you know the answer please provide a valuable steps how to achieve what the author of the topic asked for.

So far you have provided misleading information. Your above mentioned functionality is: "Send to Excel" manual function and does not meet expected criteria.

If you have end to end solution of grabbing a QlikObject - exporting data from it to excel and putting it on Sharepoint location in automated way - please provide those detailed steps - would you?

I understand that solution does not have to be done via NPrinintg tool and can be achieved for example with use of QlikView macro, but this would require a custom built solution.

In the future I would reconsider posting misleading information!

cheers

Lech

Re: How to export data into excel from dasboard and store it on sharepoint

BalaBhaskar_Qlik — Thu, 28 Jun 2018 17:18:19 GMT

May be check the below links:

https://help.qlik.com/en-US/nprinting/June2017/Content/ExcelReports/Intro-Excel.htm

https://help.qlik.com/en-US/nprinting/June2017/Content/DistributionSchedulesAutomation/Schedule.htm

https://help.qlik.com/en-US/nprinting/June2017/Content/AdministeringQVNprinting/SetFolderDestination/Folder-destination.htm

https://help.qlik.com/en-US/nprinting/April2018/Content/AdministeringQVNprinting/Import-export-report-from-different-NP-environments.htm