topic Re: Remove Variables From Script in QlikView

Remove Variables From Script

gireesh1216 — Thu, 18 Feb 2016 06:55:59 GMT

Hi, how can I remove variables from script level?

Re: Remove Variables From Script

Anonymous — Thu, 18 Feb 2016 19:15:22 GMT

If you assign a variable to null() it will be removed :

Let vYourVariable = null() ;

Re: Remove Variables From Script

rubenmarin — Thu, 18 Feb 2016 19:41:22 GMT

As Bill said you only need to remove the variable value, this also works:

Let vYourVariable =;

So far I know, if the variable is already created you have to manually delete it from the document.

Re: Remove Variables From Script

Anonymous — Fri, 19 Feb 2016 05:39:39 GMT

If this question is more about deleting the existing variable objects (and not resetting their value) that you see in the Variable Overview window, then the only way would be to click on individual variable and click remove one by one.

Re: Remove Variables From Script

jagan — Fri, 19 Feb 2016 05:43:14 GMT

Hi,

You can try like this

LET vVariableName =;

LET vVariableName = Null();

Regards,

Jagan.

Re: Remove Variables From Script

Chanty4u — Fri, 19 Feb 2016 05:46:08 GMT

chk dis

both macro and variable

Re: Clear/Delete a variable

Re: Delete variables in loading scripts

Re: Remove Variables From Script

jonathandienst — Fri, 19 Feb 2016 05:50:12 GMT

These techniques, including

Set vVar =;

will remove the variable when the script terminates, providing that they did not exist before the script started. So you may need to delete the variables manually for the "deletion" to work.

This is so that you can remove script-only variables that are not required in the front end.

Re: Remove Variables From Script

ramasaisaksoft — Fri, 19 Feb 2016 07:11:02 GMT

Hi Gireesh,

1)First i have a doubt y you wan't to delete variables? those are not harm full to your app

just skip the usage of variables in Expression

2) All variables are located at Settings->Variable over view(Ctrl+Alt+V)->here you can select the variable and click on Remove button and save the app

Re: Remove Variables From Script

jonathandienst — Fri, 19 Feb 2016 07:58:31 GMT

You may have variables used in your load script that are not relevant to the front end. The delete options outlined above will remove these when the script run is complete. That reduces the clutter in the variable overview or in the expression editor variable list in the front end. It no more than housekeeping and (IMO) good practice.

Re: Remove Variables From Script

gireesh1216 — Fri, 19 Feb 2016 13:10:22 GMT

Thank you all