You need to sign in to do that
Don't have an account?
w.mohan@isidsea.com
How to open a qlikview file from salesforce
Using Qlikview, I have created a file and saved on my machine with salesforce accounts and contacts data. How to write the script to open the file when I click a custom tab
I don't think you'll be able to do this. Most browsers will not allow the contents of a file on the users local file system to be accessed directly from the browser, as this is a huge security risk (essentially it would allow malicious javascript to pull back the contents of files at will). Also, even if you add a file URL to your web tab, a lot of browsers will block that too. For example, Mozilla browsers won't action file URLS from a page served via HTTP. They appear, but if you click on them nothing happens.
Is there a reason why you can't upload the file to Salesforce?
Hi Bob,
Thanks for your reply.
What I have done is from qlikview I login to salesforce apps to get the data from accounts table (for example) and I have saved into a .qvw file on my desktop. This file also contain the salesforce login details. This is from Qlikview to salesforce.
Then in salesforce create a page and a corresponding tab. Login to salesforce and click the tab the file saved on my desktop will be opened. I tried the below sample script in the page i created after making changes. This page supposed to open the file from the server, and after refreshing, i will get the updated dashboard with the latest info. not sure this is because I am using qlikview personal edition.
<apex:page >
<iframe height="1000px" width="1500px" id="<PageName>" name="<PageLabel>"
src="http://<AccessPointServer>/QvAJAXZfc/opendoc.htm?document=<account.qvw>&host=
AccessPoint%20Documents"></iframe>
</apex:page>
This is the syntax not working, This instruction I got from Qlikview setup and integration document
Thanks
The URL that you have posted above doesn't point to a file on your local filesystem though.
What happens if you simply try to open the URL via the browser without embedding it into a Visualforce page?
If i use the URL and open thru browser, the file is opened using qlikview directly
The same when I link thru salesforce, I only see a blank white screen within the salesforce.
A few things to try:
You will have to install qlik view app in ur salesforce from the app exchange- http://appexchange.salesforce.com/listingDetail?listingId=a0330000005lWE3AAM ..and i think u cannot use the .qvw file which is saved on ur machine in any salesforce org.. instead u can access data directly from salesforce after the installation (thru scripts in qlikview). And this is not free to install.. u have to buy it.
- Anil Valluri
I have to once again go to the Visualforce source code page and add the Ajax URL. C
Can someone help me with it.