Background Image not working with IE Plugin.

[#1]

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

[Miguel_Angel_Baeyens]

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

[#3]

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.

Regards,

Arun

[Miguel_Angel_Baeyens]

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

[#5]

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

[Miguel_Angel_Baeyens]

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