Qlik Community

QlikView Publisher

Discussion Board for collaboration on QlikView Publisher.

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

Regular Document Reloads - loss of macro functionality?

Hi All

I have 2 problems with a document.

I have the server reloading the document every 2 minutes.

In the document's properties on the Server tab I have "Server perfomrs refresh automatically without client action" ticked and "Enable Push from Server" and "Enable Dynamic Data Update" also ticked.

On the document I have a button linked to a macro that does the classic fitzoomtowindow like:

sub FixZoom
ActiveDocument.ActiveSheet.FitZoomToWindow
ActiveDocument.GetApplication.WaitForIdle
ActiveDocument.ActiveSheet.ApplyZoomToAllSheets
End Sub


When I have the document open, in the IE Plugin, when I first open it the button works fine. Then when the document refreshes after 2 mins I lose the zoom (problem 1 - it reverts to 100% zoom) and also even if I then click my macro button to fix the zoom it no longer works (problem 2)?

If anyone has an idea I'd appreciate any advice you could give!

Thanks

Dominic

Tags (3)