Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Become an analytics expert with Qlik's new 15 week course: Applied Data Analytics using Qlik Sense. READ MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Incremental and Qlikview Workflow

Hi ,


I have below high level understanding of incremental load and Qlikview workflow- given scenario where we receive data files on daily basis , please correct me if I am wrong or missing something 

Qlikview version : Qlikview 11

1. Import records from data files into DB tables

2. Use incremental load procedure for uploading new records from DB tables into Dashboard by using multiple qvd files (each qvd file belongs to one particular table)

3. Create Data model and apply transformations(if required)

4. Develop UI (charts, security etc)

5. Change the QVDs and QVW files path based on Root folder on server

6. Move all QVDs and QVW file from local system to Root folder on Qlikview Server (Assuming same records are available on Prod DB server)

7. Create Publisher task on Qlikview Server which will move QVD and QVW files inside Access Point folder

To upload daily updated records we will have to run incremental load every day

1 Solution

Accepted Solutions
ramasaisaksoft

Hi Sharma,

First thing you need to say Fresh/Updated data & Qlikview (Not incremental load)

1. Import records from data files into DB tables

2. create Qvd's files as a source (It is Fully load in Incremental load type) for different tables

a table     a.qvd

b table     b.qvd....x table   xqvd

3.Create Data Model  by using different joins/Concatenation/Keep...Load types...Functions

(it is better to create Data Model without Synthetic tables & Circular Loops)

4.Now create Different sheets as per your client requirement using with different objects with in Sheets.

Server:-

1) create Folder structure for a perticular project(Here only u need to maintain all files)

     0_Access

     1_Source_Data

     2_QVD

     3_ETL

     4_Dashboards

     5_Settings

     6_Scripts

     7_Resouces

     8_Documentation

2)After that in QMC  u need to schedule the jobs

3)Check the dashboards at Access point as per your credentials.

View solution in original post

1 Reply
ramasaisaksoft

Hi Sharma,

First thing you need to say Fresh/Updated data & Qlikview (Not incremental load)

1. Import records from data files into DB tables

2. create Qvd's files as a source (It is Fully load in Incremental load type) for different tables

a table     a.qvd

b table     b.qvd....x table   xqvd

3.Create Data Model  by using different joins/Concatenation/Keep...Load types...Functions

(it is better to create Data Model without Synthetic tables & Circular Loops)

4.Now create Different sheets as per your client requirement using with different objects with in Sheets.

Server:-

1) create Folder structure for a perticular project(Here only u need to maintain all files)

     0_Access

     1_Source_Data

     2_QVD

     3_ETL

     4_Dashboards

     5_Settings

     6_Scripts

     7_Resouces

     8_Documentation

2)After that in QMC  u need to schedule the jobs

3)Check the dashboards at Access point as per your credentials.

View solution in original post