QlikTastic

Musings on Analytics and Big Data

Creating a Self Service Report for QlikView

Every self respecting Qlik Dashboard should end in an option to create a self service report.  I’ve taken the pain out of writing your own one by providing an easy to use template with downloadable code and a printable cheat sheet.  You’re welcome. Flexi Report is just a chart object (usually Pivot or Straight table) […]

December 29, 2017

5 Essential Tools for Every Qlik Developer

The following 5 applications will improve your productivity, security and general awesomeness in your day to day Qlik and Visual Analytics work. As a Visual Analytics and Qlik consultant, I am constantly finding myself giving live demonstrations in the form of screen casts and presentations.  Whereas I like to think that my audience are interested […]

March 9, 2017

QlikView and On Demand App Generation (ODAG)

QlikView is well suited to in memory analysis of large data sets but it struggles with true big data scenarios.  On demand app generation (ODAG) addresses the big data problem but requires some special techniques involving the exchange of more information than can be sustainably handled in a URL. This article discusses a method of […]

February 3, 2017

Building an Average Row or Column in a QlikView Pivot Table

Simply using the RowNo() function nested with an IF() statement will give you full control of the Total row or column in a Pivot Table to use as you wish. Pivot tables. Easily the most versatile of all the out of the box charts QlikView has to offer you. In fact, they are so versatile […]

March 3, 2016

QlikView’s Previous() and Peek() are not the same

Peek() and Previous() read data from different locations creating a pitfall for the developer but also an opportunity. Understanding the difference ensures optimal performance and fewer coding exceptions To state Previous() and Peek() are different may sound like a fairly obvious statement and I wouldn’t criticise you (much) if your prime reason for coming here […]

February 8, 2016

Non Comparative Dates Image

Extreme Synthetic Dimensions in QlikView

Mixing ValueLoop, ValueList and Parametarised Variables to create the mother of all synthetic dimensions I’ve seen quite a few posts recently about the use of QlikView’s Dollar Sign Expansion using parameters and the use of the ValueLoop() and ValueList() functions.  I thought, for my first post I would demonstrate a real world example combining all […]

January 23, 2016