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

[#1]

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	1	2016-06-12	2016-04-21
System	2	2017-01-01	2016-04-21
System	3	2016-12-01	2016-06-10
System	4	2016-12-02	2016-06-01
System	5	2016-12-10	2016-09-12
System	6	2016-06-1	2016-01-01
System	7	2016-12-09	2016-06-12
System	8	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

[hemachandran]

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