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: 
vanir88
Creator
Creator

Refresh date script for monthly refresh

HI,

i have a requirement that monthly i will get csv file so every month 1st the report will run automatically , now the after refreshing of report it has to show  by default previous month data. so how to add script for this in load editor, can any one please help?

we are maintaining historical data in QVD, 

Labels (2)
2 Replies
salonicdk28
Creator II
Creator II

Hi, You can add a bookmark for max(month)-1, so for every month, it will open with the previous months data in your application

Thanks,

Saloni

vanir88
Creator
Creator
Author

where i have to add this code can you please elaborate more