Let the Chain of Inpirations Continue

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.

BulletGraph

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.

Karl

Data Visualization for Accounting and Unicorns

Recently, I’ve been reviewing the financial analysis part of my new book and I’m reminded how hard it is to create data visualization for an area obsessed with calculating every amount to the exact cent.  When we develop our visual analysis it is so easy to get trapped in this labyrinth of detailed tables and numbers.  We hit our heads against the wall and try to imagine one omniscient visualization that captures every detail and we only succeed in creating something more impenetrable than the table we were trying to replace.  So, let’s step back and think about what we need to do to create a successful visual analysis for an accounting department. Continue reading “Data Visualization for Accounting and Unicorns”

Data Discovery in QlikView – Part 2 – Easier Data Integration and Modeling

Qlik Sense and QlikView are two data discovery tools that make it easy to go from raw data to data visualization.  This in contrast to Tableau that is limited to combining data tables with joins.  If your data source is, for example, an OLTP system that contains a long list of table with complex relationships, you will probably have to invest time to transform and model the data in another tool before you can use Tableau for data discovery.

The couple times I tried to implement Tableau for a company, I had to work all night in SQL Server Express to create a data model that made Tableau easy to use.  It was this experience that made me realize that data discovery does not depend on great data visualization alone.  It also depends on being able to easily extract, transform, and model data.

Continue reading “Data Discovery in QlikView – Part 2 – Easier Data Integration and Modeling”

QlikView Grid System Tool

When we work with data visualization in Qlik Sense, we work within a grid system.  Even though Qlik Sense gets some slack because it does not allow you the freedom to escape the grid, using a grid system a good practice to follow.  We should even apply the same practice when we design QlikView applications. Continue reading “QlikView Grid System Tool”

Data Discovery in QlikView – Part 1 – Agile Implementation

Lately, consultancies with little QlikView experience have asked me to review the feasibility of using QlikView for a variety of projects.  It was obvious after only a quick glance of the projects’ goals that they did not take into consideration the strengths and necessities of QlikView.  I had come to believe people understood the concept of data discovery and that we were past the idea that QlikView was a just a quick reporting tool, but I was mistaken.

Many still believe QlikView only stands for fast implementation time, ease of use and a visual display.   They try to adapt what they understand of BI to what they’ve heard about QlikView. Of course, you can’t blame them because we humans naturally interpret new information based on past experiences.

So, I’ve decided to write a series of blog posts that explain the strengths of QlikView so that we can understand how to use it effectively in our organizations.  I will then conclude the series by detailing the reasons why QlikView projects sometimes go awry.  We’ll add an extra part in each post about how Qlik Sense may or may not change how we use QlikView.

First, let’s explain the concept of data discovery and how we should go about implementing data discovery projects. Continue reading “Data Discovery in QlikView – Part 1 – Agile Implementation”

Learning QlikView Data Visualization – SVG Map Extension Download Update

Since Learning QlikView Data Visualization was published, the url to download the SVG map extension created by Brian Munz and highlighted in chapter 7 has changed to https://github.com/brianwmunz/svgReader-QV11.

If you have any questions about the content of the book, don’t hesitate to ask.

See you around,

Karl

Command line statement from QV Publisher

Steve Dark has recently created askQV.com where you can search several QlikView blogs and the QlikCommunity.  It’s a great resource and I congratulate Steve for his initiative.

It’s not uncommon that I found a solution to a problem only to forget it and then not know where to find it again when I need it in the future.  How to run a command line statement from QV Publisher is one of those infrequent questions that has no clear solution in QlikCommunity, and after performing a search on askQV.com, apparently nobody has blogged about it either.

If you have QlikView Publisher and you go to the System (1) tab of the QlikView Management Console there will be a link to Supporting Tasks (2).  If you then click on External Programs (3) you can then create a command line statement.

ExternalProgramQVPublisher

Continue reading “Command line statement from QV Publisher”