Tag Archives: application

Visual FX in QlikView (3)

With so many people commenting positively on my previous two pointless-but-pretty visual effects in QlikView, I’ve decided to make it an irregularly recurring Friday-afternoon series. At least, until I run out of ideas or opportunities to build these applications.

This time I’ve created an animated fire effect using a scatter plot. Like the previous two effects it has absolutely no practical application, unless you’re pitching QlikView to Industrial Light & Magic 😉 The video below demonstrates the effect.


If you want to try the application for yourself, you can download it by clicking the link below. Beware that the application is quite memory-hungry, you’ll need at least 4GB to run the app.

Download the QlikView Animated Fire app

Earlier posts in this series:

Search by copy and pasting from an external list

In operationally focused QlikView projects, Search for multiple values by copy-and-pasting from an external list/ I’m often asked is if it’s possible to search for a list of values in a list box by copy-and-pasting from an external source. For example, searching for customer ID’s by pasting values from an Excel spreadsheet.

Unfortunately, out of the box, QlikView does not support this method of searching for multiple values. However, by combining an input box, a variable and a trigger, we can approximate this functionality quite nicely.

read more »

Check if your LinkedIn password was leaked

Today it became known that LinkedIn (supposedly) lost around 6.5 million passwords (or more accurately, password hashes). Curious to see if mine was in there, I decided to download the file containing the supposed password hashes and check (it wasn’t). As checking your password against a list of SHA-1 hashes can be a little complicated, I created a little QlikView application to simplify the process. Yes, that’s what I do for fun.

Check if your LinkedIn password was leaked.

The application takes a password for input and checks it against the password hashes. A message is shown to indicate if the password was found. If your password was not found, it is probably a good idea to change it anyway.

You can download the QlikView application using the link below. The application does not yet contain the actual password hashes, you’ll have to download those from one of the many mirrors. At 118 MB it’s a big download, but then again it’s a lot of data. Extract the file named combo_not.txt in the same directory as the QlikView app and reload.

Download the LinkedIn leaked password checker app

Of course, this application is provided completely as-is, without any warranty whatsoever.

How to get started with QlikView

Getting started with QlikViewLately I have been getting a lot of inquiries by people asking me how to get started with the Personal Edition of QlikView. It seems to be a very popular new year’s resolution this year, and one that is definitely a lot easier to keep than losing weight, getting fit or quitting smoking (hang in there everyone!).

Rather than answering everyone individually, I am trying to take a more lazy efficient approach by writing this post in which I lay out what I believe is a good path to get started with QlikView, without having to immediately draw your wallet to buy training.

Update 2012/11/23: Mike García and I have just released our book QlikView 11 for Developers, available from Amazon, Barnes & Noble, Packt and many other places. While it is not free, it does offer a cost-friendly, guided way to start learning QlikView.

read more »

Portable QlikView: run QlikView Desktop from your USB drive

Run QlikView Portable from USB driveAs a consultant, one thing that I have really come to rely upon is my collection of Portable Applications. Until now, the only thing that was missing from my toolbox was a portable version of QlikView Desktop. Not anymore though. This post will show you exactly how you can create a portable version of QlikView Desktop that you can take with you on your USB drive and run wherever you want. read more »