What is ODAG? How do you implement it? Can I borrow your script? Of course you can!
How many people do you need to gather together before it becomes more likey than not that two people share a birthday? 150? 200? The answer is surprising and counter-intuitive… just 23! Let’s use Qlik to break it down.
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)”
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…
2017 has been a disastrous year, politically and environmentally, but something I will always cherish about the year will be my trip to Qlik in Lund, where the company was founded back in 1993.
It’s a huge honour to be invited onto Qlik’s Luminary programme for 2017. I can’t wait to get going. Congratulations to everyone who made the cut and I hope to see you at a Qlik event soon.
For Qlik’s post and for a full list of 2017’s luminaries Continue reading “Qlik Luminary Award”
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.
I’ve finished work for Christmas so I’ll be taking a short break from the blog to eat, drink and be merry with my friends and family. Driving back home from work earlier today Chris Rea’s dulcet tone came floating out of the car speakers with his aptly named song ‘Driving Home for Christmas.’ Continue reading “Driving Home for Christmas”