Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Problems Regarding Incremental load with future data

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

1 Reply
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

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful