Tag: Qlik

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 Catch Up With Qlik Guru Rob Wunderlich

28 Nov 2017
We can now genuinely call Rob Wunderlich a Qlik guru!  We’ve always known he was one but recently Rob was announced as one of the speakers at the Qlik Guru Event in London.  The event will see a host of talent hit the stage to enlighten us all in Qlik techniques and talk about the road map for future Qlik development.  It takes place on the 15th of February 2017 so please take a look at the link above.  My company – Catalyst IT Solutions – will be there as sponsors so please look out for me and come and say hello!
Rob is a legend in the Qlik community and not without good reason:

Continue reading “A Catch Up With Qlik Guru Rob Wunderlich”

Spotify – REST – Qlik

12 Nov 2017

I’ve been itching to do this one ever since I upgraded my Spotify account to premium and started using it on an almost daily basis!  What better data set could you hope for than all your favourite music?

When writing blog posts on Qlik and BI in general it’s often handy to have a data set to hand; to connect to, transform and visualise.  This is why sites with APIs are so useful and the rich variety of sites and companies now offering them makes for a playground of possibilities.  The Spotify API is free and available for anyone with a Spotify account (free, premium or family).  I’ll talk you through how I created my app…

Continue reading “Spotify – REST – Qlik”

Teaching Excellence Framework (TEF) – Analysis of Metrics Via Scatter Charts

8 Jan 2017

Since it was announced in the 2015 Conservative party manifesto the TEF (a measurement of excellence that will allow high performing colleges and universities to increase tuition fees) has caused quite a stir in the world of higher education.  There has been a lot of opposition, non more so than the National Union of  Students (NUS) which has discussed  encouraging a boycott.  Despite this, it is set to go ahead and institutions are preparing by trying to predict their scores.  Beyond these first results they will have to decide how to improve their scores and which metric to target first.  However, which metric should they start with and are all the metrics related so that a positive impact on one will have a positive impact on the others?  Using Scatter Charts in QlikView we take a look using UNISTATS data.

Continue reading “Teaching Excellence Framework (TEF) – Analysis of Metrics Via Scatter Charts”