topic Re: Can Different SQL Scripts be used on the Different Sheets? in QlikView https://community.qlik.com/t5/QlikView/Can-Different-SQL-Scripts-be-used-on-the-Different-Sheets/m-p/361900#M134509 <HTML><HEAD></HEAD><BODY><P>Sure it is possible to use results from several SQL sources / scripts. Is it related data? If so, make sure that the relations in Qlikview will become right (check the table viewer &gt; Ctrl + T). If not, avoid those relations. In that case I think you'd be better of with 2 separate .qvw's</P><P></P><P>Could you elaborate a bit more on where your problem is? Did you try to build it in Qlikview already?</P><P>In your loadscript you can make a connection to SQL datasource one... load some scripts for them...</P><P>And when you load things frrom a second SQL source, just make sure that you make a new connect-string.</P><P></P><P>As many datasources as desired can be combined in Qlikview</P></BODY></HTML> Sat, 21 Jul 2012 19:25:14 GMT 2012-07-21T19:25:14Z Can Different SQL Scripts be used on the Different Sheets? https://community.qlik.com/t5/QlikView/Can-Different-SQL-Scripts-be-used-on-the-Different-Sheets/m-p/361899#M134508 <HTML><HEAD></HEAD><BODY><P>I am trying to use different results from different SQL scripts and want that to be assigned individually by inserting various sheets in the same QV file, will this be possible - appreciate any help I can get in this matter</P></BODY></HTML> Sat, 21 Jul 2012 17:45:37 GMT https://community.qlik.com/t5/QlikView/Can-Different-SQL-Scripts-be-used-on-the-Different-Sheets/m-p/361899#M134508 2012-07-21T17:45:37Z Re: Can Different SQL Scripts be used on the Different Sheets? https://community.qlik.com/t5/QlikView/Can-Different-SQL-Scripts-be-used-on-the-Different-Sheets/m-p/361900#M134509 <HTML><HEAD></HEAD><BODY><P>Sure it is possible to use results from several SQL sources / scripts. Is it related data? If so, make sure that the relations in Qlikview will become right (check the table viewer &gt; Ctrl + T). If not, avoid those relations. In that case I think you'd be better of with 2 separate .qvw's</P><P></P><P>Could you elaborate a bit more on where your problem is? Did you try to build it in Qlikview already?</P><P>In your loadscript you can make a connection to SQL datasource one... load some scripts for them...</P><P>And when you load things frrom a second SQL source, just make sure that you make a new connect-string.</P><P></P><P>As many datasources as desired can be combined in Qlikview</P></BODY></HTML> Sat, 21 Jul 2012 19:25:14 GMT https://community.qlik.com/t5/QlikView/Can-Different-SQL-Scripts-be-used-on-the-Different-Sheets/m-p/361900#M134509 2012-07-21T19:25:14Z