Harvesting Wisdom

Category: QlikView

  • Mastering QlikView Data Visualization

    The book, Mastering QlikView Data Visualization, happens to be my lost adventures as a QlikView consultant. I haven’t promoted it much because after two years of writing, I was too anxious to run off to learn other skills. A year and a half after its publication, QlikView is still popular and customers continue to look…

  • Qlik Sense Developer Step #2b: My First Extension

    At this point, I have the motivation to become a Qlik Sense developer, a basic understanding of HTML, CSS and JavaScript and rudimentary knowledge on how to create a simple Qlik Sense extension. The only piece I’m missing is an idea about what great purpose my first Qlik Sense extension would serve. I thought about creating a…

  • Can a QlikView developer be a Qlik Sense developer?

    QlikView developers (as per the book QlikView 11 for Developers) were those of us who wrote load scripts, designed data models, formulated expressions, and manipulated QlikView objects. Qlik Help has now left that group of people nameless and deemed developers to be those who work with either QlikView or Qlik Sense APIs using some third-party code. Even so, I still consider…

  • Exponential Distributions in Qlik

    Last week, I gave the business case for using an exponential distribution to predict a customer’s purchase frequency and detect at-risk and lost customers, Sales Analytics in Qlik: From the Basics to Statistical Modeling. In this week’s post, we go over the details of calculating and visualizing the exponential distribution in QlikView using the following chart.…

  • Sales Analytics in Qlik: From the Basics to Statistical Modeling

    The basics The most common Qlik application involves sales data analysis. Period. Well, I don’t have enough information to back that up, and since data analysis is my life, I can’t make unsupported claims without some major nervous facial twitching (or so my wife says). However, I would bet based on personal experience that it is…

  • Let the Chain of Inpirations Continue

    As Qlik Sense comes of age, I anxiously wait for the day when we will talk about the good ol’ QlikView days when we used to make map charts using a background image and a scatterplot chart.  In the meantime, I’ve been finishing up one last, great QlikView adventure with Mastering QlikView Data Visualization and seeing how…

  • Data Visualization for Accounting and Unicorns

    Recently, I’ve been reviewing the financial analysis part of my new book and I’m reminded how hard it is to create data visualization for an area obsessed with calculating every amount to the exact cent.  When we develop our visual analysis it is so easy to get trapped in this labyrinth of detailed tables and numbers.  We…

  • Data Discovery in QlikView – Part 2 – Easier Data Integration and Modeling

    Qlik Sense and QlikView are two data discovery tools that make it easy to go from raw data to data visualization.  This in contrast to Tableau that is limited to combining data tables with joins.  If your data source is, for example, an OLTP system that contains a long list of table with complex relationships, you…

  • QlikView Grid System Tool

    When we work with data visualization in Qlik Sense, we work within a grid system.  Even though Qlik Sense gets some slack because it does not allow you the freedom to escape the grid, using a grid system a good practice to follow.  We should even apply the same practice when we design QlikView applications.

  • Data Discovery in QlikView – Part 1 – Agile Implementation

    Lately, consultancies with little QlikView experience have asked me to review the feasibility of using QlikView for a variety of projects.  It was obvious after only a quick glance of the projects’ goals that they did not take into consideration the strengths and necessities of QlikView.  I had come to believe people understood the concept of data…