Qlik Sense

The beauty of script autocompletion in Qlik Sense

Such a simple thing – but oh how useful. One of the recent versions (3.0? 3.1? 3.1.1?) of Sense added much improved syntax color coding of the load scripts, as well as autocompletion of function names, field names, variables etc. What might seem like a small change

1 min read
Butler

Butler for Qlik Sense version 2.0

A summer project is over, and Butler  has been released in a version that is a total rewrite of Butler version 1.x. Butler 2.0 includes features such as * Real-time monitoring of what users are active on a Sense Enterprise system * Real-time monitoring of failed reload tasks,

2 min read
Qlik Sense

Qlik Sense data model of the year

Long overdue, but during last few months I have finally started to play around with the various APIs available on the Qlik Sense platform. It has been said before, but it is worth repeating: those APIs are really, really powerful. They are one of the main reasons why I think

1 min read
Qlik Sense

Qlik Sense REST connector log file overload

I recently investigated a strange behaviour of the Qlik Sense REST connector, where it would become slower and slower executing REST queries, the longer the server had been running. RAM or CPU consumption was not unusually high, but something was clearly eating away some kind of resources from the system.

2 min read
Butler

Butler for Qlik Sense - connecting Sense to the world

The goal of the previously described Slack proxy project was to allow posting of messages from Qlik Sense load scripts to Slack (great instant messaging platform!). The project has however developed into something larger and slightly more ambitious, integrating other connections than Slack. The original project name “Slack proxy” has

1 min read
Electronics

ESP8266 Over The Air updating - what are the options?

Over the air convenience A real pain point when developing sensor nodes that are scattered around a building (or a country or the world!) is the updating part. How do you get new firmware onto the devices? The cell phone manufacturers were early to investigate the options, but from my

6 min read
Electronics

Microscope software for OSX

Got myself an Andonstar 2 megapixel USB microscope about a year ago, mainly just for testing it out, and having it readily available when some repair project demanded it. The microscope is actually pretty nice given its ca USD 60 price point, with decent picture quality, a sturdy stand (even

2 min read
QlikView

URL encoding in Qlik Sense and QlikView

With so much cool data available online, tools like QlikView and Sense becomes real Swiss Army knives of data integration. Pull in some data from company internal databases, some data from previously created QVDs, and more and more commonly also from various online sources, both public and private. Depending on

1 min read
QlikView

Posting to Slack - and more - from Qlik Sense load scripts (part 3)

Quick update to the previous post on this topic. There is a new version of slack_proxy available on GitHub. It adds a new endpoint for creating directories on the server where slack_proxy is running. This obviously means that the apps name – “slack_proxy” – is not really that relevant

1 min read
QlikView

Generating test data for QlikView and Qlik Sense

Real data and test data – both are needed One of the great things about both QlikView (QV) and Qlik Sense is their integrations with other systems. Given the native connectivity to any ODBC source, web pages in general, Salesforce, REST APIs, BigQuery etc – combined with the dozens of connectors provided

2 min read
Qlik Sense

Posting to Slack from Qlik Sense load scripts, part 1

When thinking about it, it’s kind of strange that Slack has been so enormously successful. Sure, it’s a great instant messaging tool, but it’s not a new concept – IM tools have been around for decades, and IRC, Google chat and others rose to be very dominant and

4 min read