2 Replies Latest reply: Feb 21, 2013 11:52 AM by ben.khalek RSS

    Help with Excel Export

      Hello all,


      I am new to QlikView and VB Scripting. I have a sheet with several Conditional Hidden fields, and different data displays depending on values selected. I am putting an Excel Export button on the sheet to export the data that is visible at the time, however I am not sure of how to set up the VBScript syntax in order to only grab only the fields that are visible. Is there any functionality or parameter I can use in an If condition to get what I need?


      *if field Id is visible = true * <-- How do i do this???


      ActiveDocument.GetSheetObject("field Id").CopyTableToClipboard true




      Thank you.