Tuesday 22 January 2013

QViewer QlikView Debugging Trick

Dmitry, who developed QViewer, posted a great little trick for seeing the contents of a resident table whilst debugging your script in QlikView. You can view his original post here but I thought I'd give you a quick step-by-step of how to make it work.

The first thing you need to do is to download and install QViewer if you haven't already. If you don't know what QViewer is, check out my earlier review post. You an download it from the EasyQlik.com website and best of all there is a free version. The only limitation is that it will load only the first 10,000 rows from the QVD file. This is normally more than enough for most applications and especially when debugging. If you use QViewer a lot then the full version removes this limitation for $45 (USD) (and will also help to encourage Dmitry to continue his great work no doubt).

You will be calling QViewer from within your QlikView script and so you need to change the privileges of your QlikView script to allow it to execute external programs. By default this is prohibited. In the QlikView Script Editor, select the Settings tab at the bottom left and ensure the "Can Execute External Programs" check box is ticked.

Tuesday 8 January 2013

QlikView 11 for Developers

I'm currently awaiting a hard copy of QlikView 11 for Developers but until it arrives I've been skimming through the e-book. A full review will follow when I've digested it properly but so far I'm quite impressed.

For those new to QlikVew it offers a step-by-step guide to building your first QlikView application and includes many of the most common obstacles and their solutions. And for those who've been working with QV for a while I guarantee you'll still pick up some useful tips and tricks along the way such as best practice and dashboard design.