As Qlik Sense comes of age, I anxiously wait for the day when we will talk about the good ol’ QlikView days when we used to make map charts using a background image and a scatterplot chart. In the meantime, I’ve been finishing up one last, great QlikView adventure with Mastering QlikView Data Visualization and seeing how far ol’ QlikView can still go. Although, we have not seen a major update to its native visualizations in 5 years, I’ve been pleasantly surprised that there are still a few new tricks to be learned and boundaries to be pushed.
Stephen Redmond was the first to make a cookbook on tips and tricks, and he inspired us to look for ways to squeeze the most out of QlikView. More recently, I was inspired by a QlikFix blog post Barry Harmsen wrote on macros to create a my own macro that generates design layout grids and I called it the QlikView Grid System Tool. In turn, Barry was inspired to create a improved GridMaker. (Yes, he even improved upon the name.)
That, and to add insult to injury, he has a uncanny knack for making the most hilarious memes. I’ll leave the meme business to my fellow consultant Qlik Freak Julian Villafuerte, but as far as QlikView is concerned, I thought I’d return the favor and continue the chain of inspiration.
While writing my book, I was recently inspired by an excellent QlikFix blog post written by Frédérique Verhagen about creating bar chart target lines in QlikView. This post was the piece of the puzzle I was missing to finally create a single object, native bullet graph in QlikView. If you convert Frédérique’s bar chart into a combo chart with stacked bars, an error bar and a stock chart expression then you have a native bullet graph that is as robust as any other normal QlikView chart.
By the way, you can learn the trick on how to add a stock chart expression in Stephen Redmond’s cookbook. I’ve left the rest of the details in my book because otherwise Packt will blame me for plagiarizing. No kidding, they’ve already done it once. I bet some of you can figure it out by yourselves, so I’ll also keep the rest of the tricks for the book.
And of course, the bullet graph isn’t perfect. It would be impeccable if only we could change the line width of the stock expression. If you like the idea then vote to add this feature in this Qlik Community idea. Though, in all honesty, what I’m really hoping to do is to inspire one of you to take it that little bit further.