topic Incremental and Qlikview Workflow in QlikView

Incremental and Qlikview Workflow

Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Incremental and Qlikview Workflow

ramasaisaksoft — Fri, 17 Jun 2016 14:10:27 GMT

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.