Automatic Loading Tables and QVDs

    Hi All,

     

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

    END SUB

     

    Set QVD_Tier2Path = 'C:\Qlikview\SALES\QVD_Tier2\';

    SUB LoadQVD (Tablename)

       $(Tablename):

       Load * from [$(QVD_Tier2Path)$(Tablename).qvd] (Qvd);

    END SUB

    Call LoadQVD('EMP');

    Call LoadQVD('PRODUCTS');

    Call LoadQVD('REGION');

    Call LoadQVD('TRANSACTION');

    Call LoadQVD('CALENDAR');