topic QVD Files AS Databases in QlikView https://community.qlik.com/t5/QlikView/QVD-Files-AS-Databases/m-p/178619#M45751 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>Please, can i write the request to query the QVD file as i would request on a Mysql Database?</P><P>Thnks</P></BODY></HTML> Sat, 28 Aug 2010 11:39:56 GMT 2010-08-28T11:39:56Z QVD Files AS Databases https://community.qlik.com/t5/QlikView/QVD-Files-AS-Databases/m-p/178619#M45751 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>Please, can i write the request to query the QVD file as i would request on a Mysql Database?</P><P>Thnks</P></BODY></HTML> Sat, 28 Aug 2010 11:39:56 GMT https://community.qlik.com/t5/QlikView/QVD-Files-AS-Databases/m-p/178619#M45751 2010-08-28T11:39:56Z QVD Files AS Databases https://community.qlik.com/t5/QlikView/QVD-Files-AS-Databases/m-p/178620#M45752 <HTML><HEAD></HEAD><BODY><P>I'm not sue I understand your issue...</P><P>Within QlikView, you can LOAD the QVD file, using almost the same syntax as in a SQL SELECT - you can use WHERE, GROUP BY and ORDER BY clauses. In this sense, - yes, you can load QVD data almost in the same way you query a SQL database. Some details like Joining, need to be taken care of differently...</P><P>Outside of QlikView - no, you can't query a QVD file. There is no tool or driver (that I know of) that can read QVD files outside of QlikView.</P><P>hope it helps,</P><P></P><P></P></BODY></HTML> Sun, 29 Aug 2010 21:08:44 GMT https://community.qlik.com/t5/QlikView/QVD-Files-AS-Databases/m-p/178620#M45752 Oleg_Troyansky 2010-08-29T21:08:44Z