Tag Archives: analysis

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 »

Options for geographical analysis in QlikView

With over 80% of data* having a spatial component,Geographical analysis in QlikView geographical analysis can add a powerful new dimension to almost any reporting environment. In the coming time I intend to review the various methods of extending QlikView with geographical analysis capabilities, describing how to apply these methods and what their pro’s and cons are.

Read on to see the options I have identified so far. read more »

Decile analysis

Decile analysis is a popular segmentation tool. Where a pareto analysis splits the top 20% customers (or products, regions, etc.) from the bottom 80%, decile analysis divides them into equally sized groups of 10%.

The image below shows an example of a decile analysis.

Decile analysis

The example shows how a group of 1.000 customers is divided into deciles of 100 customers. Lots of interesting things can be learned from this analysis, amongst other things:

  • Your top 10% customers are generating profit that is significantly above average;
  • Your top 30% customers are responsible for 80% of your profit;
  • You are losing money on your bottom 20% customers (the so-called “bleeders”).

So, how do we create a decile analysis in QlikView? read more »