6 Replies Latest reply: Jun 20, 2018 6:17 PM by Rob Wunderlich RSS

    How to load data from qvd file allocated on the server via script

    Rafael Souza

      Good Afternoon people,

      I have access to some qvd files that are on the server (qvp://bi.cetip.com.br) as the image below:

      ServidorQlickView.png

      But in this file (Market Intelligence.qvd) I have no options to edit the script which leads me to create another qvd file that allows me to add data that are local


      In this line of reasoning I need to find a way to concatenate my local data with the data that is in the qvd file of the server


      I tried to recreate the same script that is generated when connecting to qvd files by changing only the file address


      Attempt 1:

      LOAD * FROM qvp://bi.cetip.com.br/Inteligencia de Mercado/Inteligência de Mercado.qvw@(qvd);


      Attempt 2:

      Binary [qvp:\\bi.cetip.com.br\Inteligencia de Mercado\Inteligência de Mercado.qvw@];


      Attempt 3:

      Binary [qvp://bi.cetip.com.br/Inteligencia de Mercado/Inteligência de Mercado.qvw@];


      but gave an error:

      QvError.png


      I do not know what I'm doing wrong or even if it's possible to do what I want, can you help me?


        • Re: How to load data from qvd file allocated on the server via script
          Luis Imoto

          Hi Rafael.

           

          Are you working with Qlik Sense?

          If so, before anything else you must create a Folder Connection pointing to the server directory where the QVD or QVW file is stored.

           

          Then you can either use Binary (QVW) or Load (from QVD).

          • Binary lib://Connection_Name/File_Name.qvw;
          • LOAD * FROM [lib://Connection_Name/File_Name.qvd] (qvd);

           

          If you are working with QlikView then you don't need a connection:

          • Binary [\\path_to_server_folder\File Name.qvw];
          • LOAD * FROM [\\path_to_server_folder\File Name.qvd] (qvd);
            • Re: How to load data from qvd file allocated on the server via script
              Rafael Souza

              Hello Luis, I'm working with QlickView:

              VersãoQlickView.png

              Follow the results of my attempts:


              Attempt 1:

              LOAD * FROM [qvp://bi.cetip.com.br/Inteligencia de Mercado/Inteligência de Mercado.qvw] (qvd);

               

              Result:

              Result1.png

              ------------------------------------------------------------------------------------------

              Attempt 2:

              LOAD * FROM [qvp:\\bi.cetip.com.br\Inteligencia de Mercado\Inteligência de Mercado.qvw] (qvd);

               

              Result:

              Result2.png

               

              Attempt 3:

              LOAD * FROM [\\bi.cetip.com.br\Inteligencia de Mercado\Inteligência de Mercado.qvw] (qvd);

               

              Result:

               

              ------------------------------------------------------------------------------------------

              Attemp 4:

              LOAD * FROM [//bi.cetip.com.br/Inteligencia de Mercado/Inteligência de Mercado.qvw] (qvd);

               

              Result:

              Result3.png

              ------------------------------------------------------------------------------------------

              Attemp 5:

              Binary [qvp:\\bi.cetip.com.br/Inteligencia de Mercado\Inteligência de Mercado.qvw]

               

              Result:

              Result5.png

              ------------------------------------------------------------------------------------------

              Attemp 6:

              Binary [qvp:\\bi.cetip.com.br/Inteligencia de Mercado\Inteligência de Mercado.qvw@];

               

              Result:

              Result6.png

              ------------------------------------------------------------------------------------------

              Attemp 7:

              Binary [\\bi.cetip.com.br\Inteligencia de Mercado\Inteligência de Mercado.qvw]


              Result:

              Result7.png

               

              I have not had success in this yet