topic Re: Button press triggers script to load first when macro is first action in QlikView

Button press triggers script to load first when macro is first action

Wed, 31 May 2017 18:23:19 GMT

Hi,

I currently have a button on one of my Qlikview that has 2 actions: 1) run macro (just a msgbox to say that the load takes 8 minutes) then 2) reload the data.

Each time I click the button the script loads before I can see msgbox, which only displays after the 8 minute load is complete. is there a way to prevent the load until after the msg box "OK" button has been clicked?

thank you

Re: Button press triggers script to load first when macro is first action

settu_periasamy — Wed, 31 May 2017 18:54:43 GMT

try to add the sleep time in the macro. And instead of reload action (assume 2nd action), you can add the same into macro itself. If you click 'Ok' then reload, else exit.

Re: Button press triggers script to load first when macro is first action

Wed, 31 May 2017 18:58:17 GMT

I've tried sleep times in the past but couldnt get them to work. could you please provide the syntax. perhaps I was doing something wrong.

this is what I have:

sub Wait

ActiveDocument.getapplication.WaitForIdle

ActiveDocument.getapplication.Sleep (1000)

End sub

Re: Button press triggers script to load first when macro is first action

settu_periasamy — Wed, 31 May 2017 19:03:08 GMT

Your code is seems to be fine. Have you tried reload into the macro instead of 2nd action?

Re: Button press triggers script to load first when macro is first action

settu_periasamy — Wed, 31 May 2017 19:12:45 GMT

Refer the below link for Message code.

Is there a way to may the Popup on a macro so that it is always on top?‌

if click ok, then write a code,

ActiveDocument.Reload

Re: Button press triggers script to load first when macro is first action

Wed, 31 May 2017 20:11:54 GMT

this works. thank you. for partial reloads, is there a way to hide the loader screen when reloading?

Re: Button press triggers script to load first when macro is first action

settu_periasamy — Thu, 01 Jun 2017 05:12:34 GMT

Hi Erik,

May be check this link Hide Script Execution Progress Window

i didn't test. so i'm not sure about it.