I'm currently working on QVD exports and i've, on this topic, several questions :
1. Is it possible to store only some elements of a table (for instance, the rows which correspond to a country or a date...)?
2. Is it possible to change the path to the "buffer"? I mean, by default, it is "C:\Document and Settings\%user%\Application Data\Qlik-Tech\QlikView" but i woiuld like to save automatically the files in another directory... (for instance, the path of the QV application/Data/qvd)...
Franck.Deny wrote:Anyway, does anyone know if QV allows users to export only some values in QVD ?
The Script "STORE" statement stores a QV table into a QVD file. The STORE statement optionally allows you to specifiy that only certain columns be stored in the QVD. You cannot filter on the row level. To filter on the rows, you must build a new table using WHERE and then STORE that new table.
But i think there is another option... We create a straight table with all columns and we use filters to only display the data we want. Based on that, we use the "Export" feature to store it into a QVD