Hello everyone, Happy New Year to you all. For the past few days, I’ve been scratching around various documentation and videos surrounding Qlik Sense SaaS (Cloud) to retrieve data from ..read more

Accessing the Qlik API using the Python requests library quite straight forward although soon some code can start to become complex. Such as using OAuth to connect and if you’re using multiple tenants using the regional authentication rather than per tenant is a must! Qlik has kindly packaged their API’s into a Python Library Qlik SDK (Software Development Kit) . This, should, help you work faster developing your scripts to manage your Qlik Cloud estate The Qlik SDK code documentation is here https://pypi.org/project/qlik-sdk/ python3 -m pip install --upgrade qlik-sdk Once you have installed ..read more

In order to manage multiple tenants or complex Qlik Sense SaaS platforms soon you will find you want to automate a lot of your administrative tasks. Taking the Qlik CLI once step further from single commands we can use a programing language (Python) to create multi step processes. sudo apt install python3-pip python -m pip install requests For this example I’m going to use the ‘requests’ python module to request data from the Qlik api. The syntax is different from the CLI interface. Here we send though three main pieces of information: qlik.api.url your tenant URL plus you location ending ..read more

Qlik-CLI allows you to manage your Qlik environment using the command line. This in turn makes it easier to automate certain tasks such as: Import, export, publish, and republish apps. Create, rename, remove, and update spaces and assign user access. Build, analyze, and edit apps. Administer tenants (and client-managed sites) All this information on its use can be found here https://qlik.dev/toolkits/qlik-cli/. This page walks through my experience installing onto the Ubuntu lynux system https://ubuntu.com/. Configuring Ubuntu on Windows First install WSL onto windows https://learn.microsoft ..read more

In today’s data-driven business landscape, the ability to extract valuable insights from vast amounts of information is crucial for staying ahead of the competition. That’s where business intelligence (BI) tools come into play, offering organizations the means to gather, analyze, and visualize data in a way that drives informed decision-making. With a multitude of BI tools available in the market, such as Qlik and Power BI, choosing the right one for your company’s unique needs can be a daunting task. In this comprehensive guide, we will walk you through the essential steps to evaluate and sel ..read more

Proud to announce I’m publishing my first Qlik Sense extension. Is it a grid chart or a waffle chart? https://github.com/RichardPearce60/sense-svg-grid-chart This isn’t my first extension, over the past few years I’ve been enhancing my web language experience learning JavaScript and several library’s (D3, require, angular, lodash, etc). I took my inspiration for this chart from one I saw on the BBC news website. The concept is simple enough and the idea of such a chart is to give more cognisant representation of the data. In the example above we can see how many cars in 100 are in an accident ..read more

D3 Scales make creating chart axis simple by passing the extent (min / max) values to the scale.domain. Unfortuanly our values mean axis extremes aren’t always “nice”, they are absolute and not rounding. Not always a problem but can lead to an ugly ugly chart. For example lets say our min / max values are 14 and 72. Our D3 axis would compute as follows. If we were to add the .nice() parameter when we construct the scale we get something a little better. Its still the same date, just rounded of for the purpose of the scales. This is great but you’re still at the mercy of D3.scale.nice functio ..read more

Qlik Sense mashups can be quite simple at first. The dev hub lets you create the files you need, connect to and app and drop in charts. Here’s a simple example on how load three charts (hide two) then toggle between them using CSS and JavaScript. <!doctype html> <html><head> <meta http-equiv="X-UA-Compatible" content="IE=edge,chrome=1"> <title>Qlik Sense Mashup</title> <meta charset="utf-8"> <meta http-equiv="content-type" content="text/html; charset=UTF-8"> <meta name="HandheldFriendly" content="True ..read more

Firstly I’m not a math whiz. What I’ve done here is take a JavaScript function, convert it to Qlik Sense script code and test it works. The problem… I have two latitude (lat) and longitude (long) coordinates and I wanted to calculate distance between the two as the crow fly’s in km’s. Using google maps I can pick two points, record their coordinates and measure the distance so I know what I’m aiming for. In this example I’m heading from my home to my office (not done that since lockdown) and the magic number is 34.3 km’s Here I find a solution to the problem, the JavaScript code is easy to fol ..read more

The Challenge Most company’s have work flow processes where a piece of work is passed from department to department step by step until its marked as completed. Some processes are well defined, ridged and are simple to map out and others take on a more random path depending on their unique requirements, sometimes looping around the same department several times before it can be marked complete. Ideally I would have loved to work with a defined process where I could map data onto clear info-graphs (see below), perhaps the project will lead there, but for now I’m working with dynamic data. (Sorc ..read more