Problems Regarding Incremental load with future data

[#1]

Hi,

here one issue i am facing ..

our database table contains the field year, week,....etc

i am clubbed the both data as year-week.

but in database it contains wrong dates as  future dates but no values to them

YEAR_WEEK

2017-1

2017-2

2017-3

2017-4

2017-5

2017-6

2017-12

2017-32

2017-33,

2017-50

while i am applying incremental load,

while taking last [year-week] to the variable it takes last date..means 2017-50

how can i get the present year week ?

how can i apply the incremental load ?

your  answers would be so helpful...Thank you

[Anil_Babu_Samineni]

When you talk about Present Week Year you should required to use Today() function even if you have Forecast data

Year(Today()) & '-' & 'Week(Today())

QlikView Incremental Load