Category: Best Practice

The Problem With Section Access in Sense (With Workarounds)

11 Mar 2018

Section Access Header Image  We’ve all experienced pain when using section access.  Qlik Sense addressed one of the headaches by allowing you to right-click on an app and “open without data” in order to access your script if you lock yourself out.  However, Sense has introduced a problem that never existed in QlikView; that omitted fields cause visualisations to fail.   Continue reading “The Problem With Section Access in Sense (With Workarounds)”

A Recipe For a Dashboard

28 Aug 2017

We love our recipes in Qlik land, none more so than master chef Rob Wunderlich (qlikviewcookbook), and they’re great but they do make me hungry.  We use recipes as a way to describe processes but this time I thought it might be fun to use one as a way to describe an overall approach to building a dashboard in Qlik.  These best practice tips are the kind of things I wish I’d known about when I first started out with Qlik and that even now are all too easily taken for granted.  The link to open/download is below.

Bon Appétit!

Link:  A Recipe for a Dashboard

The Fox News Technique – How NOT to Report the Truth in Qlik

4 Dec 2016

You can do all sorts with charts, and people do.  They should quickly convey accurate and insightful trends but they can be abused – twisted or exaggerated to tell whatever story the developer wants.  They can also be mishandled by a well-meaning developer who has accidentally ticked the wrong option.

So where does Fox News fit into this?   Continue reading “The Fox News Technique – How NOT to Report the Truth in Qlik”

Woof. Getting the Point Across.

28 Nov 2016

Often it’s easier to get the point across when it’s quicker to get to the point.  That’s why we use charts.  As a visualisation they should draw us to the key trends and figures without having to trawl through rows and columns of data.  However, aren’t they a bit boring?  Can’t we get the point across in a more immediate and engaging way?  So let’s strip away those axes and titles then see what we can do with a data set on pet ownership in the UK which I’ve taken from http://www.pfma.org.uk/regional-pet-population-2016 and stripped down to just the northern regions.  Here’s the raw data:

Continue reading “Woof. Getting the Point Across.”