Martin Curtis martinfcurtis
mountaindude
/ post-to-teams-from-qliksense.qvs
Last active
November 25, 2022 06:00
Post to Microsoft Teams from Qlik Sense
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| // 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
/ 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
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| // 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' |