0 Replies Latest reply: Jun 21, 2012 9:52 AM by Josh Campbell RSS

    Set Variable with Value of Row Count using Macro

    Josh Campbell

      I have an object that I don't display within QlikView. It's designed so that a user makes several filters in other objects and then exports this data set to Excel. But I would like to put in some safeguards so that they can't export 100k rows of data and I want this to display a message so they know why the export did not take place. I've been playing around with the following Macro:

       

      Sub ExportToExcel

      Set chart = ActiveDocument.GetSheetObject("CH668")

      Set p = chart.GetProperties

      Set v = ActiveDocument.Variables("vCount")

      If getVariable = v.GetContent.String > 100 Then

      MsgBox("Please Limit Export to 100 Records")

      Else

      chart.SendToExcel

      END If

      END Sub


      So I have a button which has an action to Run a Macro ("ExportToExcel"). I want it to check the objects' properties, get the row count, store that in a variable ("vCount"), then based on the size of that variable (10, 100, 1000, etc) be able to determine if it should send to Excel. And if it's too large to send to Excel to present a message to the user to limit their selections.

       

      Any ideas would be greatly appreciated.

       

      Thanks,

      Josh