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

Announcements
Posting on Qlik Community is temporarily paused for some users. Thank you for patience and we'll update you soon!
cancel
Showing results for 
Search instead for 
Did you mean: 
MK_QSL
MVP
MVP

Incremental Load

What is wrong in script from enclosed file?

When I load first script and create a QVD, it is giving me only 2013 until september end data.

But after doing incremental load, I got 2010, 2011,2012 data also.

Labels (1)
11 Replies
ronaldocarrijo
Partner - Contributor III
Partner - Contributor III

Do this, and tell me if it returns some data:

WHERE DECDDT >= '01-Jan-2013' and RIGHT (PNO, 1) <> '4' and RIGHT (PNO, 1) <> '3'

MK_QSL
MVP
MVP
Author

any answer on this?