15 Replies Latest reply: Mar 27, 2012 12:08 PM by Ravi Kumar

Edit Script Function

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

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

• Edit Script Function

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

• Re: Edit Script Function

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);"

• Edit Script Function

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

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

• Edit Script Function

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

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

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

• Edit Script Function

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

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

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

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

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

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

• Edit Script Function

Thank you very much guys. I was absolutly lost.

Sergio