Skip to main content
Announcements
Qlik Community Office Hours - Bring your Ideation questions- May 15th, 11 AM ET: REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Writting data from Qlikview to SharePoint

Please assist me here:

I have data from sharepoint that i'm putting in Qlikview. The users enter data into an excel sheet in sharepoint and i read it into Qlikview.

That data is matched against payments in Qlikview to check what has been paid and what has not been paid .

After getting what has not been paid, the user requested that we write back what has not been paid back to the excel sheet in sharepoint

Is it possible to write back that information to Sharepoint?

2 Replies
avinashelite

You can but you need to make this through MACRO code, we don't have direct option in Qlikview to do this You need to have rite permissions also

Not applicable
Author

The one possible option access the SharePoint site data through network drive and store the file into csv format.

1. Create sample csv on the Sharepoint site.

2. Enable the both Read & Write access to qlik service accounts

3. Please enable the network path access to share point site data (you may get \\myteamsite\WWRoot\dev\......)

4. Use store function to store back into SharePoint network drive path

     STORE TransTable into [\\myteamsite\WWRoot\Project\data\NotPayment.csv] (txt)