Skip to content

Instantly share code, notes, and snippets.

View mountaindude's full-sized 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!
56 followers · 52 following
View GitHub Profile
@mountaindude
mountaindude / sense_us_state_region_division.txt
Created October 7, 2015 20:55
QlikView / Sense code mapping US states to regions and divisions
// Load US high level regions (easter, southern, midwest etc) and divisions
// From https://en.wikipedia.org/wiki/List_of_regions_of_the_United_States
// Could also use https://www.npac.com/the-npac/about/npac-regions if more granularity is needed
US_States:
NoConcatenate Load
[State code],
[US census region],
[US census division]
Inline [
State code,US census region,US census division
@mountaindude
mountaindude / sense_set_general
Last active October 11, 2015 04:32
General set analysis syntax
// General syntax for set analysis
{$<Product = Product + {OurProduct1} – {OurProduct2} >}
@mountaindude
mountaindude / wblGen.bat
Created October 16, 2015 07:41 — forked from nate-untiedt/wblGen.bat
A simple batch file that automatically generates the wblfolder.wbl for your Qlik Sense visualization extension.
@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 / node-memory.txt
Created August 24, 2017 18:14
Node.js and PM2 memory limits
# 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 / keybase.md
Created October 18, 2017 07:48
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 / sense_set_sum_per_max_date
Last active October 24, 2017 09:56
QlikView / Sense set expression to pick the data for the last available date
// Sum FieldName per the last available date we have data for, withinin the current selection
Sum( {$<DateNum={$(#=Max(DateNum))}>} FieldName)
@mountaindude
mountaindude / sense_set_max_date
Last active October 24, 2017 09:59
QlikView / Qlik Sense set expression to find largest date
// Use in chart title/subtitle/footer for describing what data is shown in a chart, etc
='Chart contains data up until and including ' & Date(Max({1} Date), 'YYYY-MM-DD')
@mountaindude
mountaindude / sense_slack_post_1.qvs
Created December 7, 2015 12:54
/*
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 / date_variables.qvs
Last active January 23, 2018 10:43
QlikView and Qlik Sense date variables
let vStartOf2ndPreviousQuarter = Date(Floor(QuarterStart(Today(), -2)), 'YYYY-MM-DD');
let vStartOf2ndPreviousQuarterNum = Num(Date(Floor(QuarterStart(Today(), -2)), 'YYYY-MM-DD'));
let vStartOfPreviousQuarter = Date(Floor(QuarterStart(Today(), -1)), 'YYYY-MM-DD');
let vStartOfPreviousQuarterNum = Num(Date(Floor(QuarterStart(Today(), -1)), 'YYYY-MM-DD'));
let vStartOfCurrentQuarter = Date(Floor(QuarterStart(Today())), 'YYYY-MM-DD');
let vStartOfCurrentQuarterNum = Num(Date(Floor(QuarterStart(Today())), 'YYYY-MM-DD'));
let vStartOfPreviousMonth = Date(Floor(MonthStart(Today(), -1)), 'YYYY-MM-DD');
@mountaindude
mountaindude / RegisterNode.ps1
Created August 27, 2019 22:27 — forked from levi-turner/RegisterNode.ps1
Register a Qlik Node using Qlik CLI
<#
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