Merry Christmas

Just a quick post to wish you all a very merry Christmas. I shall be enjoying our first Christmas with our new junior QlikView addict who it seems has been spoilt rotten.

I've been somewhat lax at posting recently but I'll do my best to get back to writing some more. I have a long list of ideas for new posts.

Regards
Matt

QlikView Notepad++ Language Definition v2.2

I've just released a new version of the QlikView Notepad++ Language Definition, mainly to correct an issue with the function list support not working with the latest release of Notepad++ (version 6.5 onwards). This release also contains the following additional fixes/functionality:

• Corrected a minor issue with the DISTINCT keyword not being highlighted in some situations.
• Added a check to ensure line comments terminate at an End Of Line (EOL) character.
• Corrected issue with operator identification. Although operators are not highlighted in QlikView, correct identification prevents incorrect highlighting of keywords and functions when an operator buts up against it. 
• Added additional operators to fix some minor issues with incorrect highlighting of keywords.

As always, head over to the Notepad++ Language Definition page for the download link and instructions.

Thanks go to Bruno Santos for pointing out the function list issue and testing the fix!

The new version of Notepad++ also has auto-completion turned off by default. You can turn it back on quite easily though:

1. Select Settings -> Preferences... from the menu bar. 
2. Select Auto-Completion from the list on the left and then ensure the options are set as follows:

 

The options under Auto-Insert are optional and enable auto insertion of closing brackets and quotes are automatically entered when an opening bracket or quote is typed.

Half price Packt books until Thursday

The guys and gals over at Packt Publishing are having a half price sale on all ebooks and videos until Thursday 17th October 2013. That means you can grab the great QlikView 11 for Developers and the recently released QlikView for Developers Cookbook as ebooks for 50% off the listed prices.

There are no catches or twists, all you have to do is head on over to the Packt website and enter the discount code COL50 at the checkout. Simples!

QlikView Notepad++ Language Definition v2.1

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).

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, head on over to the QlikView Notepad++ page to grab the download and instructions of how to update. If you find any issues, leave me a comment below and I'll try resolve them in a future release.

QlikView for Developers Cookbook

Stephen Redmond (from the well known QlikTips.com) has been busy writing a sequel to QlikView 11 for Developers which I reviewed a couple of months ago. Unlike it's predecessor, QlikView for Developers Cookbook looks at a serious of "recipes" for solving well known QlikView problems.

Coming from Stephen you can guarantee some advance QlikView content and great advise. I'm eagerly awaiting my copy for review.

You can grab your own copy now from http://www.packtpub.com/qlikview-developers-cookbook/book

The UltraEdit Function List with QlikView Script Files

Since the release of version 1.0 of the QlikView wordfile for UltraEdit I've had a few people ask me what the UltraEdit function list support offers and how to use it, so here goes.... 

It might seem obvious but you need to have installed the QlikView wordfile before the functionality described below will work. If you haven't already, details of how to do so can be found on the QlikView for UltraEdit page.

The function list can be shown in UltraEdit by either going to "View -> Views/Lists -> Function List" on the menu bar or by pressing F8. By default the function list is shown on the right hand side of the screen but can be dragged and docked to just about anywhere you want it to sit.

QlikView UltraEdit Wordfile v1.0

Hot on the heals of the QlikView Notepad++ Language Definition v2.0 comes the release of the Wordfile version for those who prefer to use UltraEdit instead. Like the Notepad++ version, this is a big update from the previous version (v0.2) and adds the following:

• Improved code section folding
• Added missing "GROUP BY" keyword
• Auto-completion of all keywords and functions
• Subroutines and LOAD statements supported in the UE function list
• Other performance improvements

Head on over to the QlikView UltraEdit page to grab the download and instructions of how to update.