Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

Not applicable

Background Image not working with IE Plugin.

Hi Guys,

How to use image as background while using QlikView IE plugin. Even the QlikView theme having image as background is not working. I am using the AutoZoom macro and when I try to open the file without this macro there is no problem but when I click the application in the browser then I get this error message after sometime:-

Macro parse failed. Functionality was lost
DynamicGroup

Kindly suggest.

AutoZoom Macro I am using is

Sub Autozoom

ActiveDocument.ActiveSheet.FitZoomToWindow

' GetApplication.WaitforIdle

'ActiveDocument.ApplyZoomToAllSheets

END SUB

The same application works fine when opened with AJAX Client.

I am using QV 10. Can anyone help me in this ?

Regards,

Arun

5 Replies
MVP
MVP

Background Image not working with IE Plugin.

Hi Arun,

Is that the only macro you have? Does the image shows when you open without macro and you apply zoom using the Plugin menu? The error suggests you are using a Sub called "DynamicGroup" and that this is the one is cause the issue, is that correct?

Regards.

Miguel Angel Baeyens

BI Consultant

Comex Grupo Ibérica

Not applicable

Re: Background Image not working with IE Plugin.

Hi Miguel,

Thanks for the response.

I am using some other Macros also which are button specific (Activates on click). The image got displayed when I open the file after commenting the AutoZoom macro. I apologize about writing "Dynamic Group". Below is the snapshot of the error.

Error.JPG

Regards,

Arun

MVP
MVP

Re: Background Image not working with IE Plugin.

Hi Arun,

That message usually means that the macro has not been properly coded. The following works on my side

Sub Autozoom

     ActiveDocument.ActiveSheet.FitZoomToWindow

End Sub

Make sure all the code is fine, and all the subs before and after this one are ok, because the macro code is used as a whole, meaning that if one part fails, the whole code is discarded

Hope that helps.

Miguel Angel Baeyens

BI Consultant

Comex Grupo Ibérica

Not applicable

Re: Background Image not working with IE Plugin.

Hi Miguel,

Thanks for the code.

For AutoZoom, I am using the same code as yours.

Below is the code for all the macros I am using :-

 

'***** Macro to minimize and maximize charts(One at a time) *****
sub ToggleViewX
set var = ActiveDocument.GetVariable("VAR_NAME")
Sel = var.GetContent.String
if Sel = 1 then
  activedocument.variables("VAR_NAME").setcontent "0", true
else
  activedocument.variables("VAR_NAME").setcontent "1", true
  activedocument.variables("VAR_NAME2").setcontent "0", true
end if
end sub

'***** Macro to minimize and maximize charts(One at a time) *****
sub ToggleViewY
set var = ActiveDocument.GetVariable("VAR_NAME2")
Sel = var.GetContent.String
if Sel = 1 then
  activedocument.variables("VAR_NAME2").setcontent "0", true
else
  activedocument.variables("VAR_NAME2").setcontent "1", true
  activedocument.variables("VAR_NAME").setcontent "0", true 
end if
end sub

Function FormatResponse(Response)
strResponse = Response
If UCase(Left(strResponse, 1)) = "Y" Then
  FormatResponse = "Y"
Else
  If UCase(strResponse) = "N" or UCase(strResponse) = "NO" Then
   FormatResponse = "N"
  Else
   FormatResponse = strResponse
  End If
End If
End Function
'------------------------------------------------------------------------
Sub Autozoom
ActiveDocument.ActiveSheet.FitZoomToWindow
END SUB

But the point here is that when I disable the AutoZoom Macro or remove the Background Image, everything works fine.

The marco also works perfectly when there is no background image on the sheet. Are you using any image as sheet background or solid color ?

Regards,

Arun

MVP
MVP

Re: Background Image not working with IE Plugin.

Hello Arun,

I'm using the same exact code that you, with an image as background and works fine. Check whether the attached file works in your server/client or it doesn't. It's highly recommended that all Server, Desktop and Client are running the same version.

Hope that helps.

Miguel Angel Baeyens

BI Consultant

Comex Grupo Ibérica