Skip to content

Instantly share code, notes, and snippets.

Avatar
🏔️
Bringing DevOps to Qlik Sense - one tool at a time. Hello SenseOps!

Göran Sander mountaindude

🏔️
Bringing DevOps to Qlik Sense - one tool at a time. Hello SenseOps!
View GitHub Profile
@mountaindude
mountaindude / post-to-teams-from-qliksense.qvs
Last active Oct 18, 2020
Post to Microsoft Teams from Qlik Sense
View post-to-teams-from-qliksense.qvs
// Define webhook for the Teams channel you're posting to.
// You need to create this webhook in Microsoft Teams, then paste the webhook URL in the string below
let vTeamsWebhook = 'https://outlook.office.com/webhook/......';
// You need a data connection called "PostMessageToTeams" for this app to reload correctly.
// >>>>>>>>>>>>>>>>>>>>>>>>>>>
// Define subs
@mountaindude
mountaindude / nicetrace.qvs
Created Sep 30, 2020
Qlik Sense NiceTrace function
View nicetrace.qvs
// This Sub enables prettified output of text to the reload progress window of Qlik Sense.
// Use it to get timestamped trace messages, that also have a prefix that makes them easier
// to spot in the reload progress windows and reload logs.
//
// Usage example:
// call NiceTrace ('This is a debug message, including a variable $(vMetaDataQVDPath)\abc.qvd')
sub NiceTrace (vL.Msg)
@mountaindude
mountaindude / esp32_oled_wifi.md
Created May 8, 2020 — forked from gabonator/esp32_oled_wifi.md
esp32 TTGO arduino compatible board with 128x64 pixel oled display and Wifi
View esp32_oled_wifi.md

esp32 TTGO arduino compatible board with 128x64 pixel oled display and Wifi

Front Back Pinout

Device description on banggood

  1. The main control chip using Le Xin ESP32, Tensilica LX6 dual core processor, clocked at 240MHz, computing capacity of up to 600DMIPS, 520 SRAM, 802.11 KB chip b/g/n HT40 Wi-Fi transceiver, baseband, and LWIP protocol stack, Bluetooth (Bluetooth dual-mode integrated
@mountaindude
mountaindude / RegisterNode.ps1
Created Aug 27, 2019 — forked from levi-turner/RegisterNode.ps1
Register a Qlik Node using Qlik CLI
View RegisterNode.ps1
<#
Run on the Central
#>
# Connect to Qlik Sense
# See https://github.com/ahaydon/Qlik-Cli/wiki/Establishing-a-connection for more connection options
Connect-Qlik
# Add the Node to the Cluster; store the password element of the response for the ZIP as $password
# nodePurpose: 0 (Production) / 1 (Development) / 2 (Both)
# engineEnabled, proxyEnabled, schedulerEnabled, $printingEnabled, $failoverCandidate as options
$password = New-QlikNode -hostname qlikserver2.domain.local -name qlikserver2 -nodePurpose 0 -engineEnabled -proxyEnabled
View keybase.md

Keybase proof

I hereby claim:

  • I am mountaindude on github.
  • I am goransander (https://keybase.io/goransander) on keybase.
  • I have a public key ASALuz07T6sfOgcl3OrCJjJQgThJt1-GMqS7ZjNHjwdQLgo

To claim this, I am signing this object:

@mountaindude
mountaindude / node-memory.txt
Created Aug 24, 2017
Node.js and PM2 memory limits
View node-memory.txt
# Node
node --max-old-space-size=1024 app.js # 1Gb
# PM2
pm2 start app.js --node-args="--max-old-space-size=1024" # 1Gb
@mountaindude
mountaindude / app2json.js
Created Jun 21, 2016 — forked from mindspank/app2json.js
Sample use of serializeapp and buildapp #serializer #engineapi
View app2json.js
var qsocks = require('qsocks')
var serializeApp = require('serializeapp')
var fs = require('fs-extra')
var Promise = require('promise')
function create(docname) {
qsocks.Connect({appname: docname})
.then(function(global) {
return global.openDoc(docname)
})
View sense_slack_post_1.qvs
/*
General format:
curl -X POST --data-urlencode 'payload={"channel": "#sense-notification", "username": "webhookbot", "text": "This is posted to #sense-notification and comes from a bot named sensebot.", "icon_emoji": ":ghost:"}' https://hooks.slack.com/services/<....enter_your_key_here....>
Formatting: https://slack.zendesk.com/hc/en-us/articles/202288908-How-can-I-add-formatting-to-my-messages-
More formatting formatting: https://api.slack.com/docs/formatting
Slack API docs: https://api.slack.com/incoming-webhooks
Available emojis: http://www.emoji-cheat-sheet.com/
*/
@mountaindude
mountaindude / wblGen.bat
Created Oct 16, 2015 — forked from nate-untiedt/wblGen.bat
A simple batch file that automatically generates the wblfolder.wbl for your Qlik Sense visualization extension.
View wblGen.bat
@echo off
REM wblGen.bat - v 1.0.0 - 2015-10-09
REM Description:
REM A simple batch file that automatically generates the wblfolder.wbl for your Qlik Sense visualization extension.
REM
REM Author: Nate Untiedt - Analytics8 - nuntiedt@analytics8.com
REM
REM Credit to: http://stackoverflow.com/a/8387078
setlocal EnableDelayedExpansion
@mountaindude
mountaindude / sense_find_max_value_of_field
Created Oct 11, 2015
Fastest way of finding max/min values of a field in Sense or QV
View sense_find_max_value_of_field
// The obvious way of finding the max/min value of a field might something like this:
//
// LOAD max(salesDate) Resident dataTable;
//
// However, if dataTable is very large (hundred of millions of lines or more, with many columns), the above will be
// very slow, as we will end up traversing that entire table.
//
// Instead, the fastest method of achieving the desired result is to load the FieldValue()s.
// We then only look at the values of the salesDate field itself, and not the entire dataTable table.
// Performance gains by many orders of magnitude can be gained by using this method.
You can’t perform that action at this time.