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
// unnest data of field value: | |
Input: | |
LOAD * INLINE [ | |
ACCOUNT, SUPPLIES | |
001, "Apples,Bananas,Tomatos" | |
002, "Bread,Butter,Cheese" | |
003, "Pretzel,Wuerstl" | |
]; | |
Result: |
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
Companies: | |
LOAD * INLINE [ | |
Company | |
CompanyA | |
CompanyB | |
CompanyC | |
]; | |
List: | |
LOAD |
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:" | |
}; |
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() |
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, |
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') |
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: {}, |
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)'; |
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
// Convert weekname (eg. format YYYY/WW) to date: | |
=MakeWeekDate(subfield(field, '/', 1), subfield(field, '/', 2), 0) |
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
// in this case we want to load a 10% sampling set of the data | |
data: | |
LOAD ….<your fields>… | |
FROM <your QVD file> | |
WHERE ceil(rand() * 100) <= 10; // or: rand() <= 0.1 | |
// SAMPLE n LOAD is much faster but allocates the memory of the full data set during the LOAD | |
// Where rand() <= n allocates only the memory of the smaller result set which could be crucial with Big Data.. |