Skip to main content
Announcements
Qlik Connect 2025: 3 days of full immersion in data, analytics, and AI. May 13-15 | Orlando, FL: Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
stevenhans
Contributor
Contributor

Unable to Export & Import Data from Chart into CSV from AccessPoint

Hi All,

I have a question for exporting chart data (Pivot Table) and importing the data again to produce a summary from that chart.

The problem is, I use button to Run the Macro and I've already tested it on my Qlikview Desktop and the file is generated. But when I access the document from the web and clicked the button. The button works but no file was generated.

Can anyone help me with this?

 

This is the macro that I used:

Spoiler
sub ExportTable
output_dir="\\BI-03\E$\Qlik_View\PROD\EXPORT\Sales\20 20\"
Filename="40 20.txt"
set obj = ActiveDocument.GetSheetObject("POPA")
obj.Export (output_dir & Filename) , "|"

end sub

 

I've already done this as well:

In the Edit Module section this macro is in, I set the following fileds;
Requested Module Security: System Access
Current Local Security: Allow System Access

I then setup security Settings on the Qlikview Management Server.
[System] tab->[Setup] subtab->Select Server from the list.
[Security] tab on the server.
[Tick] Allow macro execution on server 
[Tick] Allow unsafe macro execution on server
Clicked [Apply]

 

 

Labels (4)
3 Replies
jonathandienst
Partner - Champion III
Partner - Champion III

In access point, the macro runs i=under the credentials of the QV service account. This means that the service account needs access to whatever resources the macro uses and it needs the AD rights to execute batch files (ie not restricted in AD to services only).

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
stevenhans
Contributor
Contributor
Author

Thank you  Jontydkpi for the answer.

Can you provide me the example (Screenshot) to how to do this?

We are using Custom Directory and not Active Directory(AD) on QlikView.

Is there a solution for this? I don't know how to give permission to the Custom Directory .

Brett_Bleess
Former Employee
Former Employee

I am not sure this is a permission issue, I think the macro is likely using the incorrect API for export in this case, you need to be sure the API is changed to the ServerSideExportEx, believe that may do the trick for you.

Regards,
Brett

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.