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:
// 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 |
// General syntax for set analysis | |
{$<Product = Product + {OurProduct1} – {OurProduct2} >} |
@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 |
# Node | |
node --max-old-space-size=1024 app.js # 1Gb | |
# PM2 | |
pm2 start app.js --node-args="--max-old-space-size=1024" # 1Gb |
I hereby claim:
To claim this, I am signing this object:
// Sum FieldName per the last available date we have data for, withinin the current selection | |
Sum( {$<DateNum={$(#=Max(DateNum))}>} FieldName) |
// 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') |
/* | |
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/ | |
*/ |
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'); |
<# | |
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 |