it is much faster than other file ..suppose if u have excel or any other file ,u wnt to convert tht file to qvd mean this is the syntax store tablename into and the location where u r getting the excel file \newfilename.qvd
store fund into C:\Users\Administrator\Desktop\fund.qvd;
for qlikview applicaiton the source files are qvds, qvds are binary files and loading the data from qvds is much faster then loading the data from regular file.when u bbuilt the applciations with qvds ur application size also minimizes.
qvds are only understable by qliview.
u can also load the data from excel files and built the applciation as long as u have limited data.
U will find the differnece when working on large sets of data.
QVD (QlikView Data) - is a native QlikView format and can only be written to and read by QlikView. The file format is optimized for speed when reading data from a QlikView script but it is still very compact. Reading data from a QVD file is typically 10-100 times faster than reading from other data sources.
1. Single Source of Truth – QVDs promote re-use of common data sets which helps create a single source of truth for your QlikView deployment
2. Resource Flexibility – developing a QVD layer can be primarily an I.T. responsibility, allowing the interface design to be handled by Business teams and less technical resources.
3. Development Flexibility – QVDs are offline components and allow developers to develop, test and validate data offline from databases
4. Development Speed – having a library of QVDs built allows a developer or designer to very quickly identify, load and test data sets that might otherwise take database and SQL skills to get
5. Delivery Flexibility – QVDs can easily be aggregated, segmented orotherwise modified to meet the specific needs of dashboards. This is much easier than re-writing queries.
6. Incremental Loads – very large datasets benefit greatly from incremental (delta) loads. QVDs accommodate any type of incremental load, saving time and resources each day
7. Very Fast Data Loads – once created, a QVD file can be loaded into a QlikView document as rates of 10-100 times faster than the original query speed.