topic Re: deleted variable keeps coming up in QlikView

deleted variable keeps coming up

Anonymous — Mon, 28 Mar 2016 20:47:34 GMT

Hi experts,

I am deleting a variable, save the qvw, and run it from the publisher. As soon as the task runs completely the variable is again created in the qvw. What could be the source? Varibale is not being updated by any spreadsheet. I am wondering where I should look for the source that keeps creating deleted variable.

Thanks!

Re: deleted variable keeps coming up

Nicole-Smith — Mon, 28 Mar 2016 20:49:15 GMT

If the variable is being used in the load script, when it runs from the publisher, it is recreating it. At the end of your load script, you can set them to null so that they do not reappear.

For example:

SET YourVariableName =;

Re: deleted variable keeps coming up

Anonymous — Mon, 28 Mar 2016 20:53:17 GMT

Unfortunately, that variable is not being created in loadscript. I have checked load script many times. When the document runs from publisher, it appears. I don't find any trace for that variable in log file.

Re: deleted variable keeps coming up

Nicole-Smith — Mon, 28 Mar 2016 20:58:09 GMT

Can you post the load script or log file?

Re: deleted variable keeps coming up

Anonymous — Mon, 28 Mar 2016 21:06:03 GMT

please find attached.

Re: deleted variable keeps coming up

swuehl — Mon, 28 Mar 2016 21:10:00 GMT

Have you tried clearing the document state from access point (right click on QVW icon on access point)?

Re: deleted variable keeps coming up

Anonymous — Mon, 28 Mar 2016 21:18:17 GMT

I have not deleted but will it have such impact if I directly open the application? I am not opening from access point. I try and taste.

Re: deleted variable keeps coming up

swuehl — Mon, 28 Mar 2016 21:20:53 GMT

You are not opening the QVW from access point, i.e. you are using the desktop client, but the variable will still show up again

Are you using any macros?

Re: deleted variable keeps coming up

Nicole-Smith — Mon, 28 Mar 2016 21:21:29 GMT

I can't find anything in the script that would be creating it either.

Are there any macros in the document? Or a variable trigger set on open?

Re: deleted variable keeps coming up

Anonymous — Mon, 28 Mar 2016 21:23:02 GMT

With your Publisher I presume you reloading it in a Source Folder and publishing it to User Folder.

When you manually delete the variable do you delete it from the qvw in the Source Folder ?

If you delete it from the User Folder only, then on reload & publish the qvw from Source Folder [which has not had the variable deleted] will get reloaded and copied to your User Folder and your variable will reappear in the User Folder qvw..

Re: deleted variable keeps coming up

Anonymous — Mon, 28 Mar 2016 21:26:00 GMT

Yes, I am opening from client. This issue is strange! This document was developed by someone else, I am making some changes. I have found work around but still the issue haunts me. There are some macros but i dont think any macro is related to this issue.

I have listed all macros below-

sub OMT

ActiveDocument.Sheets("OMT").Activate

end sub

sub OMR

ActiveDocument.Sheets("OMR").Activate

end sub

sub Master

ActiveDocument.Sheets("Master").Activate

end sub

sub Main

ActiveDocument.Sheets("Main").Activate

end sub

sub Summary

ActiveDocument.Sheets("Summary").Activate

end sub

sub TPM

ActiveDocument.Sheets("TPM").Activate

end sub

Re: deleted variable keeps coming up

Anonymous — Mon, 28 Mar 2016 21:31:42 GMT

I see the variables emerging again in source folder.

Re: deleted variable keeps coming up

Anonymous — Mon, 28 Mar 2016 21:36:53 GMT

How about if you copy the qvw to another folder, delete the variable and then reload it ?

If no joy then try to delete the variable at the end of the script by setting it to null() :

LET vYourVariable=null();

Re: deleted variable keeps coming up

swarup_malli — Mon, 28 Mar 2016 21:50:46 GMT

You might be referencing an external file which have variables defined in them.

comment out the $Include statement

Re: deleted variable keeps coming up

Anonymous — Mon, 28 Mar 2016 21:53:36 GMT

These things are checked.

Re: deleted variable keeps coming up

swuehl — Mon, 28 Mar 2016 21:56:39 GMT

What's the name of your variable? And where is this variable used / how do you determine that it is recreated?

Re: deleted variable keeps coming up

swarup_malli — Mon, 28 Mar 2016 21:56:40 GMT

My bad I should have read the above replies.Try exporting the script to an external file.Then use that script in a newly created qvw .This might shed some light on what might be happening

Re: deleted variable keeps coming up

swuehl — Mon, 28 Mar 2016 21:58:05 GMT

And have you checked that there is no hidden script?

Re: deleted variable keeps coming up

Anonymous — Mon, 28 Mar 2016 21:59:00 GMT

Yes

Re: deleted variable keeps coming up

swuehl — Mon, 28 Mar 2016 22:08:26 GMT

We can assume this issue is only present when you are using the publisher, so not present when reloading the same QVW in the desktop client? Can you elaborate how the publisher job looks like? Anything special?