I suggest you to take a look at direct discovery feature, at https://help.qlik.com/en-US/sense/June2018/Subsystems/Hub/Content/DirectDiscovery/access-large-data-sets-with-direct-dis…
I hope it can helps.
There are essentially three mechanisms you can employ - but all three needs the user to press a "button" or do a query/selection to get anything updated - but the updated data will be as-of the query performed:
1) Qlik Direct Discovery as Andrea G mentioned above
2) On Demand App generation (ODAG)
3) Advanced Analytics Integration AAI using SSE (Server Side Extensions) using one of several "middleware" tools like for instance Python. With Python as middleware you can query directly to Oracle via Python Oracle Drivers and get the results immediately visualized using SSE in the UI.