Stefan Stoichev countnazgul

countnazgul / engine_ref__all_engine_error_codes.js

Last active October 10, 2023 13:46 — forked from theredpea/engine_ref__all_engine_error_codes.js

[Engine error codes] #qlik #qliksense #engine #enigma.js

	var engine_js = {
	"ErrorCode.-128": "Internal engine error",
	"ErrorCode.-1": "Unknown error",
	"ErrorCode.0": "Unknown error",
	"ErrorCode.1": "Some data is not correctly specified.",
	"ErrorCode.2": "The resource could not be found.",
	"ErrorCode.3": "Resource already exists.",
	"ErrorCode.4": "Invalid path",
	"ErrorCode.5": "Access is denied",
	"ErrorCode.6": "The system is out of memory.",

countnazgul / QlikView_Julian_Date_Conversion.qvs

Last active April 17, 2022 06:34 — forked from ralfbecher/QlikView_Julian_Date_Conversion.qvs

[Julian Date to normal Date] Convert from Julian Date to normal Date (Gregorian) #qlik #qlikview #script

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

countnazgul / QlikView_Convert_into_Unix_Timestamp.qvs

Last active April 17, 2022 18:34 — forked from ralfbecher/QlikView_Convert_into_Unix_Timestamp.qvs

[Convert to Unix timestamp] #qlik #qlikview #qliksense #script

	LET t1 = (num(timestamp#('2013-01-11 18:00:00', 'yyyy-mm-dd hh:mm:ss')) - 25569) * 86400;

	LET t2 = (num(Now(1) - 25569) * 86400;