2 Replies Latest reply: Feb 9, 2017 3:50 PM by Digvijay Singh RSS

    object in the qlikview document has to get refreshed daily once

    kiran kumar

      Hi,

      I have four charts in my dashboard in which 2 charts has to be refreshed for every 15 mins as new input source arrives every 15 min but 2 charts has to be reloaded daily once to get the trends for the dimensions daily.

      When I checked the Qlik community one way of doing this by writing a macro based on selection of value to attach and detach the charts

      Used the below macro in f

      Attach/Detach

      You could achieve this by macro.

      Something like this:

      SUB TEST
      v_AgentCnt = ActiveDocument.Evaluate("=GetSelectedCount(REGION)")
      If v_AgentCnt>0 Then
      ActiveDocument.GetSheetObject("CH01").Detach
      Else
      ActiveDocument.GetSheetObject("CH01").Attach
      End If
      END SUB

       

      And put it on the field you want (Document/Properties/Triggers/Field Event Triggers) on OnChange event.

       

      But when  I am testing the macro it is throwing an error

      Object doesn't support this property or method: 'ActiveDocument.GetSheetObject(...).Detach'

       

       

      Can you please let me know if there is a simple way to achieve this requirement...

       

      Thanks

      @