Category Archives: HowTo

Remove scrolling tabs from QlikView Chart Properties

Remove scrolling tabs from QlikView Chart Properties

A short post today, but one that will fix a very common developer annoyance in QlikView 11 and 11.2; the scroll tabs in the chart properties dialog window. When you want to change properties on tabs that are on opposing sides of the tab row (for example, Dimensions and then Layout) you first have to click the scroll arrows before you can select the tab. Extremely annoying, if you ask me.

read more »

Introduction to alternate states

QlikView Alternate StatesA little while ago, I was asked to change an existing QlikView Application. While scanning the application, I found that it used Alternate States. I had already heard about Alternate States, and that they could store different user selections, but didn’t have any hands-on experience yet. I decided to dig a bit deeper into the subject before continuing. I wrote down what I learned in this post

read more »

Online training: QlikView Set Analysis

QlikView Set Analysis Training

Just a quick heads-up about a new online training that Miguel García and I are offering: Set Analysis. We delivered our first training on May 2nd and received excellent ratings and feedback. We are now scheduling new sessions, the first one being held May 23rd 2014. This is a live, instructor-led, 4 hour online training. We have multiple sessions (both in English and Spanish), so you should be able to find one that fits your time zone. More information can be found on the website, or after the break.

Register Now for the Online Set Analysis Training

read more »

Linked bar charts

Two questions from business users that will probably sound familiar to most QlikView Developers:

“We currently use this report. Can you re-make this in QlikView?”

and

“Our graphics designer came up with this dashboard. Can you do that in QlikView?”

Quite often you’ll find the answer to be yes. Although admittedly, you often may also want to suggest another approach, especially when asked the first question.

Recently I was asked if the following chart could be built in QlikView:

Linked Bar Chart - The Challenge

As you can see, this chart compares relative-to-total amounts for two periods. There is a vague area that connects both bars and kind-of-but-not-so-much shows the change between the periods. I had to think a bit harder before responding to that question…

read more »

Generating random test data in QlikView with Mockaroo

Functions to create random data in QlikView


I often need random data. For example to use in an example file on this blog, to deliver a customer demo or just to test out something new. As I am probably not the only one with this need, here’s a short and sweet post on how to generate random data for use in QlikView.

read more »

Or-mode selections between list boxes

and & or selections in QlikViewAt the Masters Summit for QlikView in London we ended the second day with an informal ‘stump the geek’ session. In this session participants could submit technically challenging questions to a panel. Besides the four presenters, this panel also consisted of Steve Dark, Stephen Redmond and Henric Cronström. You can imagine that I found myself surrounded by an awesome amount of QlikView knowledge.

While challenging, most of the questions could either be answered on the spot or a conceptual solution could be described. There was however one question that didn’t really yield an, in my opinion, satisfactory answer. The consensus almost seemed to drift towards ‘it cannot be done’ or ‘that is not how QlikView works’. The question was:

Can we make “or” selections between list boxes, instead of the standard “and” selections?

read more »

QlikView 11 for Developers – Training Materials

QlikView 11 for Developers - Classroom training materialSince its publication in November 2012, our book QlikView 11 for Developers has been used by many people to take their first steps in QlikView, improve their skills and prepare for their Developer certification. But to our surprise, it haven’t only been individual developers who used the book. Mike and I learned that many organizations either developed their own training around our book, or were contacting us to inquire if such materials were available. Obviously, this is something that we welcome and will gladly facilitate.

After a few months of development and rigorous testing, we are proud to announce that we now have a complete set of ready-made materials available. These materials enable you to quickly deliver a structured, professional QlikView training based on QlikView 11 for Developers.

read more »

Moving QlikView Server log files

Beam me up!This is a sneak-peek at one of the topics covered in the Server Admin best practices session at the Masters Summit for QlikView:

When doing QlikView Server deployments for clients, I often come across policies stating that the C: drive, the default installation drive for QlikView, may only be used for the operating system. Program files, data and logs all need to be placed on other, designated drives. The rationale for this policy is that data, and especially log files that aren’t purged, can fill up the boot drive and disrupt the system.

Specifying alternative locations for program files is simply a matter of specifying another installation path during setup, and the location of data and QVWs can be easily configured in the QMC. Moving log files is a little more complex however, so today I have for you a tutorial explaining two options for moving your log files and other configuration artifacts. read more »

Masters Summit for QlikView: European Edition

Masters Summit for QlikViewAfter the success of the Las Vegas edition last April, I’m excited to be once again presenting alongside Rob Wunderlich, Bill Lay and Oleg Troyansky at the European edition of the Masters Summit for QlikView.

Masters Summit for QlikView; London and BarcelonaComing to London from October 9  to 11 and to Barcelona from 14 to 16 October, the Masters Summit brings you 3 days of hands on sessions where we will discuss advanced techniques in building complex solutions with QlikView. The goal of this event is to take your QlikView skills to the next level and help you become a QlikView  master.

For the early birds, there is an attractive discount of US$ 300 (around 225 Euro’s) until August 16th, which, for example, should be enough to cover air fare from most locations within Europe. Make sure you do not miss out on this great offer and:

Register for the Masters Summit for QlikView

I hope to see you all there!

DISTINCT can be deceiving

DISTINCT can be deceiving

Never think you know it all! Today I have for you a little ‘gotcha!’ about the LOAD DISTINCT statement that I picked up from Oleg Troyansky at the Masters Summit for QlikView.

Common knowledge about LOAD DISTINCT is that it will remove duplicate records from the input table, similar to how the DISTINCT clause works in SQL. For example:

Regular LOAD DISTINCT

However, when used in combination with the JOIN or CONCATENATE statement, the results can be surprising, and even counterintuitive.

read more »