Skip to content

Instantly share code, notes, and snippets.

View martinfcurtis's full-sized avatar

Martin Curtis martinfcurtis

View GitHub Profile
@mountaindude
mountaindude / post-to-teams-from-qliksense.qvs
Last active November 25, 2022 06:00
Post to Microsoft Teams from Qlik Sense
// 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 / sense_create_qvd_load_table
Last active November 17, 2022 23:11
QlikView / Qlik Sense code to create table with all QVDs to load later in a script
// List all QVDs that should be loaded
// In this example the QVDs have a filename format of YYYYMMDD.qvd
//
// The rationale for loading QVDs this way, rather than using something like
// load "/some/path/*.qvd" where date > SomeDate
// is that the latter will have to test the date field of all lines within all QVDs in that directory.
// That might take a long time (and it will become slower over time, if new QVDs are added every day), whereas the method
// used in the code below offers (very close to) constant loading time.
//
For each Filename in 'D:\path\to\qvds'