qliksense

A collection of 64 posts

ctrl-q

Manage Qlik Sense user sessions in style

Managing user sessions in client-managed Qlik Sense can be tricky or even outright difficult in large Sense environments. Ctrl-Q includes powerful tools that makes this work easier!

qliksense

Automate Safari browser using macOS Script Editor

Using AppleScript the Safari browser can be remote controlled, automatically logging several users into Qlik Sense.

qliksense

How to start on-premise Qlik Sense tasks from anywhere

Start Qlik Sense reload tasks from anywhere, using a single http call. Can be very useful when source systems need to trigger data reloads in Sense. The solution is low cost and can be made as secure as needed using Azure Event Grid and Function Apps.

ctrl-q

Visualise Qlik Sense reload tasks using Ctrl-Q

Ctrl-Q lets you visualise Qlik Sense task dependencies as trees or - as of Ctrl-Q 3.15 - network graphs! This gives an unprecedented overview of complex task chains in any Qlik Sense Enterprise environment.

butler

SenseOps 2023-Q4 summary

Summary of what's new in the various Butler tools. Better real-time monitoring of Qlik Sense via Butler SOS, Azure support for the original Butler and bulk task import in Ctrl-Q.

ctrl-q nr

Low-code find-replace in Qlik Sense app load scripts

Manually update app load scripts can be extremely time consuming. Ctrl-Q NR can assist in that use-case by both identifying apps that should be updated, doing a find-replace operation of all apps' load scripts, and finally reloading the apps.

ctrl-q nr

How to email all Qlik Sense Cloud users

Ctrl-Q NR and Node-RED can be used to get metadata for users in a Qlik Sense Cloud tenant. This can be combined with the email node in Node-RED to create a basic but quite flexible email service that can send emails to all users with email addresses in the tenant.

ctrl-q nr

Monitoring Qlik Sense Cloud app reloads using Node-RED

Ctrl-Q NR has a node that mirrors the reload state of all apps in a Qlik Sense Cloud tenant. Using this node it is possible to build logic that triggers when (for example) app reloads change from "Running" to "Failed".

ctrl-q nr

Qlik Sense license info, low-code style

Ctrl-Q NR includes license nodes for both client-managed and cloud versions of Qlik Sense. These nodes make it easy to create license monitoring solutions that will for example alert fixed number of days before licenses expire.

ctrl-q

Ctrl-Q NR: Low-code tools for Qlik Sense

Ctrl-Q NR is a set of Node-RED nodes that make it easy to use both Qlik Sense Cloud and client-managed Qlik Sense from within the low-code Node-RED platform.

butler-sheet-icons

Butler Sheet Icons 3.1.0

Butler Sheet Icons 3.1.0 adds support for latest Qlik Sense versions, plus a new "browser" command that controls which browser is used to take screenshots of Qlik Sense sheets.

butler

🎉 Butler 9.0 - Monitoring Windows services

With Butler 9.0 it's easy to monitor Windows services, which combined with the already existing reload task monitoring makes Butler a comprehensive solution for high-availability Qlik Sense solutions.

qs-jwt

qs-jwt: JWT auth for Qlik Sense

JWTs - JSON Web Tokens is a well-established way to authenticate with APIs. The open source tool qs-jwt greatly simplifies the creation of JWTs for both Qlik Cloud and client-managed Qlik Sense.

qliksense

The lazy Qlik developer #4: How many users right now?

PowerShell script that will show how many - and what - users are connected to a client-managed Qlik Sense Enterprise server.

ctrl-q

Ctrl-Q 3.9 brings colors to Qlik Sense master items

In previous versions Ctrl-Q could import master dimensions and measures from definitions in an Excel file into client-managed Qlik Sense Enterprise. Ctrl-Q 3.9 adds full color support to those imports.

butler

Running Butler tools as Windows services

Several of the Butler family of open source tools for Qlik Sense Enterprise are intended to run 24/7. This article looks at how to achieve enterprise grade deployment of Butler & friends using standard Windows services.

ctrl-q

The lazy Qlik developer #3: Bulk export/import of both apps and reload tasks

Ctrl-Q now supports bulk export of both Qlik Sense apps and reload tasks, as well as storing associated metadata in a file on disk. Then import those apps/tasks into Sense again. Reload-tasks-as-code is now possible!

qliksense

Using ChatGPT to create Qlik Sense scripts

Can a language model like ChatGPT be used to create code for Qlik Sense? The answer is yes - and no. It's very impressive indeed but doesn't quite replace us humans yet.

ctrl-q

Bulk update of Qlik Sense task custom properties

Setting custom properties for dozens or hundreds of Qlik Sense reload tasks can easily take hours. Ctrl-Q has a command that automate this and also remove the risk for manual errors.

ctrl-q

🌴 Qlik Sense task trees using Ctrl-Q

Qlik Sense lacks a good built-in viewer for task dependencies. Ctrl-Q address this by offering a cross-platform tool for visualising Sense task trees, including latest execution result.

ctrl-q

Bulk export/import of reload tasks in client-managed Qlik Sense

The open source tool Ctrl-Q can be used to do bulk export/import of reload tasks in client-managed Qlik Sense Enterprise on Windows.

ctrl-q

👋 Please meet Ctrl-Q!

…a new open source tool for Qlik Sense admins and developers ❓ Have you ever had to manually create dozens or even hundreds of master items in a Sense app? 😓 Only to later having to delete half of them? 🤯 ❓ Or needed a detailed list of all bookmarks in an app? ❓ Or

qliksense

A no-compromise Qlik Sense backup solution, part 2

The previous post focused on how to do a high level backup of all information in a client-managed Qlik Sense Enterprise on Windows (QSEoW) cluster. Let’s dig into details a bit and take a look at how we can do more granular backups of various parts of QSEoW. Specifically,

qliksense

A no-compromise Qlik Sense backup solution, part 1

Over the years there has been numerous discussion in the Qlik community about how to best back up a client-managed Qlik Sense Enterprise on Windows system (QSEoW). The backup and data security policies of different organisations of course differs, but if we focus on the Qlik Sense side of things

butler-sheet-icons

Butler Sheet Icons v2.1 is out

Happy unicorns! Free cake! 🦄 🍰 …and a new version of everyone’s favourite tool for creating #Qlik Sense sheet icons. Following up on last week’s release, version 2.1 is now out. Largely based on feedback from the v2.0, the new version adds: 1️⃣ Exclude some sheets from getting