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

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

Run multiple select statement at once

HI,

I have an application in which i need to connect through diffrent tables in oracle and fetch data.

The data is fetched through 5 diffrent select statements.

I create 5 tables in qlikview to store this data.

When I reload this app, Each select statement runs sequentially and hence each taking ti9me seperately.

Is there anyway through which i can run all 5 select statemnts in one go which will help in reducing time for reload of app?

Thanks in advance.

Aaditya

3 Replies
danielrozental
Master II
Master II

Yes, you need to load each statement in it's own QVW, then schedule all QVWs to run at the same time.

Not applicable
Author

Hi Daniel,

Thanks, but can't this be done in a single qvw?

Aaditya

danielrozental
Master II
Master II

No, unless your QVW triggers a stored procedure that does it for you.