With so many people commenting positively on my previoustwo 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.
In operationally focused QlikView projects, 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.
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.
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 oneofthemanymirrors. 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.
Lately 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.
As 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 »
Download the QlikView Animated Fire app
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.
Lately 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!).
As a consultant, one thing that I have really come to rely upon is my collection of 
