View getSnowflakeQueryID.go
import ( | |
"context" | |
"database/sql" | |
"database/sql/driver" | |
"errors" | |
"reflect" | |
// ... | |
sf "github.com/snowflakedb/gosnowflake" | |
) |
View mashupEnigmaRequire.js
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
// | |
// 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
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
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
// 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
define([ | |
"jquery", | |
"qlik", | |
"underscore" | |
], | |
function ($, qlik, _) { | |
'use strict'; | |
return { | |
initialProperties: {}, |
View KeepFields.qvs
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
//subtract hour from timestamp when DST | |
=TimeStamp(field - frac(ConvertToLocalTime(field,'Berlin') - frac(field)) + 1/24) |
View Qlik_Nice_Number_Format.qvs
//---------------------------------------------- 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