10 Replies Latest reply: May 9, 2017 8:49 AM by Kiran B RSS

    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

        • Re: Accessing QV application in Java Web application
          Syed Muzammil

          Hi,

           

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

          • Re: Accessing QV application in Java Web application
            Erik Gustafsson

            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

              • Re: Accessing QV application in Java Web application

                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

                  • Re: Accessing QV application in Java Web application
                    Erik Gustafsson

                    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

                      • Re: Accessing QV application in Java Web application

                        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.

                      • Re: Accessing QV application in Java Web application
                        Kiran B

                        Hi Nikitha,

                         

                        I am new to Qlikview.

                        I want to integrate Qlikview app into Java application.

                        Just wanted to know whether Qlikview has a API which can be integrated with Java Application.

                        If its a API then is it a SOAP or REST API.

                         

                        Is there any other ways to integrate QV to Java Application.

                         

                        -Kiran

                    • Re: Accessing QV application in Java Web application
                      Sravan kanduri

                      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.