topic Re: ScreenUpdating in QlikView

ScreenUpdating

Fri, 24 Jan 2014 05:10:50 GMT

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

Application.ScreenUpdating = False

Re: ScreenUpdating

phaneendra_kunc — Fri, 24 Jan 2014 05:23:06 GMT

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

ActiveDocument.GetApplication.WaitForIdle

Re: ScreenUpdating

Fri, 24 Jan 2014 05:26:08 GMT

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.

Re: ScreenUpdating

tresB — Fri, 24 Jan 2014 05:33:25 GMT

Not really equivalent, still this could help you :

ActiveDocument.GetApplication.Refresh

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

Re: ScreenUpdating

phaneendra_kunc — Fri, 24 Jan 2014 16:30:59 GMT

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.

Re: ScreenUpdating

rustyfishbones — Fri, 24 Jan 2014 16:41:51 GMT

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

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

Re: ScreenUpdating

Fri, 24 Jan 2014 16:43:35 GMT

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.