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?
I would appreciate some help.
Thanks a lot!