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 Kingdom
Manchester, United Kingdom
Leeds, United Kingdom
New York, United States
Miami, United States
Berlin, Germany
Munich, Germany
Rome, Italy
];

STORE CitiesCountries INTO 'lib://myConnection/CitiesCountries.qvd';

In the preceding example, we first create an inline table. We use this table so you can try it yourself. Most of you will not have a database installed locally so using these tables is easiest. Remember that you need to create your data connection before you can store anything using the LIB syntax.

The STORE syntax will save a previously loaded table into a format specified by the user. In this case, we store the data in the file CitiesCountries.qvd, which is in QVD format. 

Saving QVD files from Qlik Sense Cloud is not available at the time of writing. Use the Desktop or Enterprise version instead.
..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset
3.135.202.203