topic How to Integrate Qlikview to Salesforce in QlikView

How to Integrate Qlikview to Salesforce

montubhardwaj — Thu, 02 Sep 2010 20:55:12 GMT

Can any one integrated Qlikview to salesforce to generate Reports & Dashboards? If anyone has done any short of experiment do share me the knowledge. Since I am longing for it for long time. My business need require more flexible and more user friendly BI, so that higher management user can drill down to the micro level detail of field users to understanding the progress and track the work of each user in detail.

The Qlikview for salesforce looks like as given below:

Dinesh Sharma

How to Integrate Qlikview to Salesforce

Thu, 02 Sep 2010 21:35:52 GMT

Dinesh,

The integration as shown is fairly easy. This is simply a QlikView application deployed via AJAX client, brought into Salesforce.com via Visualforce...in this case, the Visualforce iframe tag is used. Here is some sample code to get you started:

<pre><apex:page >
<iframe height="1000px" width="1200px" id="App Name" name="AppName" src="***Your AJAX URL Here**"></iframe>
</apex:page>

How to Integrate Qlikview to Salesforce

montubhardwaj — Thu, 02 Sep 2010 21:56:04 GMT

Hi Jason,

Thanks much for immediate response. I am basically a QV user but I am trying to integrate QV with cloud applications like Salesforece. Can you please tell me what "Your AJAX URL Here" means in the code ? How do we get this AJAX URL ?

Regards,

Dinesh

How to Integrate Qlikview to Salesforce

montubhardwaj — Fri, 03 Sep 2010 11:20:45 GMT

Hi Community, Any further input on this ?

Regards,

Dinesh

How to Integrate Qlikview to Salesforce

Mon, 09 Jan 2012 19:53:32 GMT

Yes - please, I'd be interested in this solution also.

I see in the appexchange there is a QV listing, with screens showing QV embedded in SF.

How to Integrate Qlikview to Salesforce

Ferran_Garcia_Pagans — Tue, 10 Jan 2012 09:46:33 GMT

To integrate a QV application in an IFrame you need to paste 'your AJX URL' in the source tag. Your AJAX url in the URL you use to open the application using the AJAX user interface (not the IE plug in).

1- Go to your QV access point and find your application.

2- You have 3 options: open the application using the IE Plugin, open then application using the AJAX user interface or donwload the application.

3- Put the mouse pointer in the second option and copy the url.

In this exaple 'your AJAX url' is http://localhost/QvAJAXZfc/AccessPoint.aspx?open=&id=Local%7CManufacturing%20Demo%20V3.qvw&client=Ajax

The result will be a iFrame in your web application that contains the QV Application including the QV menu.

Ferran.

Re: How to Integrate Qlikview to Salesforce

haggroth — Fri, 02 Mar 2012 14:22:30 GMT

There is also the possibility to display individual QlikView objects, and to pass parameters (selections) from Salesforce to Qlikview. This is done using singleobject.htm.

Here's some sample code for a visualforce page that passes the value of an account field to Qlikview (SFDC_Fieldname__c), makes a selection (in LB15) and displays a text box (TX63). Note that the value of the salesforce field must exist in the listbox.

<apex:page standardController="Account" id="XXXAccount" rendered="{!IF(Account.SFDC_Fieldname__c<>"",true, false)}"> <iframe src="http://servername/QvAJAXZfc/singleobject.htm?document=DocName.qvw&host=Local&object=TX63&select=LB15,{!Account.SFDC_Fieldname__c}" scrolling="false" id="accountSampleIframe" height="30px" width="300px" frameborder="false"/> </apex:page>

/Daniel

Re: How to Integrate Qlikview to Salesforce

Wed, 16 Jan 2013 15:19:10 GMT

Hi,

Thanks a lot for your post. Very helpful.

Do you have any expeirence with providing proper security to QlikView document, when opening it from SalesForce page.

Ideally, is there a way to pass SalesForce account details into QlikView doc and restrict the data by that?

Regards,

Igor

Re: How to Integrate Qlikview to Salesforce

Lee_Matthews — Wed, 10 Apr 2013 23:33:43 GMT

Hi Igor

Did you ever get a response to your post? There is an example here http://community.qlik.com/docs/DOC-3730 on how to configure single sign on between QlikView and Salesforce.

Regards

Lee

Re: How to Integrate Qlikview to Salesforce

Thu, 11 Apr 2013 08:03:56 GMT

Thank you very much, Lee.

I have found that article and already tried it.

Anyway thanks a lot and I guess sorry for not posting the link here.

Regards,

Igor

Re: How to Integrate Qlikview to Salesforce

Tue, 16 Apr 2013 13:25:01 GMT

Hi,

is it possible to lock the the listbox with the selected value?

Thanks

Re: How to Integrate Qlikview to Salesforce

Lee_Matthews — Tue, 16 Apr 2013 20:59:09 GMT

I don't believe it is possible to lock selections just using the URL. But it sounds like you want to force some sort of security over what data the user can see, which would be better done via section access.

Sent from my iPhone