Creating a while loop in Qlik Application Automation
January 14, 2023The lack of or while loops in Qlik's Application Automation, and a method to create a loop was previously covered in creating a loop…
From Dave, who writes to learn things. Thoughts and views are his own.
The lack of or while loops in Qlik's Application Automation, and a method to create a loop was previously covered in creating a loop…
Qlik's Application Automation doesn't support generating a loop out with a block. While there are blocks for looping over existing content…
When asked how to aggregate data in Qlik products in the quickest way, the answer is "it depends". While the key factor is the uniqueness…
Today, QSE SaaS doesn't do task chaining. Instead you have two options: Use a scheduled reload task for every app, and try to make sure the…
When you're troubleshooting or diving into logs, it's useful to have a mapping of object types. The name of an object is defined by the…
I previously posted a bat file that logs disk capacity and utilisation. I thought I'd share the QVF file that loads those simple logs. Some…
This simple snippet provides a randomised data set for testing purposes. The Data The field definitions, based on a data set of 5 million…
To help track disk space on a cluster, here's a simple batch script that works on Windows. It accepts a list of hostnames, and outputs the…
Following a system restart, an overnight shutdown or a system update, some Windows services don't always come up successfully. This script…
This updated snippet (see original post from 2018) is available on GitHub, and included in this post. The main benefits of this script are…
This simple snippet works with Qlik Sense and QlikView 12+ to recursively collect metadata from QVD files. The simple table produced…
As of February 2022, the information shown below is now available on the new Qlik download site at https://community.qlik.com/t5/Downloads…
Following on my previous post, I had a look at the performance impact of enabling QVD and QVF encryption in Qlik Sense. In this test, I'm…
From Qlik Sense Enterprise on Windows September 2019 (the option became configurable via the QMC in November 2019), users have the option of…
As an update to my previous post on using lambda to automate snaphots, I've finally logged back into the Lightsail console and seen they…
In QlikView, you had the ability to select multiple variables and delete them en-mass. In Qlik Sense, the UI permits you to undertake this…
This .gitignore is based on experience of using various Windows, Mac and Linux OS - and a few unexpected commits. It is my go-to for Qlik…
Application icons are prominently displayed throughout the Qlik Sense hub, and they are usually either the default blue, or some…
Forewarning - loading data directly from the repository is not recommended. Most requirements can be met through the QRS APIs. There's a…
If you're doing anything but vanilla Qlik Sense development, it's likely you'll need to get to the object IDs at some point. You can do this…
Revisiting an earlier post on configuring a LAMP server, and on a recent post on installing Webmin, this time I'm dropping CentOS Web Panel…
As a quick refresh from an earlier post, I'm going to use a new CentOS image with Webmin as the control panel of choice. Happily, the only…
I'm often asked how to create mashups with Qlik Sense, and I strongly believe that it's both easy and intuitive to leverage Qlik Sense APIs…
I was receiving emails titled "Cron root@server /usr/bin/kcarectl --auto-update" with a body "The IP 1.2.3.4 was already used for a trial…
A few weeks ago I used AWS S3 for 301 redirects, with Cloudflare on top to cache these requests, few as they were. This effectively…
Simple Event Attendance has been updated to 1.5.1. This is to fix an issue with PHP7.2 where debug logs contain a count function warning…
If you're using a CNAME on your root domain, you're gonna have problems. That's just a DNS thing - and if you want to host a root domain on…
S3 buckets allow you to host static content with a pay-per-get model. No monthly fees and no servers - so I considered how I could use this…
I'm setting up CRR on two buckets, one new, and one existing - which already contains files When you enable cross-region replication on an…
In the past, I've configured these on my domains (and wrote about SPF with GSuite - which was at the time, Google Apps). In the last 9 years…
Update 11/11/19 - limited automatic snapshots now available. Some of the most glaring omissions from Lightsail are scheduled tasks or…
This post details my switch over to using Powershell and Cloudflare to update a DNS record to a server's current IP. This effectively…
As GitHub private repositories have just become free, I'm jumping on the bandwagon and shipping over a few of the repos I have on Bitbucket…
Amazon Web Services (AWS) offers some very affordable archive storage via it's S3 Glacier service. I've used this on a backup account in the…
Previously, I tested the performance of a load script while using RecNo() and RowNo() functions. This conveniently gave me a script which…
There's often a discussion about what each of these autonumber/hash functions does in Qlik. We commonly see these functions used for…
Using RecNo() or RowNo() will impart a performance impact on your load script. I discussed these functions in a previous post where I looked…
Sometimes VirtualBox doesn't behave when it imports Virtual Machines (appliances). I exported a Windows 10 VM from one machine to another…
If you've got a couple of VMs, then trimming them occasionally will help with storage management on the host. Disk files (like VDI and VMDK…
In this post I explore the outputs of RecNo() and RowNo() to demonstrate the difference visually. These two fields are often used…
Structured data is very familiar to most people, as it's what is captured by most user-facing business systems. You've got columns and rows…
Following this post which talks about methods for configuring apps, this post looks at how to achieve this via the QMC in QlikView and set…
For me, the bare minimum when it comes to app configuration in Qlik Sense or QlikView is: - Setting paths and libs for use in data load…
In the absence of a source control system like SVN or GIT, a quick and easy way of capturing changes in a app is to update a version control…
Any environment with more than on developer will quickly lose consistency of attributes across the environment. Agreeing standards as part…
On Demand App Generation (ODAG) was an approach introduced in Qlik Sense 3.0 to use the Qlik Analytic Platform (QAP) APIs to create Qlik…
Default data connections to the Qlik Repository Service API (QRS API) were added in Qlik Sense 3.0. These data connections are used by the…
Domo is a cloud visualisation tool that offers a wealth of connectors (400+ according to their website) and a simple learning curve. I…
I have an installation of the 3arcade script that's still in the wild, and decided it was time to update it to work with PHP 5.6 (at least…
This is a quick post on how to publish updates for Wordpress Plugins (like SEATT) to Wordpress.org. As I rarely use SVN, I forget every time…
Linux file permissions can be applied to files and directories, and using we can quickly get an overview of file properties. The example…
CentOS7 (and some of the other RHEL flavours) currently don't include PHP 5.6+ in the core repos, and yet the versions of PHP bundled are at…
After installing LAMP on new servers (similar to as described here for CentOS), I've recently had two errors after the creation of MySQL…
Simple Event Attendance has been updated to 1.5.0. Update to fulfill some of the requests posted at https://withdave.com/2017/05/seatt…
Since I've updated SEATT there's been a number of requests for additional functionality. The ones I've captured are below: Repeatable…
I've been exploring how to generate videos on the fly through use of packages like ffmpeg (I installed this the other day), and recently…
This is a quick guide to installing the following in CentOS 7: ffmpeg flvtool2 mp4box imagemagick CentOS 7 requires a tweak to the process…
Note to self: do not update Intel Rapid Storage Technology drivers on a HP Proliant ML10v2, unless I really, really need to. I've become…
I downloaded the May 2017 version of PowerBI desktop to load in some of the traffic data that I dropped into Qlik Sense and Tableau in a…
Generally, getting access to vehicle data is a pay-for-data experience - but snapshots are released each year to the public. If you head to…
I've had a copy of some of the Highways Agency data downloaded for about a year - so it was time to have a quick look at it. I'm going to…
This post looks at using Qlik Cloud (using a paid-for tier) to gather and analyse data from Google Analytics. Qlik Cloud doesn't allow user…
As of Qlik Sense 3.2.2, the Qlik ODBC Connector package does not connect to MySQL Community Edition servers. A large number of Linux web…
Alternative Dimensions and Measures have been in Qlik Sense since version 2.2 (see a video on Qlik's site describing how to use them) - but…
Integrating some QlikView screens into Salesforce, and using Salesforce to authenticate your users is actually very simple. Joe Bickley from…
I'm going to build a local VM with the following requirements: It can host PHP/SQL-based websites It has PHPMyAdmin to help administer any…
Updated on 22/12/2017 to add two other ways of generating a CSR (see below). In this post I'm going to look at how quick and easy (and cheap…
I recently worked on an app that was loading from several hundred gigabytes of CSVs, and attempting to perform expensive transformations on…
As someone who doesn't closely follow what's happening with Linux tools, I recently tried a minimal CentOS 7 install, and found out by…
I’ve updated Simple Event Attendance (SEATT WordPress plugin) to version 1.4.0. This brings bug fixes, and updates in line with the release…
QlikView has a wide range of shortcuts, some of which aren't even options in the menu, or listed in the reference manual. The below list…
One of the beauties of Qlik Sense Enterprise is that it can be installed on nearly any Windows machine, with very few pre-requisites. One of…
By default, remote desktop connections on windows use port 3389. If you find the need to change this port, the following should help. Make…
I’ve updated Simple Event Attendance (SEATT WordPress plugin) to version 1.3.0. This brings bug fixes, and updates in line with the release…
The postcode code has been updated to use Google's distancematrix api, which provides a very different set of data from the old "as the bird…
I've used a model B rev 2.0 Raspberry Pi as a Samba and DLNA media server in the past, and normally turn it off through a Webmin control…
I've updated Simple Event Attendance (SEATT Wordpress plugin) to version 1.2.7. This brings bug fixes, and updates in line with the release…
Simple Event Attendance has been updated to 1.2.6: Addition of extra table columns in admin view. Updated screenshots to reflect recent…
This is a problem that's been around for months now and yet still bugs thousands of users. Any of your pages with facebook widgets on can…
This is the third article I've written for pulling functions in phpBB3 for external use. This one allows you to either create new posts in a…
When you're building a new website you often code it 'on-the-fly'. That's to say, strapping in new features here and there until it does…
A while back I posted an article about integrating your site to use the phpBB3 user and login system (here). When I wrote that I also used…
UPDATE: A new version which calculates distance based on roads is available. If you're looking to make any kind of radius checker, delivery…
Using Google Apps for your domain's email? Well you definately need to set up some SPF records. It seems yahoo is extremely strict when it…
UPDATE: It is now easier to send a confirmation email to the provided address to validate it, or to use a framework than a custom script…
I'll start by saying this is not all my own code, it is based on dagon design's original release in 2007 (Automatic MySql Backup Script) but…
Useful for a number of things including username and anything else you don't want ANY special chars in, leaving only alphanumeric digits…
Seeing as ereg_replace and that whole family has been depreciated in the newer PHP releases it's surprising how many sites still show and…
Found it very difficult to find a simple solution to this problem - you want to display the submittor's IP address on a webpage where it…
One way of making an existing site dynamic is to integrate it with a phpBB forum. This is actually very easy, and allows you to quickly pull…