We submit a request from Qlikview to SQL Server via a macro. We are able to get the data extract from SQL Server to our email within 2-3 minutes.
We would like to display a message to the end users saying “Your requested report will be available in your email after 2-3 minutes” as soon as they click on “report Request” Text box on Qlik dashboard.
The problem we see is Qlik is taking 15 to 20 seconds of time to display the informative message to the end user and it also allow to click the text box (which mean submit another request) again and send another request to the database.
Below are the set of actions applied on the Text box:
Enable a variable to display the text box “Your requested report will be available in your email after 2-3 minutes”
Run a macro to create log file.
Run a macro to connect to the SQL server and insert the filters in SQL server table.
We have done a test to capture which step is taking more time and observed step3 is taking major part of the time.
We request you to check and help us is there any way to make sure that step1 is executed immediately and not to wait for step 2 and 3.