topic Clear/Delete a variable in QlikView

Clear/Delete a variable

lucarizziero — Wed, 29 Apr 2009 20:57:55 GMT

Hi all,

I use some variables inside the load script, but I'd need to delete them after the loading has finished.

Thanks

Clear/Delete a variable

Wed, 29 Apr 2009 21:02:05 GMT

If your familiar with macro's you can write one that says var = ''.

Clear/Delete a variable

Anonymous — Wed, 29 Apr 2009 21:10:10 GMT

LET varname=null();

Clear/Delete a variable

lucarizziero — Wed, 29 Apr 2009 21:10:23 GMT

Hi James,

I know: but doing so I still have those variables inside the variable list of the Document Properties ! is it possible to remove them ?

Clear/Delete a variable

Anonymous — Wed, 29 Apr 2009 21:14:35 GMT

Oh, and I have to add that if you got these variables on the front end already, make sure to delete them manually. After this the =null() will prevent creating variables on the front end.

Regards,
Michael

Clear/Delete a variable

Wed, 29 Apr 2009 21:14:38 GMT

The manual states:

'all variables used in the script are copied out to layout variables at the end of script execution.'

so I assume this means you would have to manually delete them after reloading the document (each time).

I wouldnt have thought they take up much space though - why worry about them?

Regards,

Gordon

Clear/Delete a variable

rwunderlich — Thu, 30 Apr 2009 03:45:04 GMT

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=;

They may not take up much space, but I find that they do clutter up the variable overview and con sometimes complicate understanding the app.

-Rob

Clear/Delete a variable

Wed, 30 Sep 2009 05:40:40 GMT


Rob Wunderlich wrote:
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=;
They may not take up much space, but I find that they do clutter up the variable overview and con sometimes complicate understanding the app.
-Rob<div></div>

Hi rob,

I used this in QlikView 8.5 ... but when trying this in QlikView 9 neither LET v=null(); nor SET v=; works ...
Does this work for you in QlikView 9 (SR1) or am I missing something?

Best regards

Stefan

Clear/Delete a variable

Anonymous — Wed, 30 Sep 2009 08:43:11 GMT

Stefan,
(I'm no Rob, but your message is not exactly private...)

It works for me in QV9, and I don't use SR1 yet. Did you try to delete your variables manualy on the front end? If they exist already, script is not going to remove them.

Clear/Delete a variable

Wed, 30 Sep 2009 16:01:27 GMT


Michael Solomovich wrote:
Stefan,
(I'm no Rob, but your message is not exactly private...)

It works for me in QV9, and I don't use SR1 yet. Did you try to delete your variables manualy on the front end? If they exist already, script is not going to remove them. <div></div>

Hi,

yes, sure deleting the variables manually works as expected; but it does not work in the load script by setting the variable to null as described above ...

Best regards
Stefan

Clear/Delete a variable

rwunderlich — Wed, 30 Sep 2009 17:02:05 GMT

It works for me in 8.5 and QV9 SR1. Given the script:

Set A=bcd;
SET A=;

or:
let a = null();

In both cases the variable does not appear in the front end. Note that the previous caveats in the thread still apply -- if the variable ever appears in the front end it must be deleted manually using the dialog.

-Rob

Clear/Delete a variable

Wed, 30 Sep 2009 18:02:00 GMT


Rob Wunderlich wrote:
It works for me in 8.5 and QV9 SR1. Given the script:
Set A=bcd;
SET A=;
or:
let a = null();
In both cases the variable does not appear in the front end. Note that the previous caveats in the thread still apply -- if the variable ever appears in the front end it must be deleted manually using the dialog.
-Rob<div></div>

Thanks Rob,

now I have the point and could reproduce the logic behaviour:

As you said: If the variable ever appears in the front-end (after script load) it must be deleted manually ... :))

Best regards

Stefan

Re: Clear/Delete a variable

evan_kurowski — Tue, 18 Nov 2014 15:29:48 GMT

Hello Rob, Thanks for the help.

Reading this carefully it was important for me to grasp the distinction between a script created var, and one that had a definition created via the Settings | Variable Overiew option. I was confused why my variables were not deleting at times, and now it seems clearer. Thank you.