3 Replies Latest reply: Aug 17, 2014 1:58 AM by Ashfaq Mohammed RSS

    QlikView is not able to generate proper Qvd file extention

      Hi,

       

      I am learning QlikView version downloaded from your site but it was  not able to generate proper Qvd file extention while i have followed

      all instruction as guided in the pdf file and all others. After writing Store command line, i run Reload then it has created a file (Table1.qvd) with qvd extension but not a proper Qvd extention file which is not open up properly.

       

      File attached :

       

      QVD issue file (Doc)  : QVD issue

      QlikView file  :  OLEDB-SQL

      QVD file : Table1

       

      Please help me with a solution.

       

      Thanks & regards,

      Bhaskar

        • Re: QlikView is not able to generate proper Qvd file extention
          sai v

          Hi Bhaskar,

           

          Please change the store statement:

           

          STORE Table_1 into Table1.qvd(qvd); to

           

          STORE Table1 into Table1.qvd(qvd);

           

          (STORE tablename into qvdname.qvd(qvd);)

          Table1:

          LOAD Surname,

              FirstName,

              Gender;

          SQL SELECT *

          FROM School.dbo."Table_1";

           

          While creating QVD, you need to input the tablename which you define in the script but not from the datasource.

           

          Here, the name for table in the script is Table1 but in SQL it is Table_1. You are trying to give DB name but change it above one, it generates the QVD.

          Hope this helps!

           

          Thanks,

          Sai