QlikView: Key to Business Heaven

QlikView: Key to Business Heaven

Think of some of the functionality in QlikView: Triggers, Actions, Dollar expansions, Set analysis, Alternate states, Show conditions, etc. These features are all keys to heaven. Correctly used, they can enable you to build an application that calculates and compares immensely complex things, while still presenting the data in a way that a user can understand and investigate further.

However, the very same functions are also the key to making user-hostile and unmanageable applications, e.g. through:

  • Set analysis that hard-codes a selection – instead of letting the user select interactively.
  • Excessive use of Dollar expansions, Variables and Show conditions, which make the application difficult or impossible to manage.
  • Alternate states that are poorly labelled, so that the user gets confused about which selection really is applied.
  • Triggers with Actions or Macros that perform navigation or selections that really ought to be user-initiated and not automatic.

Working with a QlikView specialist like GT business will help avoid the complexity and maximise the benefits:

The user will learn to interact with data, if you only let him. Most users have very intelligent questions and want to navigate in data, explore and discover things. Let them do this.

But if you instead obscure the QlikView logic by introducing too much additional logic using any of the above mentioned features, the user experience will be a very different one. Instead of an active, smart user, you will produce a passive user that doesn’t understand how to use QlikView effectively and instead uses the application as a static report.

Some pieces of advice:

  • Navigation and selections should be left to the user. Don’t automate this. Let the user make the selections and interact with data.
  • Label fields and charts so that it is clear what they show.
  • Avoid hard-coding filters. For example, if you want one graph showing the numbers for 2014 and second graph for 2013, you should not create two separate graphs with the years hard-coded. You should instead use a Trellis chart with year as first dimension.
  • Avoid using Triggers and Macros.
  • Always ask yourself “How is this going to be managed? Is this a manageable solution?”

GT Business will ensure QlikView functions don’t get in the way of making a user-friendly and manageable application. Instead, use them wisely.

Go to the GT Business QlikView area

Read the full article