topic How to load data twice from same table by month wise on date conditions in QlikView

How to load data twice from same table by month wise on date conditions

Wed, 25 Nov 2020 16:16:04 GMT

Hello , I am new to qlik view and I am looking for somehelp to develop this requirement for trending chart and my data from oracle table looks like this

Department

EMP-id

Next review date

Last Review Date4

System

2016-06-12

2016-04-21

System

2017-01-01

2016-04-21

System

2016-12-01

2016-06-10

System

2016-12-02

2016-06-01

System

2016-12-10

2016-09-12

System

2016-06-1

2016-01-01

System

2016-12-09

2016-06-12

System

2016-07-23

2016-02-01

need to review for month DEC : date condition Next review date between (2016-01-12 and 2016-31-12 ) ;4

Actual Reviewed fro month DEC : date condition Last review date between (2016-01-12 and 2016-31-12 ) 0

based on the above condition I need to load data for each month and how can we do that with script. and how to store data by each month and when I do first time how to load Historical data.

Thanks,Pinky

Re: How to load data twice from same table by month wise on date conditions

hemachandran — Thu, 09 Mar 2017 10:49:20 GMT

HI,

Your two dates for last review and next review dates are same..

Ok Based on the dates you can load the data

Ex:

Table 1:

Load

This table normal table

Table2:

Load

-----

Where date>2016-01-12 and 2016-31-12

this two dates have set in variables

Historical Table:

Concatenate Table 1 & Table2

This is the incremental load concept..