Monthly Archives: August 2012

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 »

Show all sheets and sheet objects

Show all sheets and sheet objectsAs promised in the previous post, today I have a tip for you that is of real, practical use.

Management summary: Ctrl + Shift + S overrules all conditional show expressions making every hidden sheet and sheet object visible.

Full story: Condtional show expressions are used in QlikView to show or hide a sheet or sheet object depending on if a predefined condition has been met. While this is extremely useful functionality to make your applications more user-friendly, it can be a real hassle during development.

If you want to edit a sheet or object when its show condition has not been met, you either have to make a selection that matches the condition, or you have to dig deep into the menu (Settings | Document Properties | Security | Show All Sheets and Objects) to disable, and when you’re done re-enable, conditional display. We all have better things to do with our time, for example reading blog posts that are way longer than they need to be.

Fortunately, in QlikView Desktop (‘classic’ view, not WebView) there is a shortcut: Ctrl + Shift + S overrules all conditional show expressions making every hidden sheet and sheet object visible. Now you know.