I have setup an app in Qlik Sense and have created an ODBC Connection to a reporting database. I have added the necessary tables into the data loader but also need to add in a SQL Query so that the results of the query can be displayed in a table in the app.
This is quite a complex query but ultimately it includes selected, join and update functions which leabes me with a specific numbe rof records. How do I include this in the data load? Or is there a way to run the SQL Query with the raw data within the app itself?