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" | |
) |
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" | |
}); |
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:" | |
}; |
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') |
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