I was able to load data from excel sheet which was in share point but was not able to do that in server.
I try to find solution in community but i did not see anyone had a good documentation on how to do this. So here are some step that i did to read Data from SharePoint into Qlikview
1 Add Qservice in Folder level in sharePoint ( Give read permission)
2 Copy the URL from SharePoint file Property and if the URL need authentication .pass your user name and password threw URL.