Creating 3 tier architecture

[surajap123]

Hi,

We already have a final qvw document which is not divided based on the 2 or 3 tier architecture, I mean source data load, ETL and UI is in the same qvw.

I want to split this existing qvw into 3 tier architecture. Please let me know the steps involved to achieve this.

Regards,

Suraj

[maxgro]

extract from a Qlikview doc

[rwunderlich · Accepted solution]

For a three tier architecture, you will use QVDs.

1. Create an extract qvw where script is:

Sales:

SELECT * FROM SALES;

STORE Sales INTO Sales_Extract.qvd (qvd);

2. Create a transform qvw that reads the extracted QVD and produces a transformed QVD.

Sales:

LOAD

     x as y  // various transforms

FROM Sales_Extract.qvd (qvd);

STORE Sales INTO Sales.qvd (qvd);

3. Load the transformed QVD(s) into your final dashboard.

LOAD * FROM Sales.qvd (qvd);

-Rob

[surajap123]

Thanks a lot for clear explanation Rob !!

[Anonymous]

Simple and clear !!

Thanks,

----Anant

[ravindraa]

Hi Suraj Kumar,

Excellent explanation..................

if you want more information on the same find the below link.

https://www.youtube.com/watch?v=9qQ7hA0XVrs

[girishsrini]

Simplest form to understand 3 tier architecture in Qlik. Awesome Rob.

thanks.

[Ranjanac]

Hi @rwunderlich ,

Aren't we using binary load in the 3rd step while transforming QVD(s) into your final dashboard?