ralfbecher

import (
	"context"
	"database/sql"
	"database/sql/driver"
	"errors"
	"reflect"
  // ...
	sf "github.com/snowflakedb/gosnowflake"
)

ralfbecher

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

//
// 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

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()

ralfbecher

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, 

ralfbecher

// 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

define([
    "jquery",
    "qlik",
    "underscore"
    ],
    function ($, qlik, _) {
        'use strict';

        return {
            initialProperties: {},

ralfbecher

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)';

ralfbecher

//subtract hour from timestamp when DST
=TimeStamp(field - frac(ConvertToLocalTime(field,'Berlin') - frac(field)) + 1/24)

ralfbecher

//---------------------------------------------- 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,
))))) &