Hope someone can help me fault find this one.
I have a SQL database with large volumes of data in it. I import a load of data into the SQL database from our factory system (OPC PLC & DCS system) / change some of the data and it doesn't appear in my app after re load. The original / previous data is unchanged.
I am using a simple SQL Select * statement in my load script and the data is clearly there in SQL.
Weirdly the data seems to be there some time after. I normally make the changes to SQL on an evening and the next day it's there!
Does anyone know if Qlik somehow caches data from SQL? Is there a setting I can adjust to prevent this in future?
Many thanks