Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Can Different SQL Scripts be used on the Different Sheets?

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

1 Reply
Not applicable
Author

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 > Ctrl + T). If not, avoid those relations. In that case I think you'd be better of with 2 separate .qvw's

Could you elaborate a bit more on where your problem is? Did you try to build it in Qlikview already?

In your loadscript you can make a connection to SQL datasource one... load some scripts for them...

And when you load things frrom a second SQL source, just make sure that you make a new connect-string.

As many datasources as desired can be combined in Qlikview