topic Re: Creating 3 tier architecture in QlikView

Creating 3 tier architecture

surajap123 — Mon, 10 Mar 2014 14:04:15 GMT

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

Re: Creating 3 tier architecture

maxgro — Mon, 10 Mar 2014 14:17:14 GMT

extract from a Qlikview doc

Re: Creating 3 tier architecture

rwunderlich — Mon, 10 Mar 2014 14:40:15 GMT

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

Re: Creating 3 tier architecture

surajap123 — Mon, 10 Mar 2014 15:34:36 GMT

Thanks a lot for clear explanation Rob !!

Re: Creating 3 tier architecture

Anonymous — Thu, 16 Jun 2016 07:35:52 GMT

Simple and clear !!

Thanks,

----Anant

Re: Creating 3 tier architecture

ravindraa — Wed, 14 Feb 2018 05:57:10 GMT

Hi Suraj Kumar,

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

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

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

Re: Creating 3 tier architecture

girishsrini — Wed, 14 Feb 2018 06:21:15 GMT

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

thanks.

Re: Creating 3 tier architecture

Ranjanac — Thu, 06 Jul 2023 10:27:02 GMT

Hi @rwunderlich ,

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