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:
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).
It’s also impossible to disable all the columns at once. I stumble with this problem very often when I want to use the Equal Column Width action just for some expressions:
Or when you want to change the width / height of several objects:
It’s really not a big deal, but sometimes I’m too lazy to performs all those clicks 😕
Stagger Labels: I’ve always asked myself why this is the default setting for new charts. Really, it’s impossible to interpret that. I could have understood diagonal or even vertical labels, but this?
“QlikView Experts”: I don’t know if this phenomenon happens in other countries as well, but here in Mexico there’s a plague of self-proclaimed “QlikView Experts” who go around creating apps that stand out because of their insane amount of synthetic keys, pie charts with dozens of slices, unreadable fonts and poorly designed KPIs. These guys brag about their experience in the airline, retailer and consumer products industries. However, they never mention that it comes from Q-Tee Brands and HighCloud Airlines! (Yep, those are the fictional companies of QlikView your Business and QlikView 11 for Developers. Great books, by the way.)
If Rob Wunderlich, Steve Dark or Stephen Redmond call themselves QV experts, they’ve more than earned it. If Barry Harmsen wants to be Chief Qlik Officer, no one can complain. If Karl Pover wants to be referred to as Honey Boo Boo, you’d better call him “Your Majesty Miss Honey Boo Boo” (Let’s see if Karl still reads my blog). But please, if you just finished the Designer I course and created your first real world app, don’t use “Ultimate QlikView Guru” as your LinkedIn title.
Moving containers: I’ve always had problems when it comes to moving container objects in QlikView. For a strange reason, sometimes when you try to use Ctrl + Arrows it looks like the table inside it wants to get out, but the object itself doesn’t move.
Awesome demos: Have you ever tried to borrow certain elements of a demo app (like a label, for instance) just to find out that it’s actually an image?
Tab Scroll: I really cannot believe that Qlik hasn’t changed this yet! A little part of me dies every time I install QlikView with a new server / laptop and this guy appears for the millionth time:
Once again, thanks Barry for sharing the solution. (I wish we knew who wrote that post originally, he’s a real hero).
Some features in QlikView 12: QlikView 12 has brought some good improvements, but also some not-so-pleasant things:
Online Help: Some of my customers have strict security rules and they don’t grant full Internet access to the external consultants. Sadly, since QlikView 12 doesn’t have any local help, you must now gather other type of documentation. Good luck remembering the parameters of ALL the functions!
Strange Symbols: If you speak Spanish, French or German, maybe you will relate to this one. QlikView has no problem in defining fields with non-English symbols. However, in this new version, the Edit Expression dialog doesn’t get along with them very well and marks them as errors:
C’mon, first you recommend me to use this field, but then you don’t recognize it?
Ctrl + E / Little Hammer: Have you noticed those little hammers in the script? They used to be very useful! Usually, they would trigger the File Wizard where you could edit the column names, create a cross-table, etc.
Well… Now, sometimes they work, but some others they don’t 😦
Hidden text objects: I’m sure this one has happened to you at least once. When you have multiple charts / tables in the screen and you create a new Text Object, sometimes it doesn’t appear at first sight. You have to activate the Design Grid in order to discover where the sneaky guy is hiding!
Can you relate to any of these? What else would you add to the list? Please, share your thoughts in the section below. Till next time!