Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
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