9 Replies Latest reply: Sep 29, 2014 1:17 PM by Matthew Fryer RSS

QlikView in Notepad++

Matthew Fryer

After finding broken links for other posts about QlikView syntax highlighting in Notepad++ I created a basic Notepad++ language definition myself and thought I'd share it. Its far from perfect but it but it does the basics and makes working with .qvs files in Notepad++ a bit easier. Details and links here http://www.qlikviewaddict.com/2012/04/qlikview-scripts-in-notepad.html

 

Regards

Matt

  • QlikView in Notepad++
    Matthew Fryer

    I've released an updated version of the language definition that should now support all keywords, statements and functions as well as line and block comments. Details and links here http://www.qlikviewaddict.com/2012/05/qlikview-for-notepad-update.html

     

    Regards

    Matt

  • QlikView in Notepad++
    Matthew Fryer

    I've released version 0.3 which removes the escape character "\" from the language definition as it isn't needed for QlikView syntax highlighting and caused issues if the "\" appeared in the script. Details and links here http://www.qlikviewaddict.com/2012/06/qlikview-for-notepad-update.html

     

    Regards

    Matt

  • Re: QlikView in Notepad++
    Matthew Fryer

    Version 0.4 is available. A few minor changes and improvements. Download links and instructions available here http://www.qlikviewaddict.com/p/qlikview-notepad.html

     

    Regards

    Matt

  • Re: QlikView in Notepad++
    Matthew Fryer

    Since I've had no reports of issues I'm now releasing Version 1.0. A few minor tweaks have been included in this release that weren't in version 0.4. Most notably "REM" was removed from the keywords list to prevent incorrect highlighting of it. Download links and instructions available here http://www.qlikviewaddict.com/p/qlikview-notepad.html

     

    Regards

    Matt

  • Re: QlikView in Notepad++
    Matthew Fryer

    I've released a new major update (version 2.0) with the following improvements:

     

    • Improved code section folding
    • Improvements to keyword combinations to prevent incorrect highlighting (eg. INFO should not be highlighted unless it is followed by LOAD of SQL)
    • Added missing "GROUP BY" keyword
    • Number formats support hex even though no formatting is shown for numbers within QlikView by default (prevents correct highlighting if appears in a string).
    • Auto-completion of all keyworods and functions
    • Tool tips shown for most commonly used functions (including colour, string, aggregation, numeric, inter-record and many other functions).

     

    As before, download links and instructions available here http://www.qlikviewaddict.com/p/qlikview-notepad.html

     

    Regards

    Matt

  • Re: QlikView in Notepad++
    Matthew Fryer

    Notepad++ version 6.4.1 was released recently and contains some exciting new additions.Top of the list is the new function list which has been awaited for a while now and is a popular feature in many other code editors (including UltraEdit).

     

     

     

    Because of these changes I've released a new version of the QlikView language definition v2.1 to support them where possible. This is another significant update and includes:

     

    • New function list support allowing Notepad++ to show subroutines, qualify and unqaulify statements, table loads, info loads, mapping loads and store statements all identified within the function list.
    • Removed some functions from the auto-complete file as they are only valid in expressions not the script.
    • Changed priority of highlighting to fixed issue with some keywords not highlighting correctly
    • Fixed some minor issues with keywords being highlighted when they were shown in the wrong positions.
    • Added tool tips for some additional functions.

     

    This version has the following known limitiations:

     

    • The if() function cannot be differentiated from the IF...ENDIF statement and thus will be shown as a collapsible block with an incorrect end point.
    • Tool tips are not available for all functions. Remaining functions to be added in a future release.

     

    As usual, download links and instructions available here http://www.qlikviewaddict.com/p/qlikview-notepad.html

  • Re: QlikView in Notepad++
    Vadim Tsushko

    Hi Matthew.

     

    Do you consider registering your plugins on http://branch.qlik.com/projects ? It would be great, I believe

     

    Best regards, Vadim 

  • Re: QlikView in Notepad++
    Matthew Fryer

    I've just released a new version of the QlikView Notepad++ Language Definition. Version 2.3 contains the following minor fixes/functionality:

    • Solved an issue with correct highlighting of nested function calls. Added comma "," as an operator to correct issue with function names not being highlighted correctly when it immediately follows a comma inside another function call.
    • Added missing function tool tips. All functions should now provide both auto completion and tool tips.
    • Removed the ability to fold IF statements because of an issue where Notepad++ tries to collapse if() functions which causes the collapsing to fail. 

     

    Additionally, I have moved the project to GitHub and have added it to http://branch.qlik.com/ too. As always, head over to the Notepad++ Language Definition page (or Branch) for the download link and instructions.

     

    Regards

    Matt