topic Re: Cleaning up variables in QlikView

Cleaning up variables

datanibbler — Thu, 09 Oct 2014 20:08:15 GMT

Hi,

I am always trying to keep my QlikView_apps slim and tidy and understandable for outsiders.

One thing that has been bothering me is variables that are not needed anymore or are not even part of the code anymore, but that have been created at some time or other and are still around there.

=> Is there any way to delete variables after they have been used?

Thanks a lot!

Best regards,

DataNibbler

Re: Cleaning up variables

Anonymous — Thu, 09 Oct 2014 21:02:24 GMT

Hello.

Yes, you can delete variables that you won't need anymore. Just use:

Set variable = ;

There's one caveat. It only work for variables that were created for the first time in the script. If the variables are already in the Variable Overview, you'll need to delete them there first.

Regards.

Re: Cleaning up variables

datanibbler — Fri, 10 Oct 2014 08:29:10 GMT

Thanks Bruno!

I'll try that out immediately. Can I also clean up files (qvd) that I have created in the process?

Re: Cleaning up variables

tresB — Fri, 10 Oct 2014 08:34:09 GMT

Try like:

Execute CMD.EXE /C del "qvdname.qvd";

Re: Cleaning up variables

datanibbler — Fri, 10 Oct 2014 08:58:34 GMT

Hi tresesco,

that sounds promising. I was supposing you could do some cool things with that EXECUTE command, but honestly I'm not good at working in the command line.

Thanks a lot!

I'll try.

Re: Cleaning up variables

datanibbler — Fri, 10 Oct 2014 09:15:44 GMT

Hi tresesco,

I am getting an error that the command may not be executed because I don't have the access_rights. I wonder why - the file I want to delete is on the QlikViewServer which I have RW access to.

Do I have to specify the complete file_path? I guess I do ...

P.S.: Well, I still got the error, but this time round I clicked on OK and the command was executed anyway. Of course there's no way I can manually execute the script in the time_interval we need and click on OK at this point every time.

=> Is there any way I can pass something like the /f (force) option?

Re: Cleaning up variables

tresB — Fri, 10 Oct 2014 09:18:44 GMT

Goto edit script->Settings(tab - the left bottom)->Check 'Can Execute External Programs'

Re: Cleaning up variables

Peter_Cammaert — Fri, 10 Oct 2014 09:20:16 GMT

Yes, you have to specify a path to every QVD (you can use variables to make that more flexible). Otherwise, the reload engine will try to find those QVD's in the directory where the QVW model resides (User Documents), or where you were after the last Directory; script statement.

Re: Cleaning up variables

datanibbler — Fri, 10 Oct 2014 09:23:04 GMT

Hi tresesco,

that worked.

I got a dialog_field once, but now it seems the script runs without asking.

Thank you!

Re: Cleaning up variables

datanibbler — Fri, 10 Oct 2014 09:36:06 GMT

O_O - I still get that dialog_window and have to confirm that I want to run the script with access to external files ...

Re: Cleaning up variables

tresB — Fri, 10 Oct 2014 09:42:28 GMT

User Preference->Security->Check: 'Script(Allow Database Write and Execute Statement'

Re: Cleaning up variables

datanibbler — Fri, 10 Oct 2014 09:48:15 GMT

Good. There's just one caveat to that: In the long run, the app will be executed regularly on the server. The QlikView_user (the user that we have specified on the server to do all the reloading) does not have a QlikView_client installed, though.

Is there any way around that?

Needless to say, it would not be a big thing to just leave the files there - the script is supposed to run every 30min, so it doesn't make much of a difference. It would be a nice_to_have and an addition to our internal_development_standards - to always clean up after yourself just like you (are supposed to) do in real life 😉

Re: Cleaning up variables

tresB — Fri, 10 Oct 2014 09:53:58 GMT

I am bit confused now. Did I hear that your application server would not have qv client installed? Qv would get reloaded in a server where there is no qv client installed?

Re: Cleaning up variables

datanibbler — Fri, 10 Oct 2014 10:15:32 GMT

You surely didn't hear that except if your computer has the ability to speak everything in a forum 😉

But yes, that's how it is - we have the QlikViewServer, and that takes care of all the reloading - well, I confused something. The QlikView-user does not have a license, that was never necessary. I'll have a look if there is a client installed. I can log on as that user. Just a moment.

P.S.: Yes, there is a client - when I log on as that user. I already ticked that checkbox. So that, combined with the setting in the script_editor, should do the trick. I'll try.

Re: Cleaning up variables

Fri, 10 Oct 2014 13:40:24 GMT

Running the Execute some time hangs up on the server. In Qlikview 11 we have a option to run the external scripts.

So first schedule a task running your App. Create the dependent external schedule job to clean up the qvd files.

QEMC --> System --> External Program

Re: Cleaning up variables

datanibbler — Fri, 10 Oct 2014 15:57:15 GMT

Hi all,

I'll try this out. Cleaning up the files after use is essential here because the next time round, the code will run on another base_data_list, there might not be new files to replace them and then they'll end up being appended and mess up the output.