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)”
A couple of weeks ago I was asked to create a quiz application with Qlik Sense. My company, Catalyst IT, had a sponsor’s stand at Thursday’s excellent Qlik Guru Day in London and we wanted to have something fun at our stand involving Qlik Sense (we also had a hololense displaying augmented reality, 3D interactive charts). Continue reading “Qlik Sense Quiz”
Taking your Qlik exams and becoming certified is a great way of proving your knowledge, not just of Qlik but of understanding customer requirements, the Windows environment, business intelligence best practice and lot, lot more. The content is broad and therefore revision is required but where are the best learning resources, how much do they cost (though some are free) and which exams are they aimed at? Continue reading “Qlik Exam Preparation”
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…
I wanted to build an app for demo purposes that shows how you can conduct What If analysis in Qlik Sense, I just needed a theme…
It isn’t really that long ago since Jimmy Hill introduced the the 3 points for a win system to English football in 1981 in an effort to encourage attacking play and tackle the issue dwindling crowds. Big hitters like Germany, Spain, Brazil and Argentina didn’t introduce the system until as recently as 1995. Nowadays it’s hard to think that teams only got 2 points following victory. Some pundits have argued that it actually stifled attacking play; causing teams that went 1-0 ahead to “park the bus” and protect their precious points.
Having written a list of potential new blog articles my thoughts should have been on “which one to write up first,” but after after listening to some Billy Bragg in the evening I decided to indulge my inner socialist and write up something that wasn’t on the list. Using Qlik Sense and some VizLib charts I examined the Tories’ track record using what you might call “the Ghandi measurement.” Continue reading “The Ghandi Measurement”
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.
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.
Link: A Recipe for a Dashboard