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.

The Most Useless QlikView Feature

Yup, even QlikView has one and for me its not a difficult choice....Animated Charts.

In the endless number production QlikView solutions I've seen over the last 8 years, I've never once seen an animated chart used and that speaks volumes, but before anyone gets all agitated, breath for a second and let me try and explain why I dislike them so much. Lets take the below simple bar chart as an example:

Review of QlikView 11 for Developers

There have been a handful of books on QlikView released over the last couple of years, most set on trying to teach new users how to build successful applications, but all have yet to hit the spot for me; there was always something missing. I regularly get asked by customers if there is a book I would recommend, but for me to recommend a book to a client I need to be confident in the advice it gives. Ultimately I'll be the one who ends up picking up the pieces if it's bad advice. Because of this, in the past, I've avoided recommending a book and instead suggested other routes and resources available.

QlikView 11 for Developers was released towards the end of 2012 and is authored by Miguel Garcia and Barry Harmsen, both experienced QlikView consultants. The back of the book makes the following claim:

This book will help you learn QlikView Development from a basic to a practitioner level using a step-by-step approach in a practical environment, and apply proven best practices along the way.

QlikView Notepad++ Language Definition v2.0

OK so after the teaser Tweets over the last couple of days, it's finally here, the new update to the QlikView Notepad++ Language Definition. This is the biggest update yet adding lots of new functionality including:

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

Rather than me babbling on about it anymore, head on over to the QlikView Notepad++ page to grab the download and instructions of how to update.