Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
Please find the attached dashboard having two tabs and a GIF image in text box.
My requirements are
1.Once I click on button GIF image should have to be visible for 5 sec
2.On completion of 5 sec SH02 should have to activated
Is it possible and How?
Regards,
Gaurav
Gaurav,
It is possible with a macro using Sleep method.
If macro is not an option for you, think of some external application that sends command to QV app to switch sheet.
Regards,
Michael
Getting the Loading Message to display does not seem to be possible. But the attached macro does create a sleep command to put a delay in before opening the next page
Hi
See the attached. Textbox 1 is displayed after clicking Start, for a time delay set in variable vDelay (in seconds), after which Textbox 1 is hidden and Textbox 2 is revealed.
HTH
Jonathan
Typically it's not a good idea to use now() function on the front end, but it looks appropriate in this case.
Jonathan,
How can I use your delay technique in macros? I have a macro which fetches results from Webservice and have to put in an interval of 30 seconds before the next fetch. The best I could find is Sleep. But the problem with Sleep is that the QV application hangs for the specified time and I cannot perform other activities. I want to be able to press another button during that time.
I tested your application and placed couple of buttons. When I pressed the "Start" button - during the delay period i was able to press other buttons and trigger other actions.
Is there a way to use your delay technique in macro setting since the Sleep literally puts the application to Sleep.
Thanks.
Hi,Gaurav_wani
In my case I have created a loop containing the time spected to calculate the data.
Example:
For i = 1 to 10000 'this is a delay wait for the time specified before to continue
ActiveDocument.Fields("FieldName").Select vName ' this is a variable that contains the current name readed from qlikview table
Next
ActiveDocument.Fields("FieldName").clear 'this statement clear de current field selected to continue.
I hope help you!