Hi Tushar, I think Aaron, has explain well and even though if you have some doubt. Please refer help section (F1) in QlikView by typing QVD file. It's really good to understand. Create QVD Files A QVD file can be created by one of three different methods: Explicit creation and naming from script by means of the Store command. Simply state in the script that a previously read table or part thereof is to be exported to an explicitly named file at a location of your choice. Automatic creation and maintenance from script. By preceding a load or select statement with theBuffer prefix, QlikView will automatically create a QVD file which under certain conditions can be used instead of the original data source when reloading data. Explicit, manual creation and naming from layout or via Internal Macro Interpreter. Data can be exported from the QlikView layout via GUI commands or Automation macros. In the GUI you will find QVD as one of the possible export formats under the Export... command, found on the object menu of most sheet objects. There is no difference between the resulting QVD files, e.g. with regard to reading speed etc. Reading Data from QVD Files A QVD file can be read into or accessed by QlikView by the following methods: Loading a QVD file as an explicit data source. QVD files can be referenced by a load statement in the QlikView script just like any other type of text files (csv, fix, dif, biff etc). The File Wizard: Type handles QVD files by the same principles. Examples: load * from xyz.qvd (qvd); load Name, RegNo from xyz.qvd (qvd); load Name as a, RegNo as b from xyz.qvd (qvd); Automatic loading of buffered QVD files. When using the Buffer prefix on load or select statements, no explicit statements for reading are necessary. QlikView will determine the extent to which it will use data from the QVD file as opposed to acquiring data via the original load or select statement. Accessing QVD files via the script. A number of script functions (all beginning with qvd) can be used for retrieving various information on the data found in the XML header of a QVD file. These functions are presented under the File Functions in Script functions. hope this helps.
Hi Tushar, If you our answer helps you then close this either by clicking correct answer or helpful answer, so that next time your query can be referred by someone else.
