Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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..