7 Replies Latest reply: Feb 2, 2017 2:21 PM by Aehman K RSS

    Not Able to create QVD

    Anirban Mitra

      Hi,

       

      I am not able to create QVD.

      While using only Data load script it is loading from Data base but while writing Store Command to Store QVD, it is giving error that "Connection not found" I have created a folder connection.

       

      Please let me know any specific access required for the same??

       

      Thanks

      Anirban

        • Re: Not Able to create QVD
          Daniel Ansell

          Hi Anirban

           

          Can you share the code you have for using the STORE command?

          Maybe this is the issue...

           

          It should be like the following:

           

          Store Data into [lib://FOLDER/data.qvd](qvd);

           

          Also, is the connection showing on the right hand side panel in Qliksense?

           

          Dan

            • Re: Not Able to create QVD
              Anirban Mitra

              Hi Daniel,

               

              Connections are showing in the right panel in Qlik sense.

               

              Please find below code.

              LIB CONNECT TO 'DB_Test (ecommerce_amitra)';

              LOAD "Ariba Code",
                  "Level 1",
                  "Level 2";
              SQL SELECT "Ariba Code",
                  "Level 1",
                  "Level 2"
              FROM "Procurement_DW".dbo."Category_Mapping";
              Store Category_Mapping into 'lib://QVD_Data/QV1.QVD' (qvd);

               

              I have created connection as QVD_Data.

              While Loading it is giving an error,

               

              Connection Not Found: QVD_Data.

               

              Thanks and Regards

              Anirban