End of the script don't want to see the variable

[veerendrakatika]

I had a question regarding backed variables. I have created two variables in backed script which i could see in front end too in variable overview by default. but my requirement was by end of the reload section i don't need to see these variable in front end. Please help me out.

Thanks

-Veerendra

[avinashelite]

at the end of the script try like this

SET vVariable1='';

SET vVariable2='';

[veerendrakatika]

I didn't installed QlikView on my machine and I couldn't check. I believe this will not show value of the variable.Even I don't want to see Variable name too in front end.

Could you confirm will it be return as I desired?

-Veerendra

[marcus_malinow]

Hi Veerendra,

you can't delete a variable in a load script, you can only delete the content (as suggested by Avinash). In order to delete the variable, you have to either delete it from the Variable Overview screen, or possibly via a macro.

Seems like a strange request - if you don't expose a variable then users won't be able to see it anyway.

Marcus

[dberkesacn · Accepted solution]

Hi,

if it is already exists you only can assign null with the mentioned commands, and you have to go to variable overview and delete it or write a macro.

If you have the null setting commands when you first create the variable it won't be visible in the variable overview.

I suggest delete it manually and insert a SET vVariable2=''; command and run the script, it will work.

Clear variable since the script

From HIC.

"

If you clear the variable in the end of the script using

     Let vVariable = Null() ;

or

     Set vVariable = ;

and delete the variable in Settings > Variable Overview, the variable will be automatically deleted at the end of the script every time.

HIC

"

[avinashelite]

if you have not created the variable in the front end then sure it will delete otherwise you need to drop it in the front end also

[marcus_malinow]

Wow, nice trick!

Will remember that one

[dberkesacn]

if you have the Let vVariable = Null(); or set ...  statement when you haven't executed the script with the variable the variable wont exist in the fronted, check it.

So that's why i suggest delete it manually once and run it with clear set / let  statements.

[dberkesacn]

reference: http://www.qlikfix.com/2010/10/09/deleting-script-variables/

[dberkesacn]

thanks