Pulling data from QVD files and aggregating

[jleefjcapital]

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

[Clever_Anjos]

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]

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]

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

Further reading: http://www.quickintelligence.co.uk/qlikview-qvd-files/

QVDs in Qlikview | Learn QlikView

http://www.analyticsvidhya.com/blog/2014/08/qvds-qlikview-application-efficient/

http://stackoverflow.com/questions/25521936/storing-multiple-tables-into-a-qvd-in-qlikview