Creating and storing QVD files

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';

Get Mastering Qlik Sense now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.