topic Pulling data from QVD files and aggregating in QlikView

Pulling data from QVD files and aggregating

jleefjcapital — Tue, 22 Sep 2015 18:05:27 GMT

Once we load the data to QVD files, how do we pull from it and aggregate into one table?

Clever_Anjos — Tue, 22 Sep 2015 18:08:51 GMT

Tmp:

LOAD * from yourqvd.qvd(qvd);

LOAD

Field1,

Field2,

SUM(Val1) as ValAggr

Resident Tmp

Group by

Field1,

Field2;

drop table Tmp; // you don´t need it anymore

jleefjcapital — Tue, 22 Sep 2015 18:12:31 GMT

If we have multiple tables to load to the QVD file, do we include multiple store statements? Like this-

Store Employees into [lib://QVD Folder/Datatable.QVD](qvd);

Store Employees_2 into [lib://QVD Folder/Datatable.QVD](qvd);

Store Employees_3 into [lib://QVD Folder/Datatable.QVD](qvd);

Store Employees_4 into [lib://QVD Folder/Datatable.QVD](qvd);

Clever_Anjos — Tue, 22 Sep 2015 18:17:05 GMT

Are you using QlikView or Sense?

Anyway, if you do multiple STORES to same QVD, only the last STORE remains.

A qvd can hold only one table and can´t be updated, you must create a table into memory that holds all data and then store it