Ralf Becher ralfbecher
ralfbecher
/ QlikView_Concat_Aggregation_Limitation.qvs
Created
February 16, 2014 15:02
QlikView textbox object and chart fields (straight table) can only show a text length of 65,535 characters. If the length of the text exceeds this size an empty textbox/field is shown which is a bit confusing. This can easily occur when a Concat aggregation is used.
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
| One should use a Concat aggregation on high amount of values with a left always: | |
| =Left(Concat(DISTINCT Number,','), 65535) |
ralfbecher
/ QlikView_Julian_Date_Conversion.qvs
Created
June 10, 2014 12:12
QlikView Julian Date Conversion
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
| // to convert from Julian Date to normal Date (Gregorian) | |
| // subtract the offset 2415019 (equivalent to 30.12.1899, which is day 0 in QlikView): | |
| Date(JulianDateField - 2415019) | |
| //You probaly have to adjust the timezone since Julian Date is in UTC. | |
| // to convert from normal Date (Gregorian) to Julian Date | |
| // add the offset 2415019 (equivalent to 30.12.1899, which is day 0 in QlikView): |
ralfbecher
/ QlikView_Calc_Days_per_Month_of_TimeSpans.qvs
Created
June 13, 2014 13:22
Calculate days per month from time span events in QlikView
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
| Data: | |
| LOAD * INLINE [ | |
| id, start_date, end_date | |
| 1234, 01.01.2014, 20.04.2014 | |
| 5678, 23.02.2014, 25.03.2014 | |
| 9012, 30.03.2014, 01.04.2014 | |
| ]; | |
| Result: | |
| NOCONCATENATE LOAD |
ralfbecher
/ QlikView_Extension_Load_JavaScript_via_RequireJS_to_solve_UTF-8_issue.js
Last active
August 29, 2015 14:06
QlikView Extension Load JavaScript via RequireJS to solve UTF-8 issue
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
| // thanks to Stefan Walther for giving a hint an this matter: https://github.com/stefanwalther | |
| Qv.LoadExtensionScripts([_path + 'js/require.js'], | |
| function () { | |
| require([_path + 'js/d3.v3', _path + 'js/nv.d3.min', _path + 'js/interactiveLayer', _path + 'js/utils'], | |
| function () { | |
| Qv.AddExtension(_extension, | |
| function () { | |
| // render it.. |
ralfbecher
/ QlikView_get_and_format_microseconds.qvs
Last active
August 29, 2015 14:16
QlikView get and format microseconds
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
| //Formula to optain microseconds from TimeField: | |
| LOAD ((frac(TimeField) * 86400000) - floor(frac(TimeField) * 86400000)) * 1000 as Micro | |
| FROM ...; | |
| //Use this formula for formatting: | |
| LOAD Timestamp(TimeField - (Micro/86400000000)) & Num(floor(Micro), '000') as TimeStamp | |
| FROM ...; |
ralfbecher
/ Neo4j-2.2_ajax_authentication_example.js
Created
March 12, 2015 15:25
Neo4j 2.2 AJAX authentication example
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
| $.ajaxSetup({ | |
| headers: { | |
| "Authorization": 'Basic ' + window.btoa(username+":"+password) | |
| } | |
| }); | |
| $.ajax(txUrl(), { | |
| type: "POST", | |
| data: JSON.stringify({ | |
| statements: [{ | |
| statement: query, |
ralfbecher
/ QlikView_color_code_percentage_of_max_value.qvs
Created
August 23, 2015 18:32
QlikView color code percentage of max value
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
| =Replace( | |
| ColorMix2 (if(rangemin(.90,rangemax( Sum(value) / Max({1} TOTAL value),.50))<.75,-Sqrt(-(rangemin(.90,rangemax( Sum(value) / Max({1} TOTAL value),.50))-.75)/(.75-.50)),Sqrt((rangemin(.90,rangemax( Sum(value) / Max({1} TOTAL value),.50))-.75)/(.90-.75))), RGB(255, 0, 0), RGB(0, 255, 0), RGB(255, 255, 0)) | |
| ,'ARGB(255,','RGB(') |
ralfbecher
/ Qlik_Sense_example_extension_with_switchable_user_custom_properties.js
Last active
September 15, 2015 18:19
Qlik Sense example extension with switchable user custom properties
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
| /** | |
| * @owner Ralf Becher, irregular.bi | |
| */ | |
| define( ["jquery", "qlik"], | |
| function ($, qlik) { | |
| return { | |
| //property panel | |
| definition: { | |
| type: "items", | |
| component: "accordion", |
ralfbecher
/ QlikView_transform_matrix_into_adjacencylist.qvs
Last active
September 26, 2015 20:20
QlikView transform matrix into adjacencylist
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
| // matrix has numeric field names starting from "0" and a record number: | |
| for i=0 to 34 | |
| for j=0 to 34 | |
| adj_list: | |
| LOAD $(i) as node1, | |
| $(j) as node2, | |
| "$(j)" as measure | |
| resident matrix | |
| Where rec - 1= $(i) and "$(j)" > 0; | |
| next |
ralfbecher
/ QlikView_Expression_NewProductPerYear.qvs
Last active
October 21, 2015 20:03
QlikView Chart Expression Counts New Products/Year
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
| data: | |
| LOAD * INLINE [ | |
| Year, Product | |
| 2010, P1 | |
| 2011, P1 | |
| 2012, P1 | |
| 2010, P2 | |
| 2011, P2 | |
| 2011, P3 | |
| 2012, P3 |
OlderNewer