topic Delete a variable on OPEN in QlikView

Delete a variable on OPEN

siddharth_kulka — Wed, 17 Nov 2010 03:54:50 GMT

Requirement: Delete a variable for a particular file type, but the variable should stay for the rest.

Hi ,

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.

Regards,

Siddharth

Delete a variable on OPEN

deepakk — Wed, 17 Nov 2010 05:41:26 GMT

HI Siddharth,

Cant we initializes the variable to zero or null(). That would be much easier task.

Delete a variable on OPEN

Miguel_Angel_Baeyens — Wed, 17 Nov 2010 06:44:01 GMT

Hello,

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