Generating Test Data In Qlik Load Scripts
The Qlik Sense and QlikView Blog by Steve Dark
by Steve Dark
4M ago
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. Data Without a Source Typically a Qlik application will load its data from a data source, such as a database, API or flat file. Sometimes you just want to create something on the fly. The AUTOGENERATE function is a great way of doing this, and many of the applications on my Qlik Examples pa ..read more
Visit website
Change to Qlik SaaS Licences API Endpoint
The Qlik Sense and QlikView Blog by Steve Dark
by Steve Dark
7M ago
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. Background to Using the API The Qlik SaaS API can be used for retrieving information regarding your SaaS environment and also for making changes in your environment, such as allocating permissions. The endpoints available to end-users are the same e ..read more
Visit website
Compare Rolling Twelve Month Period in Qlik
The Qlik Sense and QlikView Blog by Steve Dark
by Steve Dark
11M ago
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. The Challenge The question was posed on Qlik Community how to overlay two 12 month measures in one chart. Using set analysis it is straight forward to have two measures which cover the correct date ranges, but when the Month dimension is used it will sort by calendar month, rather in the order required for rolling periods. Yo ..read more
Visit website
Instant Qlik Sense Application Changes in 2022
The Qlik Sense and QlikView Blog by Steve Dark
by Steve Dark
1y ago
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. Instant Sense Application Live Demos It is sometimes to hard to describe what the Instant Sense Application is or how it functions. The ..read more
Visit website
Google SMTP and IMAP to break in Qlik Apps Next Month
The Qlik Sense and QlikView Blog by Steve Dark
by Steve Dark
2y ago
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. Why Use GMail For Sending and Receiving From Qlik? There are a wide number of features within the Qlik ecosystem that require interaction with email. QlikView Enterprise allows sending of alerts on task failures, NPrinting is all about distributing reports and Qlik Sense SaaS has multiple features for sending ..read more
Visit website
Back Up Qlik Sense Enterprise Client Managed Applications
The Qlik Sense and QlikView Blog by Steve Dark
by Steve Dark
2y ago
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. API Connections in Qlik ..read more
Visit website
Use IFTTT and Webhooks to Send Data from Qlik Sense
The Qlik Sense and QlikView Blog by Steve Dark
by Steve Dark
3y ago
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. So, Why Use IFTTT With Qlik Sense? In my previous blog post I showed how to create an app to monitor Qlik analyzer capacity licence usage in Qlik Cloud. My favourite response to the last post was from Tom Wittig, who said he had five clients needing the app. That got me thinking, what if you have many sites to keep an eye on in Qlik SaaS? You would want to take th ..read more
Visit website
Monitor and Notify Sense Capacity Licence Usage in Qlik Cloud
The Qlik Sense and QlikView Blog by Steve Dark
by Steve Dark
3y ago
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. What is Capacity Licencing? Purchased in packs of 1,000 minutes per calendar month, a capacity licence is a subscription which can be consumed by any user for access to any app in six minute time slices. This flexibility makes the capacity licence an excellent choice for ..read more
Visit website
Loading Data from Online CSV Sources into Qlik
The Qlik Sense and QlikView Blog by Steve Dark
by Steve Dark
3y ago
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. Introducing The CSV Data Recently I was asked to be involved with the Data On The Earth project. This is an initiative to get data that can help everyone, from ..read more
Visit website
Analysing Sense Session Logs
The Qlik Sense and QlikView Blog by Steve Dark
by Steve Dark
3y ago
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. Logging on Qlik Sense Enterprise With the default settings on logs in Sense Enterprise get written to two locations. One for the log file currently being written to and then an archive, where the current log is moved to periodically. By loading from both of those sources you get a good picture of what is go ..read more
Visit website

Follow The Qlik Sense and QlikView Blog by Steve Dark on FeedSpot

Continue with Google
Continue with Apple
OR