5 Replies Latest reply: Aug 22, 2011 4:18 AM by Miguel Angel Baeyens de Arce RSS

    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

        • Background Image not working with IE Plugin.
          Miguel Angel Baeyens de Arce

          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

            • 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

                • Re: Background Image not working with IE Plugin.
                  Miguel Angel Baeyens de Arce

                  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

                    • 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