topic ODBC Connection, Load in Data with a query in App Development https://community.qlik.com/t5/App-Development/ODBC-Connection-Load-in-Data-with-a-query/m-p/97396#M6509 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>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.</P><P></P><P>This is quite a complex query but ultimately it includes selected, join&nbsp; 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?</P></BODY></HTML> Fri, 21 Sep 2018 15:07:30 GMT richardm90 2018-09-21T15:07:30Z ODBC Connection, Load in Data with a query https://community.qlik.com/t5/App-Development/ODBC-Connection-Load-in-Data-with-a-query/m-p/97396#M6509 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>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.</P><P></P><P>This is quite a complex query but ultimately it includes selected, join&nbsp; 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?</P></BODY></HTML> Fri, 21 Sep 2018 15:07:30 GMT https://community.qlik.com/t5/App-Development/ODBC-Connection-Load-in-Data-with-a-query/m-p/97396#M6509 richardm90 2018-09-21T15:07:30Z Re: ODBC Connection, Load in Data with a query https://community.qlik.com/t5/App-Development/ODBC-Connection-Load-in-Data-with-a-query/m-p/97397#M6510 <HTML><HEAD></HEAD><BODY><P>Hi guys,</P><P></P><P>Any help on this one would be very much appreciated <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Sun, 23 Sep 2018 21:28:12 GMT https://community.qlik.com/t5/App-Development/ODBC-Connection-Load-in-Data-with-a-query/m-p/97397#M6510 richardm90 2018-09-23T21:28:12Z Re: ODBC Connection, Load in Data with a query https://community.qlik.com/t5/App-Development/ODBC-Connection-Load-in-Data-with-a-query/m-p/97398#M6511 <HTML><HEAD></HEAD><BODY><P><IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Mon, 24 Sep 2018 09:19:46 GMT https://community.qlik.com/t5/App-Development/ODBC-Connection-Load-in-Data-with-a-query/m-p/97398#M6511 richardm90 2018-09-24T09:19:46Z