Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
bharatkishore
Creator III
Creator III

INCREMENTAL LOAD

Hello All,

                 I have done incremental load.N can one can tell me how to get the data for the last one day or two days for a month.I mean if i have 30 days of data  i need the last two days of data.

                Can anyone tell me how to do this if possible pls attach ur copy.

Regards,

Bharat

1 Reply
Not applicable

do you mean that you always have to load the application with the data for the last two day of the month? If so, then create variables which would identity the last day and last but one day of the month for which you are loading the data and use these variables in the where condition of the SQL statement. So, whenever the document is reloaded, only the last two days' data for the corresponding month will be loaded.

Cheers,

Haneesh