Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

QVD Management

Hello everybody !

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)...

Thanks a lot for your help !!

Kind regards

Tags (1)
1 Solution

Accepted Solutions
MVP
MVP

QVD Management

1. If you are storing your QVDs manually (not using buffers), you can decide what table needs to be stored and you load just the relevant data into that table, prior to storing.

2. For "automatic" QVD generation using buffers (I'm not sure if it's such a popular practice...) - you can change the location of the buffers in "Settings" - "User Preferences" - "Locations".

regards,

Oleg

6 Replies
sathishkumar_go
Contributor III

QVD Management

Hi,

Using Macro it is possible to export the data form another drive

MVP
MVP

QVD Management

1. If you are storing your QVDs manually (not using buffers), you can decide what table needs to be stored and you load just the relevant data into that table, prior to storing.

2. For "automatic" QVD generation using buffers (I'm not sure if it's such a popular practice...) - you can change the location of the buffers in "Settings" - "User Preferences" - "Locations".

regards,

Oleg

Not applicable

QVD Management

Thanks for your help Oleg !


Anyway, does anyone know if QV allows users to export only some values in QVD ?

Not applicable

QVD Management

Dear Franck,

You can use QV to export the query you want into a QVD.

Therefore you should be able to create a table such as ToExport: LOAD COUNTRY, xxx,yyy resident MyTable where COUNTRY = 'MYCOUNTRY';

Then Store Table ToExport INTO C:\MyQVD.qvd.

Hope this can helps you.

Rgds,

Sébastien

QVD Management


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.

See Help/Ref Guide details on STORE.

-Rob

Not applicable

QVD Management

Thanks Rob for your help !

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 Smiley Happy

Quicker than reloading everything Smiley Happy

Anyway, thank you guys for your help !

Community Browser