More things I hate about QlikView

Let me start this post with a question: What is wrong with you people? I was building a little app for analyzing which are your favorite topics in this blog when I came across a sad realization. Even though QlikFreak is full of useful tips about visualization and data modeling, it looks like the most popular post is… well… the one where I complain about everything 😛


In a way, writing this kind of posts is like talking about my problems with someone who really understands, and since I cannot afford a decent therapist, why don’t we put the constructive spirit aside and discuss the details we hate about the platform we love? Here we go: More things I hate about QlikView!

The extra space in listboxes when you use the AJAX client: I don’t know about you, but I’ve always had mixed feelings about the AJAX client. On one hand, it has great features such as notes, session collaboration and the fact that you don’t have to install anything special in order to use QlikView in desktops, laptops or even mobile devices. On the other hand, it slightly changes the size and alignment of the objects, modifies the amount of visible rows in straight / pivot tables and sometimes adds scrollbars to the charts. And well… I really hate unaligned objects in my apps!!! However, the thing that annoys me the most is, without a doubt, that blank space that appears at the end of certain listboxes:22_02

For God’s sake! Why. Are. You. There?!?! Aaaaarrrrghhhhh!!!


Bulk Actions: At some point in our lives, we’ve all wished that QlikView had some sort of bulk actions (you know, a magical “Apply to all” button). For example, let’s say you just finished creating a 10-column straight table and you want to center all the labels.  You go to the Presentation tab and try to select all the expressions but you can’t, so you end up either clicking each column and centering its title or changing the object type to a Pivot Table and doing it all at once (I’m not really sure why this only works for Pivot Tables). Continue reading

QlikView Consultant Starter Pack

Unfortunately, a couple of days ago, one of my colleagues invited me to one of those “Why am I even here?” meetings with a new customer. I’m sure you are all familiar with them: long reunions with no objective whatsoever where all the participants strive to look busy and productive, but in reality, they’re not accomplishing anything at all.

In the middle of this rampage (and questioning my very existence out of the boredom), I remembered some “Started Pack” memes I saw earlier that day:


But then, I started thinking, I’ve never seen a QlikView Consultant Starter Pack. Of course there are several training kits and video collections for beginners, but let’s say you meet someone who has just finished his basic QlikView training. How would you help him equip himself with all the tools and resources that he’ll need for his journey as a new consultant? Well, after some thought I came up with this list (and yes, I managed to do something relevant during that meeting too):

Decent computer

OK, don’t give me that look… Yes, I can see you rolling your eyes already! Wait a minute, this is just a little reminder for the newbies.


Don’t forget that QlikView models are loaded into RAM. So, if you’re going to work with several millions of records, you’d better get a good laptop (and yes, you’re going to need Windows). Though you can now develop in any browser or mobile device using Sense, let’s be honest: it is much more comfortable to work in your own machine, with all your apps, images and other resources available.

Continue reading