QlikView is a great product, but sometimes one needs a few extra tools in your bag, to help make your development experience that much richer.
Here are some of the tools that I use on a daily basis.
Sometimes you need to edit your script using better search and replace functionality or block copy and paste or a myriad of other texty things. Notepad++ is a very powerful, free text editor, which I can’t do without.
QlikView doesn’t really have any code snippets and the “intellisense” is somewhat limited. To help me with faster inserting of often used code, I use AutoHotkey.
AutoHotkey is a free, open-source macro-creation and automation software utility that allows users to automate repetitive tasks in Microsoft Windows – Wikipedia.
Here are some of the examples of what I use AutoHotkey for.
I copy the name of a Resident Table, type “ij” followed by [SPACE] where I need to do the next table join and AutoHotkey inserts inner join (Customers) for me.
Some others examples:
· rj: right join(Customers)
· dt: drop table Customers
· df: drop field CustomerCodeTemp
· es: exit script
They great thing is, that you can build your AutoHotkey automation library as you go along.
I also use it for any other daily automated text needs, like email addresses or simple email signatures.
This little gem, simply adds a few handy context menu items in Explorer when right clicking on a QVW file.
QViewer provides you with an easy way, to view the data in a QVD, or to see what the data looks like in a resident table during the reload of a document. This blog post by Dmitry Gudkov shows you how look inside a resident table.
5. Not a Software tool, but a very useful tool: QlikView Community Forum
6. Some Quick Mentions of tools that are used from time to time
Comment and let me know what tools you use to assist with your QlikView Development.