• Calculated Dimensions

    To make a chart in QlikView – in any Business Intelligence tool, for that matter – you need to have one or several dimensions; entities with discrete values that you use as grouping symbols. But where shou...
    Henric Cronström
    last modified by Henric Cronström
  • Dimensions and Measures

    To make a chart in QlikView – or in any Business Intelligence tool, for that matter – you need to know what Dimensions and Measures are. But not all people have a clear picture of the difference between th...
    Henric Cronström
    last modified by Henric Cronström
  • AJAX and URL parameters

    Sometimes you want QlikView to open with a specific set of selections, apply a bookmark or perhaps even deep link to a specific sheet. A typical use case could be to embed an entire app or a single object inside a CR...
    Alexander Karlsson
    last modified by Alexander Karlsson
  • Roll up! Roll up!

    Have you noticed how fads and trends appear so often in the industry we work in? It almost harks back to the days of Victorian London where traveling salesman would stand on a soap box and talk about the latest and gr...
    John Sands
    last modified by John Sands
  • We Don’t Care Where You Keep Your Data

    With all the talk about cloud analytics last week, I thought I'd share my thoughts on the subject.    I don’t care where you keep your data.  I’m not saying you shouldn’t care, you sh...
    Josh Good
    last modified by Josh Good
  • QlikView 11.20 Service Release 9 Beta is now available

    QlikView version 11.20 Service Release 9 Beta is now available to existing customers and partners.   This release includes around 80 bug fixes and no design changes, only added support for iOS8. You can read mor...
    Irena Calovska
    last modified by Irena Calovska
  • A Primer on Section Access

    Section Access is a QlikView feature that is used to control the security of an application. It is basically a part of the load script where you can define an authorization table, i.e. a table where you define who get...
    Henric Cronström
    last modified by Henric Cronström
  • The Master Calendar

    One of the most common problems to solve in data modeling is that of time. How to assign month name and other time attributes to a date. The solution is called a master calendar.   A master calendar table is a d...
    Henric Cronström
    last modified by Henric Cronström
  • Navigating through Qlik Sense Desktop

    I am sure everyone has already downloaded Qlik Sense Desktop, so I wanted to help you get comfortable with navigating within an application. Understanding how to get to where you want to go is half of the battle. &nbs...
    Charles Bannon
    last modified by Charles Bannon
  • Protecting Qlik Sense against rogue servers and eavesdropping

    When we designed Qlik Sense one important aspects was to start using standard security components where possible to solve different aspects of security. Protecting communication is a good example of this, as we used s...
    Fredrik Lautrup
    last modified by Fredrik Lautrup
  • Contextualize your KPIs

    Raw data is useful but data with additional contextual information is better because it helps us do what we already do naturally: compare, contrast, and weigh our options as part of the bigger picture. Contextual data...
    Michael Anthony
    last modified by Michael Anthony
  • Authorization using a Hierarchy

    Hierarchies are very common in all database and business intelligence solutions. Often they are used for authorization purposes, i.e. the permissions to see data follows a hierarchy.   One example is an organiz...
    Henric Cronström
    last modified by Henric Cronström
  • Ancient Gods and Modern Days

    The use of the seven-day week is ancient. Signs are found in the old Greek, Indian, Persian, Babylonian, Jewish, Akkadian and Sumerian cultures. Most likely it was invented by the Sumerians around 4500 years ago. &nbs...
    Henric Cronström
    last modified by Henric Cronström
  • Unbalanced, n-level hierarchies

    Hierarchies are very common in all database and business intelligence solutions. Usually they are balanced and with a fix number of levels, and then they do not pose any problems. Just load the data, add a drill-down ...
    Henric Cronström
    last modified by Henric Cronström
  • QlikView.Next 0.9 Beta is now available!

    We are delighted to announce the availability of the QlikView.Next 0.9 Beta!   This Beta represents the first step in the exciting journey to the next generation of Business Discovery and we encourage you to do...
    John Callan
    last modified by John Callan
  • Handling Multiple Languages

    Today’s corporate environment is global. QlikView application developers are required to support many regions and many languages. So how does a QlikView application developer handle multiple languages?  Wel...
    Charles Bannon
    last modified by Charles Bannon
  • How to Rename Fields

    Renaming fields in the script is something that all QlikView developers do, not only for creating links between tables, but also for making the sometimes cryptic database field names understandable for the users. So h...
    Henric Cronström
    last modified by Henric Cronström
  • Preceding Load

    A QlikView feature that is poorly known and brilliant in its simplicity is the Preceding Load.   If you don’t know what it is, then I strongly suggest that you read this blog post and find out. Because it ...
    Henric Cronström
    last modified by Henric Cronström
  • QlikView and Qlik Sense

    As most of you have noticed – I hope – we have now released a new product.   Qlik Sense.     Qlik Sense is not just a new release of QlikView. Instead it is something different. But there...
    Henric Cronström
    last modified by Henric Cronström
  • QlikView.Next 0.95 Beta is now available

    We are pleased to announce the availability of QlikView.Next 0.95 Beta!   This Beta includes some major new capabilities and represents one step further in the journey to the next generation of Business Discover...
    Irena Calovska
    last modified by Irena Calovska