Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
montubhardwaj
Valued Contributor

How to Integrate Qlikview to Salesforce

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:

error loading image

Dinesh Sharma

11 Replies
Not applicable

How to Integrate Qlikview to Salesforce

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><apexSmiley Tongueage >
<iframe height="1000px" width="1200px" id="App Name" name="AppName" src="***Your AJAX URL Here**"></iframe>
</apexSmiley Tongueage>


montubhardwaj
Valued Contributor

How to Integrate Qlikview to Salesforce

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

montubhardwaj
Valued Contributor

How to Integrate Qlikview to Salesforce

Hi Community, Any further input on this ?

Regards,

Dinesh

Not applicable

How to Integrate Qlikview to Salesforce

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. 

Employee
Employee

How to Integrate Qlikview to Salesforce

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.

test.png

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

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

Ferran.

haggroth
New Contributor II

Re: How to Integrate Qlikview to Salesforce

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.

<apexSmiley Tongueage 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"/>  </apexSmiley Tongueage>

/Daniel

Not applicable

Re: How to Integrate Qlikview to Salesforce

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

Employee
Employee

Re: How to Integrate Qlikview to Salesforce

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

Not applicable

Re: How to Integrate Qlikview to Salesforce

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

Community Browser