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: 
KCC
Contributor II
Contributor II

Need to update the data in Application only for yesterday - Script Qlik SaaS

I want the data to be updated just till yesterday, basically for one day only and now the script is loading data for more than 10 months. I need the solution as well as an explanation how the script is working because I am new to these Qlik scripts.  

I removed the addmonths function but it's still not working. 

Let vLastCreatedFile = date(addmonths( today(), -11 )); 

 

TRACE ********** LAST CREATED DATE:'$(vLastCreatedFile)'*******; 

//this statement is just for testing the results in output to get the date from yesterday. 

Labels (1)
0 Replies