Simon haty1

## robocopy_script.bat
echo off
Set Name=JobName
Set Source="\\servername\directory"
Set Target="C:\Destination"
Set FilePattern="filename*.xlsx"

Set Today=%date:~-4,4%%date:~-10,2%%date:~-7,2%_%time:~0,2%%time:~3,2%
Set Logname="C:\Logs\%Today%_%Name%.log"
Echo Source is %source%
Echo Target is %target%

## Qlik_Hourly_Interval_Metrics
LOAD
  'Walkbys' AS location_metric_name,
  granularity,
  location_id,
  hour(interval_start) AS hour_of_day,
  weekday(interval_start) AS day_of_week,
  sum(location_walkbys) AS location_metric_value
Resident location_traffic_metrics
WHERE granularity = 'Hourly'
  AND hour(interval_start) >= $(OpeningHour)

## 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/
*/

## sense_set_max_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')

## sense_set_sum_per_max_date
// Sum FieldName per the last available date we have data for, withinin the current selection
Sum( {$<DateNum={$(#=Max(DateNum))}>} FieldName)

## Qlik Moving Average
=rangeavg(above(sum(sales),0,3)) //3 Period Rolling Average

## 0_reuse_code.js
// Use Gists to store code you would like to remember later on
console.log(window); // log the "window" object to the console
	echo off
	Set Name=JobName
	Set Source="\\servername\directory"
	Set Target="C:\Destination"
	Set FilePattern="filename*.xlsx"

	Set Today=%date:~-4,4%%date:~-10,2%%date:~-7,2%_%time:~0,2%%time:~3,2%
	Set Logname="C:\Logs\%Today%_%Name%.log"
	Echo Source is %source%
	Echo Target is %target%
	LOAD
	'Walkbys' AS location_metric_name,
	granularity,
	location_id,
	hour(interval_start) AS hour_of_day,
	weekday(interval_start) AS day_of_week,
	sum(location_walkbys) AS location_metric_value
	Resident location_traffic_metrics
	WHERE granularity = 'Hourly'
	AND hour(interval_start) >= $(OpeningHour)
	/*
	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/
	*/
	// 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')
	// Sum FieldName per the last available date we have data for, withinin the current selection
	Sum( {$<DateNum={$(#=Max(DateNum))}>} FieldName)
	// Use Gists to store code you would like to remember later on
	console.log(window); // log the "window" object to the console