Category Archives: Expressions

QlikView Easter Egg

At least, I hope it´s a sense of humor, and not a new feature for QlikView.Next :)

A fun little easter egg that shows the boys and girls at QlikView R&D have a sense of humor. Entering the expression:

=’qmem://<bundled>/Images/clippy.png’

into a text object and choosing the Image representation shows our old *ahem* friend Clippy. Or should I say Qlikky?

Besides Clippy, there are actually a lot more images embedded in QlikView than just those listed under <bundled>/BuiltIn. Almost all of the images in the QlikView user interface (and lots more) can be referenced via the hidden folder <bundled>/Images. In the application that you can download below, you will find an overview of all hidden embedded images.

Download the QlikView hidden embedded images application

Update 2013/03/27: an awesome easter egg that I seem to have missed (because it’s a JPG instead of a PNG):

=’qmem://<bundled>/DevTeam.jpg’

This shows a picture of the QlikView development team. Credits for this discovery go to blog.heldendaten.net (an interesting blog, by the way).

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 »

QlikView blog round-up: If-statements, inline tables & EDX

DecisionsTime to dust off a posting category that hasn’t been getting as much love as it should have; the QlikView blog round-up. Today I have for you three blog posts that I read recently and found very interesting:

read more »

Testing the performance implications of variables and label referencing versus direct expressions

Testing the performance implications of variables and label referencing versus direct expressionsAfter my previous post about variables, I got an interesting question from DV. He asked me about the reuse of chart expressions by referencing the label of another expression (“label referencing”), and what the performance implications of using variables and label referencing versus direct expressions are.

I use variables and label referencing extensively in my applications, but I never really tested what this means for performance. I have always assumed that using variables instead of direct expressions would have a slight impact on performance. I also suspected that using label referencing would result in significantly better performance (I will explain this later).

But was this really true? Triggered by DV’s question, I set up a small experiment to test my assumptions.

read more »

Not all variables are created equal

Beware of the equals signIt has been a while since my last post. To get back in the habit of regular updates, I am starting today with a short tip on a caveat of the use of the equals sign (=).

Starting an expression with or without an equals sign may almost seem like an arbitrary decision. Most developers quickly figure out that this is not true for text objects. However, there is another, less obvious area where the use of the equals sign can greatly impact how (and more importantly, when) your expression is calculated.

read more »