This content has been marked as final. Show 2 replies
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