Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
IMPORTANT security patches for GeoAnalytics Server available to download: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
surajap123
Creator II
Creator II

Creating 3 tier architecture

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

1 Solution

Accepted Solutions
rwunderlich

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

View solution in original post

6 Replies
maxgro
MVP
MVP

extract from a Qlikview doc

qv data architecture 3.jpg

rwunderlich

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
Creator II
Creator II
Author

Thanks a lot for clear explanation Rob !!

anantmaxx
Specialist
Specialist

Simple and clear !!

Thanks,

----Anant

ravindraa
Creator
Creator

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
Partner
Partner

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

thanks.