Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
We have a Customer on Qlik Cloud that we set up several Tabular Reports for that runs in a schedule. Some of these reports run on a weekly basis (on Monday) and some on a monthly basis (1st day).
The run for this past week's runs produced blank reports for both the Monthly (1st March 2026) and for the Weekly report (2nd March). The weekly report for 23 February did have data.
I don't understand why the Monthly report was blank as the filter should have adjusted back to Feb 2026 as the Filters are set up as evaluate filters on Year and Month respectively as year(today()-1) and month(today()-1).
After the customer reported the problem, I re-ran the report (adjusting the filters to today()-4) and this time it worked. I have checked the reload schedule for the app and it ran successfully on both 1 March and 2 March.
Hi @pieterkup
We were not there so it is hard to troubleshoot that remotely.
One thing though is whether or not you are considering that Today() returns UTC time? Could that be a factor in what you do? Obviously this very much depends on where you are based and what time of the day you are trying to run those reports. For us in Sydney Australia it is noticeable thing so we can see it straight away when we need to use ConvertToLocalTime() function.
cheers