Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

ScreenUpdating

I'm looking for the equivalent of the below for VBScript.  Anyone come across this?


Application.ScreenUpdating = False

1 Solution

Accepted Solutions
Not applicable

Re: ScreenUpdating

I was able to resolve my current problem in an un-elegant way.  I still wish there was a way to suppress the screen updating.

I just moved all the objects the VB needed to work with to the same tab as the button the user presses.  However, the objects are off screen and hidden except for when the VB code is executing and since the objects are off screen, the user will not be the wiser about it.

Thanks for trying to assist.

6 Replies
phaneendra_kunc
Not applicable

Re: ScreenUpdating

Are you trying to stop/wait your macro until the UI computation is completed?

ActiveDocument.GetApplication.WaitForIdle

Not applicable

Re: ScreenUpdating

Nope.  I just don't want them to see a few things that the code does as it moves between tabs.  I also suspect it will speed up the code processing time if the screen isn't rendering the whole time.

tresesco
Not applicable

Re: ScreenUpdating

Not really equivalent, still this could help you :

ActiveDocument.GetApplication.Refresh

And, have you tried the document settings? Settings->Document Properties-> Server -> Refresh options

phaneendra_kunc
Not applicable

Re: ScreenUpdating

It is almost like you want to run your Macro which involves in fetching the data in different sheets, but it should not show it to the user that it is switching sheets when macro runs.

seems not possible... if i am not wrong when you try to get the data or to do something on a sheet that sheet/object has to be active..

can you send me a sample app...may be i can think of some thing else.

rustyfishbones
Not applicable

Re: ScreenUpdating

I have a similar Issue for a Extraction file, that also create a folder Structure.

Before I extract the Data I create a Folder Structure, like below using EXECUTE

2014-01-24_1637.png

this works, but the screen seems to flicker rapidly for a couple of seconds and then it's complete, I would like to remove this flickering, this is not VBScript, it's the Qlikview Script Editor.

Is there anything that can stop this?

Regards

Alan

Not applicable

Re: ScreenUpdating

I was able to resolve my current problem in an un-elegant way.  I still wish there was a way to suppress the screen updating.

I just moved all the objects the VB needed to work with to the same tab as the button the user presses.  However, the objects are off screen and hidden except for when the VB code is executing and since the objects are off screen, the user will not be the wiser about it.

Thanks for trying to assist.