I've encountered an unexpected issue. My Sales App is not updating with the latest January 2026 data. Data for all previous months is accurate; however, January 2026 is not loading correctly. The application pulls data from CSV files via automation, which ran successfully. the CSV files are stored in a OneDrive folder that is populated by our ERP every day.
Can anyone please kindly assist. Your assistance would be appreciated.
The first thing to check is if the data is reaching the app, but your formulas are excluding it from the calculations. In this case, I would use a new table and add data that you know is only present in the new data.
The second thing to check is if you've implemented any calendar during runtime that has 2025 as the fixed date.
The third thing to check is if the access section is excluding the data. If so, temporarily remove the access section.
The fourth thing to check is if the CSV files have the same structure as the previous ones; that is, that the delimiter hasn't changed (in some cases it's "," and in others ";").
Finally, I would check that the files are in the correct location or if the user is pulling the data has access to 2026 folder
Hope this give you some clues.
Best,
help users find answers! Don't forget tomark a solutionthat worked for you & to smash thelike button!
The first thing to check is if the data is reaching the app, but your formulas are excluding it from the calculations. In this case, I would use a new table and add data that you know is only present in the new data.
The second thing to check is if you've implemented any calendar during runtime that has 2025 as the fixed date.
The third thing to check is if the access section is excluding the data. If so, temporarily remove the access section.
The fourth thing to check is if the CSV files have the same structure as the previous ones; that is, that the delimiter hasn't changed (in some cases it's "," and in others ";").
Finally, I would check that the files are in the correct location or if the user is pulling the data has access to 2026 folder
Hope this give you some clues.
Best,
help users find answers! Don't forget tomark a solutionthat worked for you & to smash thelike button!
Thank you for the feedback, it is greatly appreciated. The 2026 data was not reaching the app due to a year-boundary, as the PowerShell script on the Qlik server that dumps the CSV files from the ERP to OneDrive was configured to extract data for 2025 from the ERP. I have updated the script to include 2026 data, refreshed the OneDrive, and reran the Qlik automation. The data is now accurate.
I also verified the master calendar to ensure it includes January 2026 dates and confirmed that all dates for January to date are now present.
