Sometimes the options available in the Sense Cloud scheduler are not sufficient to build the application reload chain that is required. Perhaps loads need to happen in response to external events, or be started by someone that you don’t want to give that level of access to in Cloud. A simple Qlik automation can solve this by kicking off the reload from a webhook. This post shows you how. […]
Sometimes you need to create test data to ensure that a Qlik function behaves the way you expect it should. Recently I had just that requirement to prove that the Correl function gave good results over semi-predictable data. This post shows how you can create data on the fly for these kind of purposes. […]
There is a massive amount of information that can be loaded directly into your Sense apps from the Qlik Cloud API. If you have been loading from the Licences endpoint though you may have noticed a change to the response since yesterday. The userId and name fields in the response have now been replaced with subject, potentially breaking your script. […]
Creating a line chart in Qlik showing a year on year comparison is very easy, using the Month and Year functions to create two dimensions. What if you want to show a rolling twelve month comparison though? This is not quite so obvious, but this post makes it just as easy. […]
A few years ago I created the Instant Sense Application, a template application with twelve sheets of analysis, which allows me to load in any data source and roll it out at a client. To enable any Sense user to be able to do the same I made the application free to download from our website. The application evolves as new features are required and when Qlik brings in new features to Sense itself. This posts rolls up some of the changes in the past year or so. […]
Many posts and articles, including on this blog, have recommended the use of GMail for sending and receiving mails with Qlik. More recently this has required a switch on the Google Account to Allow Less Secure Apps. Support for this is ending on the 31st May, here’s what you need to know. […]
It is common to back up Qlik Sense Client Managed servers at a server level, often with a virtual machine snapshot. Applications can be backed up by having copies of them in different streams or work areas on the server. Apps can be exported one application at a time using the Export function, which is time consuming. Or a file level backup can be made by copying the repository, but apps are hard to identify as they all have a GUID for the name. This post looks at a simple way that all apps can be copied to a different location, as a QVF file, with a sensible file name. […]
Webhooks are a glue that can hold many different services together. This post shows how they can be used to call IFTTT from the Qlik load script, which then opens up a whole world of possibilities, such as writing to a Google Sheet. […]
Capacity licences are a great way of granting many, infrequent, users access to your Qlik apps. Monitoring usage of available capacity is critical though and is not immediately straightforward in Qlik Cloud (SaaS). This tutorial, and sample app, show how you can monitor usage and alert when usage is exceeding what is expected. […]
There are myriad different data sources out there, and it is possible to load any of them into Qlik. Some are easier than others, sure, but there is always a way. There are good articles and posts on some of the trickier sources, but today I want to show you how you can bring in CSV data from GitHub. This means you can pull up to date, crowdsourced and governed data directly into your applications, just by following these simple steps. […]
