In genaral we follows the three tier architecture in Qlikview development projects.
Here I attached the file for automatic loading of all the Tables from DB to QVD folder and all the QVDs from QVD folder to Qlikview application.
Hope this will help you. Thank you.
Set QVD_Tier1Path = 'C:\Qlikview\SALES\QVD_Tier1\';
ODBC CONNECT TO SALESDB (XUserId is DFBANM2IUY7, XPassword is HIGB1RTAD);
SUB StoreAndDrop (Tablename)
store $(Tablename) into [$(QVD_Tier1Path)$(Tablename).qvd] (qvd);
drop table $(Tablename);
Set QVD_Tier2Path = 'C:\Qlikview\SALES\QVD_Tier2\';
SUB LoadQVD (Tablename)
Load * from [$(QVD_Tier2Path)$(Tablename).qvd] (Qvd);