Syntax highlighting

Submitted by seebach on Tue, 10/20/2009 - 21:09

I know that this has been a lot talked about. A good text editer with syntax highlighting for QlikView, why on earth does this not exist!? Follow these simple instructions and you will get it. I've been working a few months on getting this right. QlikTech sadly has no xml file with the whole syntax and functions in it. So that I had to copy paste and edit the whole thing from the manual, also I'm slowly working on a fully supported autocompletion function but this might take a while.

To get it running, you need to download Notepad++, which already is my favorite Windows texteditor (I'm more an Emacs type of guy, headless off course).

Notepad++ supports some cool stuff, like ctrl-k out commenting (using //) and ctrl-shift-q (/* */). And folders, which I've set up to give you the power to collapse an entire LOAD statement or a /* */ part of a script for super easy overview. Press alt-0 to collapse the whole script.

I'm also working on getting parameters for functions displayed. And since QlikView does not provide this easily, its a lot of copy pasting from the manual. And I'm not very far. 10 functions in total are currently supported.

Press ctrl-space and it will try to autocomplete your typing. Or you have this feature permanently on from the Settings > Preference > Backup/AutoCompletion setting. All functions in the QlikView 9 manual should be supported. If its not in the manual, you wont find it here.

Its setup to reconize .qvs files as being QlikView Script files. And in the preference you can set Notepad++ to be default editor for these files.

To install it all, follow these 3 steps:

This should work for XP, Vista, Win Server 2003 & 2008 and hopefully Win7 (not tested).

Sadly the UserDefine file has to be put into each users home directory in order to work. It would be great if I could build a generic file for all users. So remember to copy it around if your on a server.

Please post improvements and ideas here. Ill try to post updated versions every now and then!

 I hope you enjoy using it as much as I enjoyed building it. Cheers! /Seebach

Re

Submitted by Anonymous on Fri, 02/12/2010 - 05:02.

I am willing to tell that a reliable essays online service supposes to be a light on the road of argumentative essay accomplishing. Hence, people should use it every time they would like to buy essay.

%APPDATA%

Submitted by Anonymous on Tue, 10/27/2009 - 02:15.

the problem with the %APPDATA% disappears when, on one of the installation screens, it comes to that:

http://i406.photobucket.com/albums/pp148/petcumihai2002/notepadinstallAP...

and you check that option.

i've saved the userDefineLang.xml file in Notepad++ instalation directory (C:\Program Files (x86)\Notepad++) and it works.
(i'm on Windows 2003 Server R2)

%APPDATA%

Submitted by Anonymous on Tue, 10/27/2009 - 02:15.

the problem with the %APPDATA% disappears when, on one of the installation screens, it comes to that:

http://i406.photobucket.com/albums/pp148/petcumihai2002/notepadinstallAP...

and you check that option.

i've saved the userDefineLang.xml file in Notepad++ instalation directory (C:\Program Files (x86)\Notepad++) and it works.
(i'm on Windows 2003 Server R2)

%APPDATA%

Submitted by Anonymous on Tue, 10/27/2009 - 02:13.

the problem with the %APPDATA% disappears when, on one of the installation screens, it comes to that:

http://i406.photobucket.com/albums/pp148/petcumihai2002/notepadinstallAP...

and you check that option.

i've saved the userDefineLang.xml file in Notepad++ instalation directory (C:\Program Files (x86)\Notepad++) and it works.
(i'm on Windows 2003 Server R2)

Nice work, very cool. Tom

Submitted by Anonymous on Thu, 10/22/2009 - 20:19.

Nice work, very cool.

Tom

%APPDATA%

Submitted by Anonymous on Tue, 10/27/2009 - 02:16.

the problem with the %APPDATA% disappears when, on one of the installation screens, it comes to that:

http://i406.photobucket.com/albums/pp148/petcumihai2002/notepadinstallAP...

and you check that option.

i've saved the userDefineLang.xml file in Notepad++ instalation directory (C:\Program Files (x86)\Notepad++) and it works.
(i'm on Windows 2003 Server R2)

thanks!!!!

Submitted by Anonymous on Tue, 10/20/2009 - 22:11.

very, very, very nice job! thanks a lot!!!

Small bug

Submitted by Anonymous on Wed, 10/21/2009 - 18:27.

First of all, great work! I'll try to make some bug reports so you can make it even better:

First finding:
if you put in:

SET ENDDATE = "20061231";// When does the calendar blabla

There is no space between ; and // so the highlighting goes wrong

Second finding:
//comment doesn't work, but if you put in a space between // and comment you're allright

bugs

Submitted by seebach on Thu, 10/22/2009 - 10:07.

Hi,

You're right. Notepad++ has some limitations. I'll try to see if there's a workaround.

Notepad++ for QV

Submitted by Anonymous on Thu, 10/22/2009 - 19:52.

Nice jobn mate - thank you very much!
Alexis

Be sure to activate it!

Submitted by Anonymous on Mon, 01/18/2010 - 23:23.

Very nice!

To anyone for whom the installation isn't working, make sure to load up a .qvs file in Notepad++, go up to Language on the menu bar, and click QlikView Script at the bottom of the list. That seemed to create the permanent association in Notepad++ for me.

Comments /**/

Submitted by Anonymous on Wed, 01/27/2010 - 15:40.

First of all, great job. Is it just me or when you use /* the whole text forward should turn green italic until the you close it with */
At the moment that does not happen. Thanks.