Qlik Sense & QlikView Blog

Generating Test Data In Qlik Load Scripts

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. […]

By |2023-11-19T21:32:39+00:00November 20th, 2023|Back To Basics, Qlik Sense Tutorials|0 Comments

Change to Qlik SaaS Licences API Endpoint

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. […]

By |2023-09-14T09:20:46+00:00September 14th, 2023|Instant App, Load Script|3 Comments

Compare Rolling Twelve Month Period in Qlik

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. […]

By |2023-05-05T11:12:11+00:00May 5th, 2023|Load Script, Qlik Sense Tutorials|2 Comments

Instant Qlik Sense Application Changes in 2022

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. […]

By |2023-04-12T11:45:30+00:00December 20th, 2022|Instant App, Qlik Sense|0 Comments

Google SMTP and IMAP to break in Qlik Apps Next Month

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. […]

By |2022-04-25T09:15:25+00:00April 25th, 2022|Qlik Sense Tutorials, QlikView Tutorial|4 Comments

Back Up Qlik Sense Enterprise Client Managed Applications

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. […]

By |2023-04-15T08:43:55+00:00March 21st, 2022|Instant App, Qlik Sense Tutorials|6 Comments

Use IFTTT and Webhooks to Send Data from Qlik Sense

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. […]

By |2021-05-12T15:37:15+00:00May 12th, 2021|Qlik Sense, Qlik Sense Tutorials|0 Comments

Monitor and Notify Sense Capacity Licence Usage in Qlik Cloud

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. […]

By |2023-08-18T15:54:05+00:00May 5th, 2021|Qlik Sense Tutorials|2 Comments

Loading Data from Online CSV Sources into Qlik

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. […]

By |2023-02-26T16:48:41+00:00January 8th, 2021|Instant App, Load Script, Qlik Sense Tutorials|0 Comments

Analysing Sense Session Logs

There are a number of monitoring apps that ship with Qlik Sense Enterprise on Premise, some of which you need to upload to your site. All of these are black-boxes to an extent though. What if you want to build your own analysis over the Sense log files? Well, this blog post has you covered. […]

By |2023-02-26T16:51:04+00:00August 20th, 2020|Instant App, Qlik Sense Tutorials|4 Comments
Go to Top