Automatically delete script generated variables

When building a QlikView or Qlik Sense script you sometimes generate large amounts of variables during reload. These variables will still be present in the Variables Overview after reload. This is not always the behavior you want as the overview can become cluttered with thousands of generated variables.

If the variable was created in the script, and it is empty, it will not be copied out to the layout.

So a script created variable can be deleted either with:

LET v=null();

SET v=;

Run for example this script below in a new document:

Set vTest=1;

LET vTest=null();

Note that no vTest variable will exist in the variable overview. However, if you already had a vTest variable from before, it will still be there! 

 1. Make sure you have no variables in your variable overview. 

2. Make sure you let your generated variables be Null at the end of your Loop in the script.

Other options:
If you are using QlikView you can delete them manually by using the Project Folder and removing it directly from the XML files. https://help.qlik.com/en-US/qlikview/November2017/Subsystems/Client/Content/QlikView_Project_Files.htm

In Qlik Sense you don't have that option, but you can instead do this with the Variable APIs https://help.qlik.com/en-US/sense-developer/3.0/Subsystems/APIs/Content/MashupAPI/qlik-variable-interface.htm