Data from Data Gateway is not updated until I select "Select data from source"
Hi there,
I am trying to something rather simple (I think) with the SaaS version of QlikSense, which is to create a sheet that shows the current count of records in an SQL database.
I have done the following:
Set up a Direct Access Data Gateway to be able to access the database
Added the table to my app using Data Manager / `Add data` feature (using the auto-generated loading script)
Created a sheet that counts the records
Initially, this works fine. However, once the record count in the source table changes, the sheet doesn't update, even if I press the app's `Load data` button before and wait for the loading to finish. Instead, I have to open the table in the Data Manager and hit the `Select data from source` button to refresh the data in QlikSense.
Is this expected behavior? Shouldn't the data in my app be refreshed simply by hitting the `Load data` button?