• Dual & Exists – Useful Functions

    I find that the Dual and Exists functions are useful functions that I often use in my script.  The Dual function allows me to represent a string field numerically, making it ideal for sorting purposes.  The ...
    Jennell McIntire
    created by Jennell McIntire
  • Buckets

    Often when creating a QlikView application, you want to add some grouping of a number, and then use this as a dimension in a chart or as a field where you make selections.   Usually, the number in itself is not ...
    Henric Cronström
    last modified by Henric Cronström
  • QlikView 11.20 Service Release 8 Beta is now available

    QlikView version 11.20 Service Release 8 Beta is now available to existing customers and partners.   This release includes the following major changes: New Client language: Polish      To u...
    Irena Calovska
    last modified by Irena Calovska
  • 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.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
  • Sensory Data

    Why do people still go shopping rather than using the internet all the time? After all, the internet is normally quicker and your local shopping centre can never hope to have as many brands as you can find using your ...
    John Sands
    last modified by John Sands
  • 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 Great ODBC Confusion

    Before the ODBC interface to databases was developed in the late 80:s and early 90:s, it was difficult to connect to a database and import data. But thanks to Microsoft and some other DB vendors, we got an open interf...
    Henric Cronström
    last modified by Henric Cronström
  • The QlikView Cache

    QlikView has a very efficient, patented caching algorithm that effectively eliminates the calculation time for calculations that have been made before. In other words, if you use the “back” button in the t...
    Henric Cronström
    last modified by Henric Cronström
  • DAR methodology

    Nobody likes to constantly reinvent the wheel. Completely starting from scratch on something you work on all of the time is a waste of time. People reuse parts of old QVWs all the time to save the time & effort of...
    Michael Anthony
    last modified by Michael Anthony
  • 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
  • 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
  • Fiscal Year

    A common situation in Business Intelligence is that an organization uses a financial year (fiscal year) different from the calendar year. Which fiscal year to use, varies between businesses and countries. [Wikipedia] ...
    Henric Cronström
    last modified by Henric Cronström
  • Conditional Aggregations

    Often you need to create conditional aggregations in QlikView, e.g. when you want to create a graph that shows this year’s numbers only, also if there are several years possible.     There are basica...
    Henric Cronström
    last modified by Henric Cronström
  • Rounding Errors

    “If you use equality as a condition when comparing floats, I will flunk you!”   I can still hear the words of the Professor in my first programming class when studying for my engineering degree. The ...
    Henric Cronström
    last modified by Henric Cronström
  • Creating Reference Dates for Intervals

    Last week I wrote about how to create reference dates for exchange rates and warehouse balances: How to populate a sparsely populated field.   There is however also a second case where you want to create referen...
    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
  • Synthetic Keys

    In a well visited post on the community forum, John Witherspoon some time ago asked “Should We Stop Worrying and Love the Synthetic Key?” John’s post begins: “Synthetic keys have a bad reputati...
    Henric Cronström
    last modified by Henric Cronström
  • Data Modelling: Clarity vs. Speed

    Now that the waves from last week’s post about Count(distinct …) have settled, it is time for me to draw some conclusions.   First, I must say that it is astonishing that no one – including my...
    Henric Cronström
    last modified by Henric Cronström
  • A Historical Odyssey: QlikView 4 and the first Server

    QlikView 3 was a giant leap forward. More and more people started developing applications with QlikView and it became much easier to convince prospects and partners to join us on our journey. As a result we faced more...
    Henric Cronström
    last modified by Henric Cronström