Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Accessing QV application in Java Web application

Hi Everyone,

I am launching the qlikview application in

java webapplication using  netbeans running on tomcat server.

Using the URL

"http://Servername/QvAJAXZfc/opendoc.htm?document=Whats%20New%20in%20QlikView11.qvw&host=hostname"

in iframe i was able to open the QVapplication.

But i have list of qlikview applications

assigned to particular users(Domain users) which

i have to map in my application such that,

User who is accessing the Javawebapplication

should be able to open the qlikview application

without entering userid and password.

How this can be achieved?

Is it possible to pass the userid and password in the URL?

I have attached the Screenshot doc and the sample java script file.

Thanks in Advance,

Nikitha Jain M.B

10 Replies
Not applicable
Author

Hi,

There is something known as Web Ticketing in Qlikview. You can search the forum for that.

ergustafsson
Partner - Specialist
Partner - Specialist

Hi!

See attached, it should help you.

This war-archive contains a small application based on the Grails framework. It has one simple Domain class "Customer" and is meant as a show case for the web ticket integration of QlikView. It can be used as is for a default QlikView installtion because it shows the Sales Compass embedded inside an iframe to the customer.
Deploy it to your Tomcat (tested with TC 7) and edit the file web-apps/QlikView/WEB-INF/classes/QlikView-config.properties in order to match your QVWS/IIS IP-address and the custom/<username> of the user that is allowed to open Sales Compass.qvw.


Regards,

Erik

Not applicable
Author

Hi Erik,

Thank you for your reply .

Actually i tried to open the war file by changing the extension to Zip and try to Extract i am getting the error as archive is in unknown format or it is damaged , i also used rar extension its nt working.  So i rebuild the Zip File and open the contents and i tried to access this in Netbeans Using the "Web Application with Existing Source" option using tomcat server. But Cant able to run Successfully. I also tried with Import Zip file Option, But it throws error as "File damaged". I also made Changes in the Qlikview-Config.Properties.

So can u please guide Briefly how i can open in proper format and run successfully in Nebeans using Tomcat Serrver.

Thanks in Advance,

Nikitha Jain M.B

ergustafsson
Partner - Specialist
Partner - Specialist

Hi Nikitha,

.war is not the same thing as .zip or .rar. Changing the extension will not help you open it. Please see WAR (file format) - Wikipedia, the free encyclopedia for more information.

Regards,

Erik

Not applicable
Author

Hi Erik,

I want to implement, DIV integration with Qlikview into Java web application. Java application run on serverA whereas QVWS,QVS are on serverB. I was able to implement Webticket method to open any document using opendoc.htm through iFrames and/or displaying the report in separate tab on browser.

But I couldnt get handle on implementing DIV integration into Java web application and my below code is not working on my server, any idea/thought you can throw at me.

<!DOCTYPE html >

<head>

  <script language="javascript" type="text/javascript" src="http://<serverB>/QVAJAXZfc/htc/QvAjax.js"></script>

  <script language="javascript" type="text/javascript">

  var QvDoc_Tariff;

  var lb_Tariff_State;

  Init_Tariff = function ()

  {

  QvDoc_Tariff = Qv.GetDocument('TariffRates');

  lb_Tariff_State = QvDoc_Tariff.GetObject('Document\\LB57');

  }

  Clear_Tariff = function ()

  {

  QvDoc_Tariff.Clear();

  }

  Clear_Tariff_State = function () {

  lb_Tariff_State.Data.ClearSelections();

  }

    Qv.InitWorkBench(

                  { View: 'TariffRates'               

  , Host: "Customer"

  //, Anonymous: 'true'

  , Userid: "domain\user"

  , Password: "XXXXXXXXX"

  //, Ticket: "webticket"

 

  // Trigger Onload function

                         , BodyOnLoadFunctionNames: ['Init_Tariff'   // This will initialize global reference variables for objects

                             //,'Clear_Tariff'  // This will execute the command to clear the initial settings

  //,'Function3'

                             ]

  , InitialSelections: ["LB55,Interstate"

                       //"{object2},selection1,[selection2],[selectionX]"

                       ]

  , InlineStyle: true

  }

                 );

  // ======================

  // Qlikview LERG document

  // ======================

  var qvDoc_LERG;

  Init_LERG = function() {

  qvDoc_LERG = Qv.GetDocument('CUSTOMER\\CUSTOMER_LERG');

  }

  Clear_LERG = function() {

  qvDoc_LERG.Clear();

  }

    Qv.InitWorkBench(

                  { View: 'CUSTOMER\/CUSTOMER_LERG' 

  , Host: "Customer"

  //, Anonymous: 'true'

  , Userid: "domain\user"

  , Password: "XXXXXXXXX"

  //, Ticket: "webticket"

 

  // Trigger Onload function

                         , BodyOnLoadFunctionNames: ['Init_LERG'

                             ,'Clear_LERG'

                             ]

  }      );

  </script>

  <style>

  header  { background-color:#1B8066;

  color:white;

  text-align:left;

  padding:2px;

  }

  section { color:#035393;

  }

  .report { float: left;

  margin: 5px;

  padding: 0px;

  border: 5px solid black;

  }

    .QvInlineObject

  {

    position:relative;

    margin-left:0px;

    margin-right:0px;

    float:left;

  }

  </style>

</head>

<body>

  <header>

  <h1>Qlikview HTML</h1>

  </header>

  <section>

  <h1>Tariff Data</h1>

  <!--- Default sizes in the Tariff document is width=1210 and height=556 -->

  <!--- Though there is virtually no documentation that explains this, you *have* to include the id= in the DIV integration so that objects work together -->

        <div class="report">

  <div class="QvInlineObject" avqview="TariffRates" avq="object:.Document\LB57" id="Document\LB57" avqstyle="true" style="width:120px;height:300px;"></div>

        </div>

  <div class="report" style="width:1010px;height:300px;">

  <div class="QvInlineObject" avqview="TariffRates" avq="object:.Document\CH03" id="Document\CH03"></div>

        </div>

  </section>

  <br clear="all" />

  <section>

  <div class="container">

  <button type="button" class="btn" onclick="Clear_Tariff()">Clear_Tariff()</button>

  <button type="button" class="btn" onclick="Clear_Tariff_State()">Clear_Tariff_State()</button>

  <button type="button" class="btn" onclick="GetObjectListTest()">GetObjectListTest()</button>

  </div>

  </section>

  <br clear="all" />

  <section>

  <h1>LERG Data</h1>

  <h4>The purposes of this section is primarily to show how Qlikview DIV integration can pull objects from multiple documents</h4>

  <!--- Note that this document exists in a sub-folder on the QV server, for parsing reasons you have to do a double forward slash (you'll never find that in any docs) -->

        <div class="report"  style="width:1210px;height:200px;>

  <div class="QvInlineObject" avqview="CUSTOMER\/CUSTOMER_LERG" avq="object:.Document\TB03" id="Document\TB03" avqstyle="true"></div>

        </div>

  </section>

</body>

</html>

When I run above html, getting " No Connection" ... then "Reconnecting...".. then SESSION ...CALs errors..

but no specific information I am getting.

Not applicable
Author

DId you ever get this fixed, we are starting to do something similar and info on the subject is lacking.

Not applicable
Author

Yes, I have fixed the issue myself.. based on some trail and errors as neither I am expert nor learnt qlikview..

as I am trying to integrate Qlikview reports in my web application.

Not applicable
Author

Hi Ramesh,

From the above conversation, I understand you have finally done the QV integration with JAVA web application.

Can you please suggest me the steps you have done. I've the following requirement

     1. Simple Webpage containing Qlikview object embedded via DIV integration. Can this be done without           workbench ?

     2. Qlikview server via IIS configuration with Qlik view objects (documents - qvw) deployed.

     3. Webticket for authenticating the Qlikview server

     4. Show the Qlikview objects in Apache Tomcat webpage


I've raised the above questions in the forum, but haven't got solutions. FYI( Qlikview )


Regards,

Srikanth

Not applicable
Author

Hi Nikitha

Am trying to achieve the same in my work i would really appreciate if you could send me a sample.

What is am doing right now ??/ What iam i looking in my application??

I have a page that populates a start and end date with a button to pull the report for the specified dates.

On button press it should direct the qlik webpage browser application in to my current view in my webapplication.