Ralf Becher ralfbecher
ralfbecher
/ getSnowflakeQueryID.go
Last active Feb 6, 2021
Golang get Snowflake QueryID out of *sql.Rows
View getSnowflakeQueryID.go
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
| import ( | |
| "context" | |
| "database/sql" | |
| "database/sql/driver" | |
| "errors" | |
| "reflect" | |
| // ... | |
| sf "github.com/snowflakedb/gosnowflake" | |
| ) |
ralfbecher
/ mashupEnigmaRequire.js
Created Feb 6, 2018
Qlik Sense Mashup with Enigma.js - the official way
View mashupEnigmaRequire.js
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
| var prefix = window.location.pathname.substr(0, window.location.pathname.toLowerCase().lastIndexOf("/extensions") + 1); | |
| var config = { | |
| host: window.location.hostname, | |
| prefix: prefix, | |
| port: window.location.port, | |
| isSecure: window.location.protocol === "https:" | |
| }; | |
| require.config({ | |
| baseUrl: (config.isSecure ? "https://" : "http://") + config.host + (config.port ? ":" + config.port : "") + config.prefix + "resources" | |
| }); |
ralfbecher
/ mashupEnigma.js
Created Dec 29, 2017
Qlik Sense Mashup bind Enigma before openApp() is called
View mashupEnigma.js
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
| // | |
| // Bind Enigma before openApp() is called | |
| // | |
| var prefix = window.location.pathname.substr(0, window.location.pathname.toLowerCase().lastIndexOf("/extensions") + 1); | |
| var config = { | |
| host: window.location.hostname, | |
| prefix: prefix, | |
| port: window.location.port, | |
| isSecure: window.location.protocol === "https:" | |
| }; |
ralfbecher
/ getObjectId.ts
Created Dec 28, 2017
Qlik Sense Extension get right Object Id in all Situations (vanilla, master item, story)
View getObjectId.ts
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
| function getObjectId(scope: any): Promise<string> { | |
| return new Promise((resolve, reject) => { | |
| try { | |
| let objectId: string = ""; | |
| if (scope.layout.sourceObjectId) { | |
| // story | |
| objectId = scope.layout.sourceObjectId; | |
| scope.component.model.app.getObject(objectId) | |
| .then( ( obj: EngineAPI.IGenericObject ) => { | |
| obj.getProperties() |
View Qlik_master_Calendar_DE.qvs
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
| Kalender: | |
| Load | |
| TempDate AS [Issue Datum], | |
| Year(TempDate) As Jahr, | |
| Month(TempDate) As Monat, | |
| monthname(TempDate) as [Monat Jahr], | |
| Day(TempDate) As Tag, | |
| 'Q' & ceil(month(TempDate) / 3) AS Quartal, | |
| 'Q' & ceil(month(TempDate) / 3) & ' ' & Year(TempDate) AS [Quartal Jahr], | |
| Dual('KW' & Week(weekstart(TempDate)), Week(weekstart(TempDate))) as Woche, |
View Qlik_Jira_Time_Formattings.qvs
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
| // Format a time like in JIRA: 4w 3d 06:30 | |
| // means: 4 weeks + 3 days (1 day = 8 hrs) + 6 hrs + 30 mins | |
| If(Floor(Sum(AllIssues_fields_aggregatetimeoriginalestimate)/28800)/5 >= 1, | |
| Num(Floor(Floor(Sum(AllIssues_fields_aggregatetimeoriginalestimate)/28800)/5), '#0') & 'w ', '') & | |
| Num(Frac(Sum(AllIssues_fields_aggregatetimeoriginalestimate)/28800/5) * 5, '#0') & 'd ' & | |
| Interval(Frac(Sum(AllIssues_fields_aggregatetimeoriginalestimate)/28800)/3, 'hh:mm') |
ralfbecher
/ QlikSenseClassicExtensionDebounceExample.js
Created May 9, 2017
A simple way to debounce in a paint() function of a classic (non-angular) QlikSense extension
View QlikSenseClassicExtensionDebounceExample.js
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([ | |
| "jquery", | |
| "qlik", | |
| "underscore" | |
| ], | |
| function ($, qlik, _) { | |
| 'use strict'; | |
| return { | |
| initialProperties: {}, |
View KeepFields.qvs
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
| Sub KeepFields(Fields,TableName) | |
| Let n = NoOfFields('$(TableName)'); | |
| Set d = #; | |
| For i = 1 to $(n) | |
| Let f = FieldName($(i), '$(TableName)'); | |
| If Index('$(Fields)', ',$(f),') = 0 then | |
| If '$(d)' = '#' then | |
| Let d = '$(f)'; | |
| Else | |
| Let d = '$(d),$(f)'; |
View Qlik_Subtract_DST.qvs
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
| //subtract hour from timestamp when DST | |
| =TimeStamp(field - frac(ConvertToLocalTime(field,'Berlin') - frac(field)) + 1/24) |
View Qlik_Nice_Number_Format.qvs
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
| //---------------------------------------------- Nice Numberformat simplified --------------------------------------------- | |
| // does work with count in KPI object (have seen several versions from Qlik which haven't worked) | |
| Set vF_NiceNumberSimple = | |
| If(Fabs($1) > 1e9, Num($1/1e9+1e-13, '#$(ThousandSep)##0$(DecimalSep)00') | |
| ,If(Fabs($1) > 1e8, Num($1/1e6+1e-13, '##0$(DecimalSep)0') | |
| ,If(Fabs($1) > 1e6, Num($1/1e6+1e-13, '##0$(DecimalSep)00') | |
| ,If(Fabs($1) > 1e5, Num($1/1e3+1e-13,'##0$(DecimalSep)0') | |
| ,If(Fabs($1) > 1e3, Num($1/1e3+1e-13, '##0$(DecimalSep)00') | |
| , $1, | |
| ))))) & |
NewerOlder