https://community.qlik.com/t5/App-Development/qvd-architecture/m-p/2115265#M91016 <P>Hi</P> <P>First Tier</P> <P>Load all the data from your data base(Table or View) and store it into qvd files.DO NOT CHANGE THE DATA STRUCTURE IN THIS TIER</P> <P>&nbsp;</P> <P>Second Tier</P> <P>Load the qvd file that you stored in Tier1 and write your calculate logic(where clause\sum group by and etc.).After you finish your code,store your calculate result into several new qvd files,such as SalesData.qvd\Supplychain.qvd and etc.</P> <P>&nbsp;</P> <P>Third tier</P> <P>Use the qvd files that you stored in Tier2 to build your data model</P> Mon, 11 Sep 2023 02:28:58 GMT zhaofeng 2023-09-11T02:28:58Z https://community.qlik.com/t5/App-Development/qvd-architecture/m-p/2115216#M91008 <P>can anyone give me an overview about the three tier architecture.</P> <P>&nbsp;</P> <P>like whats the procedure in each of the tiers</P> Sun, 10 Sep 2023 08:34:05 GMT https://community.qlik.com/t5/App-Development/qvd-architecture/m-p/2115216#M91008 prat121 2023-09-10T08:34:05Z https://community.qlik.com/t5/App-Development/qvd-architecture/m-p/2115265#M91016 <P>Hi</P> <P>First Tier</P> <P>Load all the data from your data base(Table or View) and store it into qvd files.DO NOT CHANGE THE DATA STRUCTURE IN THIS TIER</P> <P>&nbsp;</P> <P>Second Tier</P> <P>Load the qvd file that you stored in Tier1 and write your calculate logic(where clause\sum group by and etc.).After you finish your code,store your calculate result into several new qvd files,such as SalesData.qvd\Supplychain.qvd and etc.</P> <P>&nbsp;</P> <P>Third tier</P> <P>Use the qvd files that you stored in Tier2 to build your data model</P> Mon, 11 Sep 2023 02:28:58 GMT https://community.qlik.com/t5/App-Development/qvd-architecture/m-p/2115265#M91016 zhaofeng 2023-09-11T02:28:58Z