Discussion Board for collaboration related to Creating Analytics for QlikView.
Requirement: Delete a variable for a particular file type, but the variable should stay for the rest.
Has any one attempted to delete a variable on document open.
I couldn't find a macro event/property to achieve the same
Any suggestions will be appreciated.
Cant we initializes the variable to zero or null(). That would be much easier task.
Try with the following macro
Sub CleanUp ActiveDocument.RemoveVariable "vVar"End Sub
the variable will be deleted completely from your script, as if you go to Settings menu, Variable Overview and delete it.
Besides, opening on server (via ajax, plugin) is likely not to trigger OnOpen and OnPostReload macros properly. In this case, you should create a different event.
Hope that helps