Monday 24 October 2016

Generational Differences in Working Styles

Hi, I'm working on something new at the moment and if you have two minutes it would be great if you could lend a hand.

Sunday 2 October 2016

Making Awesome Qlik Sense Date Dropdowns

One of my favourite things in Qlik Sense is the new calendar function, however talking with other developers I've found that some people don't know about them yet.

Here's how to get that lovely drop down expanding from all your date fields that you see in all the Qlik demoes...

Monday 16 May 2016

How to write SQL stored procedures for Qlik

Recently I wanted to add one of my stored procedures for a different report into a dashboard to show the power of Sense (integrating pre system data with the new ERP system, Awesome!)

However, whatever I did, my stored procedure wouldn't run in Qlik Sense... so I did what I usually do in this situation and ran back to Qlikview to see if I could identify the problem and I couldn't! I should point out that this code was live and running fine in both SQL and crystal reports (a necessary evil for other projects!)

TL;DR version: the SP layout is at the end of the article!