topic Edit Script Function in QlikView

Edit Script Function

Wed, 29 Jul 2009 03:15:44 GMT

Using QV 8.5 latest build. Had no problems till today. Every time I hit the Edit Script button the program freezes and I have to use CTRL-ALT-DEL to end program.

QV will reload, run macros and all files and sheets are working just I can't edit script. The system does not show not responding or an error at all.

Thanks for any help provided.

Edit Script Function

Anonymous — Wed, 29 Jul 2009 06:35:47 GMT

Does it happen with a specific qvw file or with any file? I'd recommend to uninstall and reinstall QlikView.

Edit Script Function

rwunderlich — Wed, 29 Jul 2009 08:29:14 GMT

I have had this happen before with a single QVW. (If it's happening with all your qvws, I'd go with Michael's suggestion of reinstalling).

If it's just one file, you'll have to rebuild the file using a backup. Or you can try to extract the script with this macro:

Sub extractScript
Set objTextFile = openOutputFile("C:\myscript.qvs")
objTextFile.WriteLine(ActiveDocument.GetProperties.Script)
objTextFile.Close()
End Sub

Function openOutputFile(filename)
Rem *** Create and open an output file
CONST ForWriting = 2
Set objFSO = CreateObject("Scripting.FileSystemObject")
Set openOutputFile = objFSO.OpenTextFile (filename, ForWriting, True)
End Function

Code it in your module and run it with Test. You'll have to grant System Access. That will extract your script to a file. Then run another macro like:

Sub fix
set docprop = ActiveDocument.GetProperties
docprop.Script = "empty"
ActiveDocument.SetProperties docprop
End Sub

Then if you can edit the script, you can copy/paste from the file -- after looking it over for weirdness.

-Rob

Edit Script Function

Anonymous — Wed, 29 Jul 2009 10:35:16 GMT

If it's a specific document I've seen this happen where global variables have been defined in the Macro module. Try commenting out everything in the macro module which is not enclosed within Subs or Functions and see if that lets you access the script.

Edit Script Function

Wed, 29 Jul 2009 10:45:13 GMT

Unfortunly its EVERY document including starting a new file and the samples.

Edit Script Function

Anonymous — Wed, 29 Jul 2009 12:23:29 GMT

Hmm..

I'm thinking that the coordinates for the script window might have become messed up somehow so that the window is actually opening outside the visible computer screen and taking focus from QV so that it appears to have hung.

After clicking Edit Script, hold down Alt, push Space once and hit M (as in move). Then let go of all keys and use the arrow keys to try and move the script window into the screen area. Hope this works.

Edit Script Function

Anonymous — Wed, 29 Jul 2009 20:04:37 GMT

jsn,
This is exactly what I was thinking about. And, occasionally it happens to the "edit macro" window as well. I think that QlikTech has a utility to restore the position of the edit script window, hasn't it?

Edit Script Function

Wed, 29 Jul 2009 20:22:09 GMT

It worked. Thanks jsn and to all who suggested answers and help it was greatly appreciated.

Edit Script Function

Wed, 29 Jul 2009 21:34:43 GMT

I have had this happen if I use QlikView with a second monitor and extend the desktop to that monitor. If I move the editor screen to the second monitor, then later open QlikView without the second monitor the Editor still opens where it was with the second monitor. I do notice that I can see the edge of the editor window at the edge of my screen, and my mouse pointer turns into an arrow so I can drag the editor edge into view.

I wonder, can we class this as a bug?

I had forgotten the Alt-M trick though - good call.

Edit Script Function

Anonymous — Thu, 30 Jul 2009 10:15:45 GMT

Michael,

Not sure on the app to reset the window pos. I did however track down the registry value for this so that one can check it manually:

Computer\HKEY_CURRENT_USER\Software\QlikTech\QlikView\WindowPos

DlgPos334 - Script Editor

For example:

193,132,960,641,0

TopLeftX, TopLeftY, BottomRightX, BottomRightY, Maximized (1/0)

Edit Script Function

Anonymous — Thu, 30 Jul 2009 19:34:20 GMT

jsn,
It's good enough, thanks! Especaily that the DlgPos334 is for the script editor.
Can we get the macro editor? Variables overview?

Edit Script Function

Anonymous — Thu, 30 Jul 2009 19:51:25 GMT

Yeah.. I looked it up manually. Took a screenshot of the registry and then moved the script editor and compared. The principle is the same for the others but I'm on macos at the moment so I can't help you out there.

Edit Script Function

rwunderlich — Fri, 31 Jul 2009 01:52:17 GMT


Michael Solomovich wrote:Especaily that the DlgPos334 is for the script editor.
Can we get the macro editor?

If you're up for it, an easy way to determine the various registry keys is to use a monitoring tool like Procmon or Regmon from Sysinternals -- free tools now distributed by Microsoft at http://technet.microsoft.com/en-us/sysinternals/bb545027.aspx

Technically, Regmon is for older versions of Windows but it works fine on my XP. Regmon has filters so you can monitor just want you want like "HKCU\SOFTWARE\QlikTech\QlikView\WindowPos\*". Procmon has filters also, a little more complex to setup because it monitors more than RegKeys.

Using Regmon, I can see that the WindowPos keys are:

DlgPos334 - Script Editor V9
DlgPos332 - Script Editor V8.5
DlgPos257 - Macro Editor V9
DlgPos254 - Macro Edito V8.5

Thought it was interesting that they differ between releases.

-Rob

Edit Script Function

Anonymous — Fri, 31 Jul 2009 07:19:42 GMT

Here, I knew I had it... It is QlikTech's file. No any documenmtaion or description though.

Edit Script Function

Thu, 27 May 2010 12:36:19 GMT

Thank you very much guys. I was absolutly lost.

Sergio

Re: Edit Script Function

Tue, 27 Mar 2012 16:08:26 GMT

Hi Rob,

I tried below macro code for adding new script line into existed tab "Main 2" ,

but the below code working like creating another new tab "Main 2" and adding the script line as $(Include=d:\vqd eat\text\test.txt);

what to change in below code for to work like add new script line in existed tab "Main 2" ?

docprop.Script = docprop.Script & chr(13) & chr(10) & "///$tab Main 2" & chr(13) & chr(10) & "$(Include=d:\vqd eat\text\test.txt);"

Thanks in advance