There are two ways of creating QVD files using Qlik Sense:
- Utilizing the STORE syntax: With this syntax, we can store any previously loaded table or part of it into a QVD file.
- Using Buffer: This syntax is used before any Load or Select statement. The files are automatically stored and maintained. The QVD files are stored in different locations depending on your installation.
The following example shows one way of storing data in QVD format:
CitiesCountries:Load * INLINE[City, Country London, United KingdomManchester, United KingdomLeeds, United KingdomNew York, United StatesMiami, United StatesBerlin, GermanyMunich, GermanyRome, Italy];STORE CitiesCountries INTO 'lib://myConnection/CitiesCountries.qvd';