Last active
June 14, 2019 20:26
-
-
Save theredpea/d17d74de87e4563037b4aabd74cae2a0 to your computer and use it in GitHub Desktop.
This file contains hidden or 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
(******************************************************************************) | |
(* QlikView Expression Syntax *) | |
(******************************************************************************) | |
(* An extended subset of the script syntax file *) | |
(* *) | |
(* Things like function, field, macro and bookmark names are added at runtime *) | |
(* *) | |
(******************************************************************************) | |
RawText = {SCANNER_TOKEN_MATCH_ANYTHING}; | |
AnyString = ( IDENTIFIER | LITERAL_STRING | LITERAL_FIELD ); | |
AnyStringOrNumber = ( IDENTIFIER | LITERAL_STRING | LITERAL_FIELD | LITERAL_NUMBER); | |
StringOperatorLike = ?helpid=46848? 'like'; | |
LogicalOperatorNot = ?helpid=46849? 'not'; | |
LogicalOperatorAnd = ?helpid=46850? 'and'; | |
LogicalOperatorOr = ?helpid=46851? 'or'; | |
LogicalOperatorXor = ?helpid=46852? 'xor'; | |
RelationalOpertorFollows = ?helpid=46853? 'follows'; | |
RelationalOpertorPrecedes = ?helpid=46854? 'precedes'; | |
BitOperatorNot = ?helpid=46855? 'bitnot'; | |
BitOperatorAnd = ?helpid=46856? 'bitand'; | |
BitOperatorOr = ?helpid=46857? 'bitor'; | |
BitOperatorXor = ?helpid=46858? 'bitxor'; | |
ExpressionConstant = ( LITERAL_NUMBER | LITERAL_STRING ); | |
ExpressionFieldRef = FieldName; | |
ExpressionFieldRefFixFormat = < IDENTIFIER ?helpid=46859? ':' > (IDENTIFIER|LITERAL_NUMBER) [( ?helpid=46860? 'T' | ?helpid=46861? 'N' | ?helpid=46862? 'R' | ?helpid=46863? 'I' | ?helpid=46864? 'U' | ?helpid=46865? 'B' )]; | |
ExpressionUnaryOperator = ( OPERATOR_PLUS | OPERATOR_MINUS | LogicalOperatorNot | BitOperatorNot ); | |
ExpressionBinaryOperator = (OPERATOR_PLUS | OPERATOR_MINUS | OPERATOR_MULTIPLICATION | OPERATOR_DIVISION | | |
OPERATOR_STRING_CONCAT | StringOperatorLike | | |
LogicalOperatorAnd | LogicalOperatorOr | LogicalOperatorXor | | |
OPERATOR_LESS | OPERATOR_LESS_EQUAL | OPERATOR_GREATER | OPERATOR_GREATER_EQUAL | OPERATOR_EQUAL | OPERATOR_NOT_EQUAL | | |
RelationalOpertorFollows | RelationalOpertorPrecedes | | |
BitOperatorAnd | BitOperatorOr | BitOperatorXor | OPERATOR_RIGHT_SHIFT | OPERATOR_LEFT_SHIFT ); | |
UnaryExpression = ( ExpressionFunctionCall | | |
ModuleFunctionCall | | |
<ExpressionUnaryOperator Expression> | | |
ExpressionConstant | | |
ExpressionFieldRef | | |
ExpressionFieldRefFixFormat | | |
'(' Expression ')' | | |
ExpressionLabel | | |
DefinedVariableName | |
); | |
Expression = UnaryExpression [ExpressionBinaryOperator Expression]; | |
Sort-type-NUMERIC = ?helpid=46866? 'NUMERIC' ',' ( ?helpid=46867? 'ASCENDING' | ?helpid=46868? 'DESCENDING' | ?helpid=46869? 'REVERSE');Sort-type-TEXT = ?helpid=46870? 'TEXT' ',' ( ?helpid=46871? 'ASCENDING' | ?helpid=46872? 'A2Z' | ?helpid=46873? 'DESCENDING' | ?helpid=46874? 'REVERSE' | ?helpid=46875? 'Z2A');Sort-type-FREQUENCY = ?helpid=46876? 'FREQUENCY' ',' ( ?helpid=46877? 'ASCENDING' | ?helpid=46878? 'DESCENDING' | ?helpid=46879? 'REVERSE');Sort-type-LOAD_ORDER = ?helpid=46880? 'LOAD_ORDER' ',' ( ?helpid=46881? 'ASCENDING' | ?helpid=46882? 'DESCENDING' | ?helpid=46883? 'REVERSE' | ?helpid=46884? 'ORIGINAL');Sort-type = (Sort-type-NUMERIC | Sort-type-TEXT | Sort-type-FREQUENCY | Sort-type-LOAD_ORDER); | |
StructuredParameter = (Sort-type | Expression | '(' StructuredParameter {',' StructuredParameter} ')'); | |
SetExpression = ?helpid=46885? '{'SetEntityExpression ?helpid=46886? '}'; | |
SetEntityExpression = UnarySetEntityExpression [SetOperator SetEntityExpression]; | |
UnarySetEntityExpression = ( SetEntity | '(' SetEntityExpression ')' ); | |
(* SetEntity = [SetIdentifier] [SetModifier]; *) | |
SetEntity = ( SetIdentifier [SetModifier] | SetModifier ); | |
SetIdentifier = ( ?helpid=46887? '0' | ?helpid=46888? '1' | Dog ?helpid=46889? '::' | Cat ?helpid=46890? '::' | Dog ?helpid=46891? '::' Cat ?helpid=46892? '::'); | |
Cat = ( ?helpid=46893? '$' | SetIdentfierBack | SetIdentfierNext | BookmarkId | BookmarkName ); | |
SetIdentfierBack = ( ?helpid=46894? '$1' | ?helpid=46895? '$2' | ?helpid=46896? '$3' | ?helpid=46897? '$4' | ?helpid=46898? '$5' ); | |
SetIdentfierNext = ( ?helpid=46899? '$_1' | ?helpid=46900? '$_2' | ?helpid=46901? '$_3' | ?helpid=46902? '$_4' | ?helpid=46903? '$_5' ); | |
SetOperator = ( ?helpid=46904? '+' | ?helpid=46905? '-' | ?helpid=46906? '*' | ?helpid=46907? '/' ); | |
SetModifier = ?helpid=46908? '<' FieldSelection {',' FieldSelection} ?helpid=46909? '>'; | |
FieldSelection = FieldName [ ('=' | ?helpid=46910? '+=' | ?helpid=46911? '-=' | ?helpid=46912? '*=' | ?helpid=46913? '/=')] [ElementSetExpression]; | |
ElementSetExpression = ElementSet { SetOperator ElementSet } ; | |
ElementSet = ( StateQualifiedFieldName | ?helpid=46914? '{' [ElementList] ?helpid=46915? '}' | ElementFunction ); | |
ElementList = Element {',' Element}; | |
ElementFunction = ( ?helpid=46916? 'P'| ?helpid=46917? 'E') '(' ([SetExpression] [FieldName] | StateQualifiedFieldName) ')'; | |
Element = ( ElementFieldValue | ElementSearchMask ); | |
ElementFieldValue = AnyStringOrNumber; | |
ElementSearchMask = AnyString; | |
StateQualifiedFieldName = (Dog ?helpid=46918? '::' | Cat ?helpid=46919? '::' | Dog ?helpid=46920? '::' Cat ?helpid=46921? '::' | ?helpid=46922? '::') FieldName; | |
ExpressionEntry = ['='] Expression; | |
TextOnlyEntry = RawText; | |
ExpressionLabel = (); | |
ExpressionFunctionCall = (Above_Func | | |
Acos_Func | | |
AddMonths_Func | | |
AddYears_Func | | |
After_Func | | |
Age_Func | | |
Aggr_Func | | |
Alt_Func | | |
ApplyCodepage_Func | | |
ARGB_Func | | |
Asin_Func | | |
Atan_Func | | |
Atan2_Func | | |
Author_Func | | |
Avg_Func | | |
Before_Func | | |
Below_Func | | |
BitCount_Func | | |
Black_Func | | |
BlackAndSchole_Func | | |
Blue_Func | | |
Bottom_Func | | |
Brown_Func | | |
Capitalize_Func | | |
Ceil_Func | | |
Chi2Test_Chi2_Func | | |
Chi2Test_DF_Func | | |
Chi2Test_p_Func | | |
ChiDist_Func | | |
ChiInv_Func | | |
Chr_Func | | |
Class_Func | | |
ClientPlatform_Func | | |
Color_Func | | |
ColorMapHue_Func | | |
ColorMapJet_Func | | |
ColorMix1_Func | | |
ColorMix2_Func | | |
Column_Func | | |
ColumnNo_Func | | |
Combin_Func | | |
ComputerName_Func | | |
Concat_Func | | |
ConvertToLocalTime_Func | | |
Correl_Func | | |
Cos_Func | | |
Cosh_Func | | |
Count_Func | | |
Cyan_Func | | |
DarkGray_Func | | |
Date_Func | | |
Date#_Func | | |
Day_Func | | |
DayEnd_Func | | |
DaylightSaving_Func | | |
DayName_Func | | |
DayNumberOfQuarter_Func | | |
DayNumberOfYear_Func | | |
DayStart_Func | | |
Dimensionality_Func | | |
Div_Func | | |
DocumentName_Func | | |
DocumentPath_Func | | |
DocumentTitle_Func | | |
Dual_Func | | |
e_Func | | |
ElapsedSeconds_Func | | |
EngineVersion_Func | | |
Even_Func | | |
Exp_Func | | |
fAbs_Func | | |
Fact_Func | | |
False_Func | | |
FDist_Func | | |
FieldElemNo_Func | | |
FieldIndex_Func | | |
FieldValue_Func | | |
FieldValueCount_Func | | |
FindOneOf_Func | | |
FInv_Func | | |
First_Func | | |
FirstSortedValue_Func | | |
FirstWorkDate_Func | | |
Floor_Func | | |
fMod_Func | | |
FPSum_Func | | |
Frac_Func | | |
Fractile_Func | | |
FV_Func | | |
GeoAggrGeometry_Func | | |
GeoBoundingBox_Func | | |
GeoCountVertex_Func | | |
GeoGetBoundingBox_Func | | |
GeoGetPolygonCenter_Func | | |
GeoInvProjectGeometry_Func | | |
GeoMakePoint_Func | | |
GeoProject_Func | | |
GeoProjectGeometry_Func | | |
GeoReduceGeometry_Func | | |
GetAlternativeCount_Func | | |
GetCollationLocale_Func | | |
GetCurrentSelections_Func | | |
GetDataModelHash_Func | | |
GetExcludedCount_Func | | |
GetFieldSelections_Func | | |
GetNotSelectedCount_Func | | |
GetObjectDimension_Func | | |
GetObjectField_Func | | |
GetObjectMeasure_Func | | |
GetPossibleCount_Func | | |
GetSelectedCount_Func | | |
GMT_Func | | |
Green_Func | | |
Hash128_Func | | |
Hash160_Func | | |
Hash256_Func | | |
Hour_Func | | |
HRank_Func | | |
HSL_Func | | |
If_Func | | |
InDay_Func | | |
InDayToTime_Func | | |
Index_Func | | |
Info_Func | | |
InLunarWeek_Func | | |
InLunarWeekToDate_Func | | |
InMonth_Func | | |
InMonths_Func | | |
InMonthsToDate_Func | | |
InMonthToDate_Func | | |
InQuarter_Func | | |
InQuarterToDate_Func | | |
Interval_Func | | |
Interval#_Func | | |
InWeek_Func | | |
InWeekToDate_Func | | |
InYear_Func | | |
InYearToDate_Func | | |
Irr_Func | | |
IsNull_Func | | |
IsNum_Func | | |
IsText_Func | | |
KeepChar_Func | | |
Kurtosis_Func | | |
Last_Func | | |
LastWorkDate_Func | | |
Left_Func | | |
Len_Func | | |
LevenshteinDist_Func | | |
LightBlue_Func | | |
LightCyan_Func | | |
LightGray_Func | | |
LightGreen_Func | | |
LightMagenta_Func | | |
LightRed_Func | | |
LinEst_B_Func | | |
LinEst_DF_Func | | |
LinEst_F_Func | | |
LinEst_M_Func | | |
LinEst_R2_Func | | |
LinEst_SEB_Func | | |
LinEst_SEM_Func | | |
LinEst_SEY_Func | | |
LinEst_SSReg_Func | | |
LinEst_SSResid_Func | | |
LocalTime_Func | | |
Log_Func | | |
Log10_Func | | |
Lower_Func | | |
LTrim_Func | | |
LunarWeekEnd_Func | | |
LunarWeekName_Func | | |
LunarWeekStart_Func | | |
Magenta_Func | | |
MakeDate_Func | | |
MakeTime_Func | | |
MakeWeekDate_Func | | |
Match_Func | | |
Max_Func | | |
MaxString_Func | | |
Median_Func | | |
Mid_Func | | |
Min_Func | | |
MinString_Func | | |
Minute_Func | | |
MissingCount_Func | | |
MixMatch_Func | | |
Mod_Func | | |
Mode_Func | | |
Money_Func | | |
Money#_Func | | |
Month_Func | | |
MonthEnd_Func | | |
MonthName_Func | | |
MonthsEnd_Func | | |
MonthsName_Func | | |
MonthsStart_Func | | |
MonthStart_Func | | |
NATIVE_Func | | |
NetWorkDays_Func | | |
NoOfColumns_Func | | |
NoOfRows_Func | | |
NormDist_Func | | |
NormInv_Func | | |
Now_Func | | |
nPer_Func | | |
Npv_Func | | |
Null_Func | | |
NullCount_Func | | |
Num_Func | | |
Num#_Func | | |
NumAvg_Func | | |
NumCount_Func | | |
NumericCount_Func | | |
NumMax_Func | | |
NumMin_Func | | |
NumSum_Func | | |
Odd_Func | | |
Only_Func | | |
Ord_Func | | |
OSUser_Func | | |
Permut_Func | | |
Pi_Func | | |
Pick_Func | | |
Pmt_Func | | |
Pow_Func | | |
ProductVersion_Func | | |
PurgeChar_Func | | |
PV_Func | | |
QlikTechBlue_Func | | |
QlikTechGray_Func | | |
QlikViewVersion_Func | | |
QuarterEnd_Func | | |
QuarterName_Func | | |
QuarterStart_Func | | |
QVUser_Func | | |
Rand_Func | | |
RangeAvg_Func | | |
RangeCorrel_Func | | |
RangeCount_Func | | |
RangeFractile_Func | | |
RangeIrr_Func | | |
RangeKurtosis_Func | | |
RangeMax_Func | | |
RangeMaxString_Func | | |
RangeMin_Func | | |
RangeMinString_Func | | |
RangeMissingCount_Func | | |
RangeMode_Func | | |
RangeNpv_Func | | |
RangeNullCount_Func | | |
RangeNumericCount_Func | | |
RangeOnly_Func | | |
RangeSkew_Func | | |
RangeStDev_Func | | |
RangeSum_Func | | |
RangeTextCount_Func | | |
RangeXirr_Func | | |
RangeXnpv_Func | | |
Rank_Func | | |
Rate_Func | | |
Red_Func | | |
ReloadTime_Func | | |
Repeat_Func | | |
Replace_Func | | |
RGB_Func | | |
Right_Func | | |
Round_Func | | |
RowNo_Func | | |
RTrim_Func | | |
Second_Func | | |
SecondaryDimensionality_Func | | |
SetDateYear_Func | | |
SetDateYearMonth_Func | | |
Sign_Func | | |
Sin_Func | | |
Sinh_Func | | |
Skew_Func | | |
Sqr_Func | | |
Sqrt_Func | | |
StateName_Func | | |
StDev_Func | | |
StErr_Func | | |
StEYX_Func | | |
SubField_Func | | |
SubStringCount_Func | | |
Sum_Func | | |
SysColor_Func | | |
Tan_Func | | |
Tanh_Func | | |
TDist_Func | | |
Text_Func | | |
TextBetween_Func | | |
TextCount_Func | | |
Time_Func | | |
Time#_Func | | |
Timestamp_Func | | |
Timestamp#_Func | | |
TimeZone_Func | | |
TInv_Func | | |
Today_Func | | |
Top_Func | | |
Trim_Func | | |
True_Func | | |
TTest1_Conf_Func | | |
TTest1_DF_Func | | |
TTest1_Dif_Func | | |
TTest1_Lower_Func | | |
TTest1_Sig_Func | | |
TTest1_StErr_Func | | |
TTest1_t_Func | | |
TTest1_Upper_Func | | |
TTest1w_Conf_Func | | |
TTest1w_DF_Func | | |
TTest1w_Dif_Func | | |
TTest1w_Lower_Func | | |
TTest1w_Sig_Func | | |
TTest1w_StErr_Func | | |
TTest1w_t_Func | | |
TTest1w_Upper_Func | | |
TTest_Conf_Func | | |
TTest_DF_Func | | |
TTest_Dif_Func | | |
TTest_Lower_Func | | |
TTest_Sig_Func | | |
TTest_StErr_Func | | |
TTest_t_Func | | |
TTest_Upper_Func | | |
TTestw_Conf_Func | | |
TTestw_DF_Func | | |
TTestw_Dif_Func | | |
TTestw_Lower_Func | | |
TTestw_Sig_Func | | |
TTestw_StErr_Func | | |
TTestw_t_Func | | |
TTestw_Upper_Func | | |
Upper_Func | | |
UTC_Func | | |
ValueList_Func | | |
ValueLoop_Func | | |
VRank_Func | | |
Week_Func | | |
WeekDay_Func | | |
WeekEnd_Func | | |
WeekName_Func | | |
WeekStart_Func | | |
WeekYear_Func | | |
White_Func | | |
WildMatch_Func | | |
Xirr_Func | | |
Xnpv_Func | | |
Year_Func | | |
Year2Date_Func | | |
YearEnd_Func | | |
YearName_Func | | |
YearStart_Func | | |
YearToDate_Func | | |
Yellow_Func | | |
ZTest_Conf_Func | | |
ZTest_Dif_Func | | |
ZTest_Lower_Func | | |
ZTest_Sig_Func | | |
ZTest_StErr_Func | | |
ZTest_Upper_Func | | |
ZTest_z_Func | | |
ZTestw_Conf_Func | | |
ZTestw_Dif_Func | | |
ZTestw_Lower_Func | | |
ZTestw_Sig_Func | | |
ZTestw_StErr_Func | | |
ZTestw_Upper_Func | | |
ZTestw_z_Func | |
); | |
NATIVE_Func= ?RetType=dual? ?func? < ?FuncGroup=EXT? ?GroupList=EXT? ?helpid=45056? 'NATIVE' '(' > ?Name=statement? Expression ')'; | |
Pi_Func= ?RetType=num? ?func? < ?FuncGroup=MATH? ?GroupList=MATH? ?helpid=45058? 'Pi' '(' > ')'; | |
Null_Func= ?RetType=dual? ?func? < ?FuncGroup=MATH? ?GroupList=MATH,NULL? ?helpid=45060? 'Null' '(' > ')'; | |
e_Func= ?RetType=num? ?func? < ?FuncGroup=MATH? ?GroupList=MATH? ?helpid=45062? 'e' '(' > ')'; | |
True_Func= ?RetType=dual? ?func? < ?FuncGroup=MATH? ?GroupList=MATH,LOG? ?helpid=45064? 'True' '(' > ')'; | |
False_Func= ?RetType=dual? ?func? < ?FuncGroup=MATH? ?GroupList=MATH,LOG? ?helpid=45066? 'False' '(' > ')'; | |
DaylightSaving_Func= ?RetType=num? ?func? < ?FuncGroup=DATE? ?GroupList=DATE? ?helpid=45068? 'DaylightSaving' '(' > ')'; | |
TimeZone_Func= ?RetType=dual? ?func? < ?FuncGroup=DATE? ?GroupList=DATE? ?helpid=45070? 'TimeZone' '(' > ')'; | |
Rand_Func= ?RetType=num? ?func? < ?FuncGroup=PROB? ?GroupList=PROB? ?helpid=45072? 'Rand' '(' > ')'; | |
Pow_Func= ?RetType=num? ?func? < ?FuncGroup=EXP? ?GroupList=EXP? ?helpid=45074? 'Pow' '(' > ?Name=x? Expression ',' ?Name=y? Expression ')'; | |
Atan2_Func= ?RetType=num? ?func? < ?FuncGroup=TRIG? ?GroupList=TRIG? ?helpid=45076? 'Atan2' '(' > ?Name=y? Expression ',' ?Name=x? Expression ')'; | |
fMod_Func= ?RetType=num? ?func? < ?FuncGroup=NUM? ?GroupList=NUM? ?helpid=45078? 'fMod' '(' > ?Name=a? Expression ',' ?Name=b? Expression ')'; | |
Acos_Func= ?RetType=num? ?func? < ?FuncGroup=TRIG? ?GroupList=TRIG? ?helpid=45080? 'Acos' '(' > ?Name=x? Expression ')'; | |
Asin_Func= ?RetType=num? ?func? < ?FuncGroup=TRIG? ?GroupList=TRIG? ?helpid=45082? 'Asin' '(' > ?Name=x? Expression ')'; | |
Atan_Func= ?RetType=num? ?func? < ?FuncGroup=TRIG? ?GroupList=TRIG? ?helpid=45084? 'Atan' '(' > ?Name=x? Expression ')'; | |
Cos_Func= ?RetType=num? ?func? < ?FuncGroup=TRIG? ?GroupList=TRIG? ?helpid=45086? 'Cos' '(' > ?Name=x? Expression ')'; | |
Cosh_Func= ?RetType=num? ?func? < ?FuncGroup=TRIG? ?GroupList=TRIG? ?helpid=45088? 'Cosh' '(' > ?Name=x? Expression ')'; | |
Exp_Func= ?RetType=num? ?func? < ?FuncGroup=EXP? ?GroupList=EXP? ?helpid=45090? 'Exp' '(' > ?Name=x? Expression ')'; | |
fAbs_Func= ?RetType=num? ?func? < ?FuncGroup=NUM? ?GroupList=NUM? ?helpid=45092? 'fAbs' '(' > ?Name=x? Expression ')'; | |
Floor_Func= ?RetType=num? ?func? < ?FuncGroup=NUM? ?GroupList=NUM? ?helpid=45094? 'Floor' '(' > ?Name=x? Expression[ ',' ?Name=step? Expression[ ',' ?Name=offset? Expression]] ')'; | |
Ceil_Func= ?RetType=num? ?func? < ?FuncGroup=NUM? ?GroupList=NUM? ?helpid=45096? 'Ceil' '(' > ?Name=x? Expression[ ',' ?Name=step? Expression[ ',' ?Name=offset? Expression]] ')'; | |
Round_Func= ?RetType=num? ?func? < ?FuncGroup=NUM? ?GroupList=NUM? ?helpid=45098? 'Round' '(' > ?Name=x? Expression[ ',' ?Name=step? Expression[ ',' ?Name=offset? Expression]] ')'; | |
PV_Func= ?RetType=num? ?func? < ?FuncGroup=FIN? ?GroupList=FIN? ?helpid=45100? 'PV' '(' > ?Name=rate? Expression ',' ?Name=nper? Expression ',' ?Name=pmt? Expression[ ',' ?Name=fv? Expression[ ',' ?Name=type? Expression]] ')'; | |
FV_Func= ?RetType=num? ?func? < ?FuncGroup=FIN? ?GroupList=FIN? ?helpid=45102? 'FV' '(' > ?Name=rate? Expression ',' ?Name=nper? Expression ',' ?Name=pmt? Expression[ ',' ?Name=pv? Expression[ ',' ?Name=type? Expression]] ')'; | |
Pmt_Func= ?RetType=num? ?func? < ?FuncGroup=FIN? ?GroupList=FIN? ?helpid=45104? 'Pmt' '(' > ?Name=rate? Expression ',' ?Name=nper? Expression ',' ?Name=pv? Expression[ ',' ?Name=fv? Expression[ ',' ?Name=type? Expression]] ')'; | |
nPer_Func= ?RetType=num? ?func? < ?FuncGroup=FIN? ?GroupList=FIN? ?helpid=45106? 'nPer' '(' > ?Name=rate? Expression ',' ?Name=pmt? Expression ',' ?Name=pv? Expression[ ',' ?Name=fv? Expression[ ',' ?Name=type? Expression]] ')'; | |
Rate_Func= ?RetType=num? ?func? < ?FuncGroup=FIN? ?GroupList=FIN? ?helpid=45108? 'Rate' '(' > ?Name=nper? Expression ',' ?Name=pmt? Expression ',' ?Name=pv? Expression[ ',' ?Name=fv? Expression[ ',' ?Name=type? Expression]] ')'; | |
Log_Func= ?RetType=num? ?func? < ?FuncGroup=EXP? ?GroupList=EXP? ?helpid=45110? 'Log' '(' > ?Name=x? Expression ')'; | |
Log10_Func= ?RetType=num? ?func? < ?FuncGroup=EXP? ?GroupList=EXP? ?helpid=45112? 'Log10' '(' > ?Name=x? Expression ')'; | |
Sin_Func= ?RetType=num? ?func? < ?FuncGroup=TRIG? ?GroupList=TRIG? ?helpid=45114? 'Sin' '(' > ?Name=x? Expression ')'; | |
Sinh_Func= ?RetType=num? ?func? < ?FuncGroup=TRIG? ?GroupList=TRIG? ?helpid=45116? 'Sinh' '(' > ?Name=x? Expression ')'; | |
Sqrt_Func= ?RetType=num? ?func? < ?FuncGroup=EXP? ?GroupList=EXP? ?helpid=45118? 'Sqrt' '(' > ?Name=x? Expression ')'; | |
Sqr_Func= ?RetType=num? ?func? < ?FuncGroup=EXP? ?GroupList=EXP? ?helpid=45120? 'Sqr' '(' > ?Name=x? Expression ')'; | |
Tan_Func= ?RetType=num? ?func? < ?FuncGroup=TRIG? ?GroupList=TRIG? ?helpid=45122? 'Tan' '(' > ?Name=x? Expression ')'; | |
Tanh_Func= ?RetType=num? ?func? < ?FuncGroup=TRIG? ?GroupList=TRIG? ?helpid=45124? 'Tanh' '(' > ?Name=x? Expression ')'; | |
Sign_Func= ?RetType=num? ?func? < ?FuncGroup=NUM? ?GroupList=NUM? ?helpid=45126? 'Sign' '(' > ?Name=x? Expression ')'; | |
Fact_Func= ?RetType=num? ?func? < ?FuncGroup=NUM? ?GroupList=NUM? ?helpid=45128? 'Fact' '(' > ?Name=x? Expression ')'; | |
Permut_Func= ?RetType=int? ?func? < ?FuncGroup=PROB? ?GroupList=PROB? ?helpid=45130? 'Permut' '(' > ?Name=p? Expression ',' ?Name=q? Expression ')'; | |
Combin_Func= ?RetType=int? ?func? < ?FuncGroup=PROB? ?GroupList=PROB? ?helpid=45132? 'Combin' '(' > ?Name=p? Expression ',' ?Name=q? Expression ')'; | |
Black_Func= ?RetType=int? ?func? < ?FuncGroup=CLR? ?GroupList=CLR? ?helpid=45134? 'Black' '(' > [?Name=alpha? Expression] ')'; | |
Blue_Func= ?RetType=int? ?func? < ?FuncGroup=CLR? ?GroupList=CLR? ?helpid=45136? 'Blue' '(' > [?Name=alpha? Expression] ')'; | |
Green_Func= ?RetType=int? ?func? < ?FuncGroup=CLR? ?GroupList=CLR? ?helpid=45138? 'Green' '(' > [?Name=alpha? Expression] ')'; | |
Cyan_Func= ?RetType=int? ?func? < ?FuncGroup=CLR? ?GroupList=CLR? ?helpid=45140? 'Cyan' '(' > [?Name=alpha? Expression] ')'; | |
Red_Func= ?RetType=int? ?func? < ?FuncGroup=CLR? ?GroupList=CLR? ?helpid=45142? 'Red' '(' > [?Name=alpha? Expression] ')'; | |
Magenta_Func= ?RetType=int? ?func? < ?FuncGroup=CLR? ?GroupList=CLR? ?helpid=45144? 'Magenta' '(' > [?Name=alpha? Expression] ')'; | |
Brown_Func= ?RetType=int? ?func? < ?FuncGroup=CLR? ?GroupList=CLR? ?helpid=45146? 'Brown' '(' > [?Name=alpha? Expression] ')'; | |
LightGray_Func= ?RetType=int? ?func? < ?FuncGroup=CLR? ?GroupList=CLR? ?helpid=45148? 'LightGray' '(' > [?Name=alpha? Expression] ')'; | |
DarkGray_Func= ?RetType=int? ?func? < ?FuncGroup=CLR? ?GroupList=CLR? ?helpid=45150? 'DarkGray' '(' > [?Name=alpha? Expression] ')'; | |
LightBlue_Func= ?RetType=int? ?func? < ?FuncGroup=CLR? ?GroupList=CLR? ?helpid=45152? 'LightBlue' '(' > [?Name=alpha? Expression] ')'; | |
LightGreen_Func= ?RetType=int? ?func? < ?FuncGroup=CLR? ?GroupList=CLR? ?helpid=45154? 'LightGreen' '(' > [?Name=alpha? Expression] ')'; | |
LightCyan_Func= ?RetType=int? ?func? < ?FuncGroup=CLR? ?GroupList=CLR? ?helpid=45156? 'LightCyan' '(' > [?Name=alpha? Expression] ')'; | |
LightRed_Func= ?RetType=int? ?func? < ?FuncGroup=CLR? ?GroupList=CLR? ?helpid=45158? 'LightRed' '(' > [?Name=alpha? Expression] ')'; | |
LightMagenta_Func= ?RetType=int? ?func? < ?FuncGroup=CLR? ?GroupList=CLR? ?helpid=45160? 'LightMagenta' '(' > [?Name=alpha? Expression] ')'; | |
Yellow_Func= ?RetType=int? ?func? < ?FuncGroup=CLR? ?GroupList=CLR? ?helpid=45162? 'Yellow' '(' > [?Name=alpha? Expression] ')'; | |
White_Func= ?RetType=int? ?func? < ?FuncGroup=CLR? ?GroupList=CLR? ?helpid=45164? 'White' '(' > [?Name=alpha? Expression] ')'; | |
QlikTechBlue_Func= ?RetType=int? ?func? < ?FuncGroup=LEG? ?GroupList=LEG? ?helpid=45166? ?deprecated? 'QlikTechBlue' '(' > [?Name=alpha? Expression] ')'; | |
QlikTechGray_Func= ?RetType=int? ?func? < ?FuncGroup=LEG? ?GroupList=LEG? ?helpid=45168? ?deprecated? 'QlikTechGray' '(' > [?Name=alpha? Expression] ')'; | |
RangeNpv_Func= ?RetType=num? ?func? < ?FuncGroup=FIN? ?GroupList=FIN,RNG? ?helpid=45170? 'RangeNpv' '(' > ?Name=discount_rate? Expression ',' ?Name=value? Expression{',' Expression} ')'; | |
RangeIrr_Func= ?RetType=num? ?func? < ?FuncGroup=FIN? ?GroupList=FIN,RNG? ?helpid=45172? 'RangeIrr' '(' > ?Name=value? Expression ',' ?Name=value? Expression{',' Expression} ')'; | |
RangeXnpv_Func= ?RetType=num? ?func? < ?FuncGroup=FIN? ?GroupList=FIN,RNG? ?helpid=45174? 'RangeXnpv' '(' > ?Name=discount_rate? Expression ',' ?Name=values? Expression ',' ?Name=dates? Expression{',' Expression} ')'; | |
RangeXirr_Func= ?RetType=num? ?func? < ?FuncGroup=FIN? ?GroupList=FIN,RNG? ?helpid=45176? 'RangeXirr' '(' > ?Name=values? Expression ',' ?Name=dates? Expression{',' Expression} ')'; | |
BlackAndSchole_Func= ?RetType=num? ?func? < ?FuncGroup=FIN? ?GroupList=FIN? ?helpid=45178? 'BlackAndSchole' '(' > ?Name=strike? Expression ',' ?Name=time_left? Expression ',' ?Name=underlying? Expression ',' ?Name=vol? Expression ',' ?Name=risk_free_rate? Expression ',' ?Name=call_or_put? Expression ')'; | |
RangeCorrel_Func= ?RetType=num? ?func? < ?FuncGroup=RNG? ?GroupList=RNG? ?helpid=45180? 'RangeCorrel' '(' > ?Name=x_values? Expression ',' ?Name=y_values? Expression{',' Expression} ')'; | |
ChiDist_Func= ?RetType=num? ?func? < ?FuncGroup=PROB? ?GroupList=PROB? ?helpid=45182? 'ChiDist' '(' > ?Name=value? Expression ',' ?Name=degrees_freedom? Expression ')'; | |
ChiInv_Func= ?RetType=num? ?func? < ?FuncGroup=PROB? ?GroupList=PROB? ?helpid=45184? 'ChiInv' '(' > ?Name=prob? Expression ',' ?Name=degrees_freedom? Expression ')'; | |
NormDist_Func= ?RetType=num? ?func? < ?FuncGroup=PROB? ?GroupList=PROB? ?helpid=45186? 'NormDist' '(' > ?Name=value? Expression[ ',' ?Name=mean? Expression[ ',' ?Name=standard_dev? Expression[ ',' ?Name=cumulative? Expression]]] ')'; | |
NormInv_Func= ?RetType=num? ?func? < ?FuncGroup=PROB? ?GroupList=PROB? ?helpid=45188? 'NormInv' '(' > ?Name=prob? Expression ',' ?Name=mean? Expression ',' ?Name=standard_dev? Expression ')'; | |
TDist_Func= ?RetType=num? ?func? < ?FuncGroup=PROB? ?GroupList=PROB? ?helpid=45190? 'TDist' '(' > ?Name=value? Expression ',' ?Name=degrees_freedom? Expression ',' ?Name=tails? Expression ')'; | |
TInv_Func= ?RetType=num? ?func? < ?FuncGroup=PROB? ?GroupList=PROB? ?helpid=45192? 'TInv' '(' > ?Name=prob? Expression ',' ?Name=degrees_freedom? Expression ')'; | |
FDist_Func= ?RetType=num? ?func? < ?FuncGroup=PROB? ?GroupList=PROB? ?helpid=45194? 'FDist' '(' > ?Name=value? Expression ',' ?Name=degrees_freedom1? Expression ',' ?Name=degrees_freedom2? Expression ')'; | |
FInv_Func= ?RetType=num? ?func? < ?FuncGroup=PROB? ?GroupList=PROB? ?helpid=45196? 'FInv' '(' > ?Name=prob? Expression ',' ?Name=degrees_freedom1? Expression ',' ?Name=degrees_freedom2? Expression ')'; | |
GeoBoundingBox_Func= ?RetType=str? ?func? < ?FuncGroup=GEO? ?GroupList=GEO? ?helpid=45198? 'GeoBoundingBox' '(' > ?Name=field_name? Expression ')'; | |
GeoReduceGeometry_Func= ?RetType=str? ?func? < ?FuncGroup=GEO? ?GroupList=GEO? ?helpid=45200? 'GeoReduceGeometry' '(' > ?Name=field_name? Expression[ ',' ?Name=value? Expression] ')'; | |
GeoProjectGeometry_Func= ?RetType=str? ?func? < ?FuncGroup=GEO? ?GroupList=GEO? ?helpid=45202? 'GeoProjectGeometry' '(' > ?Name=type? Expression ',' ?Name=field_name? Expression ')'; | |
GeoInvProjectGeometry_Func= ?RetType=str? ?func? < ?FuncGroup=GEO? ?GroupList=GEO? ?helpid=45204? 'GeoInvProjectGeometry' '(' > ?Name=type? Expression ',' ?Name=field_name? Expression ')'; | |
GeoProject_Func= ?RetType=str? ?func? < ?FuncGroup=GEO? ?GroupList=GEO? ?helpid=45206? 'GeoProject' '(' > ?Name=type? Expression ',' ?Name=field_name? Expression ')'; | |
GeoGetBoundingBox_Func= ?RetType=str? ?func? < ?FuncGroup=GEO? ?GroupList=GEO? ?helpid=45208? 'GeoGetBoundingBox' '(' > ?Name=field_name? Expression ')'; | |
GeoGetPolygonCenter_Func= ?RetType=str? ?func? < ?FuncGroup=GEO? ?GroupList=GEO? ?helpid=45210? 'GeoGetPolygonCenter' '(' > ?Name=field_name? Expression ')'; | |
GeoMakePoint_Func= ?RetType=str? ?func? < ?FuncGroup=GEO? ?GroupList=GEO? ?helpid=45212? 'GeoMakePoint' '(' > ?Name=lat_field_name? Expression ',' ?Name=lon_field_name? Expression ')'; | |
GeoAggrGeometry_Func= ?RetType=str? ?func? < ?FuncGroup=GEO? ?GroupList=GEO? ?helpid=45214? 'GeoAggrGeometry' '(' > ?Name=field_name? Expression ')'; | |
GeoCountVertex_Func= ?RetType=int? ?func? < ?FuncGroup=GEO? ?GroupList=GEO? ?helpid=45216? 'GeoCountVertex' '(' > ?Name=field_name? Expression ')'; | |
TTest_t_Func= ?RetType=num? ?aggr? < ?FuncGroup=PROB? ?GroupList=PROB,AGGR? ?helpid=45218? 'TTest_t' '(' > [SetExpression]?Name=grp? Expression ',' ?Name=value? Expression[ ',' ?Name=eq_var? Expression] ')'; | |
TTestw_t_Func= ?RetType=num? ?aggr? < ?FuncGroup=PROB? ?GroupList=PROB,AGGR? ?helpid=45220? 'TTestw_t' '(' > [SetExpression]?Name=weight? Expression ',' ?Name=grp? Expression ',' ?Name=value? Expression[ ',' ?Name=eq_var? Expression] ')'; | |
TTest_DF_Func= ?RetType=num? ?aggr? < ?FuncGroup=PROB? ?GroupList=PROB,AGGR? ?helpid=45222? 'TTest_DF' '(' > [SetExpression]?Name=grp? Expression ',' ?Name=value? Expression[ ',' ?Name=eq_var? Expression] ')'; | |
TTestw_DF_Func= ?RetType=num? ?aggr? < ?FuncGroup=PROB? ?GroupList=PROB,AGGR? ?helpid=45224? 'TTestw_DF' '(' > [SetExpression]?Name=weight? Expression ',' ?Name=grp? Expression ',' ?Name=value? Expression[ ',' ?Name=eq_var? Expression] ')'; | |
TTest_Sig_Func= ?RetType=num? ?aggr? < ?FuncGroup=PROB? ?GroupList=PROB,AGGR? ?helpid=45226? 'TTest_Sig' '(' > [SetExpression]?Name=grp? Expression ',' ?Name=value? Expression[ ',' ?Name=eq_var? Expression] ')'; | |
TTestw_Sig_Func= ?RetType=num? ?aggr? < ?FuncGroup=PROB? ?GroupList=PROB,AGGR? ?helpid=45228? 'TTestw_Sig' '(' > [SetExpression]?Name=weight? Expression ',' ?Name=grp? Expression ',' ?Name=value? Expression[ ',' ?Name=eq_var? Expression] ')'; | |
TTest_Dif_Func= ?RetType=num? ?aggr? < ?FuncGroup=PROB? ?GroupList=PROB,AGGR? ?helpid=45230? 'TTest_Dif' '(' > [SetExpression]?Name=grp? Expression ',' ?Name=value? Expression ')'; | |
TTestw_Dif_Func= ?RetType=num? ?aggr? < ?FuncGroup=PROB? ?GroupList=PROB,AGGR? ?helpid=45232? 'TTestw_Dif' '(' > [SetExpression]?Name=weight? Expression ',' ?Name=grp? Expression ',' ?Name=value? Expression ')'; | |
TTest_StErr_Func= ?RetType=num? ?aggr? < ?FuncGroup=PROB? ?GroupList=PROB,AGGR? ?helpid=45234? 'TTest_StErr' '(' > [SetExpression]?Name=grp? Expression ',' ?Name=value? Expression[ ',' ?Name=eq_var? Expression] ')'; | |
TTestw_StErr_Func= ?RetType=num? ?aggr? < ?FuncGroup=PROB? ?GroupList=PROB,AGGR? ?helpid=45236? 'TTestw_StErr' '(' > [SetExpression]?Name=weight? Expression ',' ?Name=grp? Expression ',' ?Name=value? Expression[ ',' ?Name=eq_var? Expression] ')'; | |
TTest_Conf_Func= ?RetType=num? ?aggr? < ?FuncGroup=PROB? ?GroupList=PROB,AGGR? ?helpid=45238? 'TTest_Conf' '(' > [SetExpression]?Name=grp? Expression ',' ?Name=value? Expression[ ',' ?Name=sig? Expression[ ',' ?Name=eq_var? Expression]] ')'; | |
TTestw_Conf_Func= ?RetType=num? ?aggr? < ?FuncGroup=PROB? ?GroupList=PROB,AGGR? ?helpid=45240? 'TTestw_Conf' '(' > [SetExpression]?Name=weight? Expression ',' ?Name=grp? Expression ',' ?Name=value? Expression[ ',' ?Name=sig? Expression[ ',' ?Name=eq_var? Expression]] ')'; | |
TTest_Lower_Func= ?RetType=num? ?aggr? < ?FuncGroup=PROB? ?GroupList=PROB,AGGR? ?helpid=45242? 'TTest_Lower' '(' > [SetExpression]?Name=grp? Expression ',' ?Name=value? Expression[ ',' ?Name=sig? Expression[ ',' ?Name=eq_var? Expression]] ')'; | |
TTestw_Lower_Func= ?RetType=num? ?aggr? < ?FuncGroup=PROB? ?GroupList=PROB,AGGR? ?helpid=45244? 'TTestw_Lower' '(' > [SetExpression]?Name=weight? Expression ',' ?Name=grp? Expression ',' ?Name=value? Expression[ ',' ?Name=sig? Expression[ ',' ?Name=eq_var? Expression]] ')'; | |
TTest_Upper_Func= ?RetType=num? ?aggr? < ?FuncGroup=PROB? ?GroupList=PROB,AGGR? ?helpid=45246? 'TTest_Upper' '(' > [SetExpression]?Name=grp? Expression ',' ?Name=value? Expression[ ',' ?Name=sig? Expression[ ',' ?Name=eq_var? Expression]] ')'; | |
TTestw_Upper_Func= ?RetType=num? ?aggr? < ?FuncGroup=PROB? ?GroupList=PROB,AGGR? ?helpid=45248? 'TTestw_Upper' '(' > [SetExpression]?Name=weight? Expression ',' ?Name=grp? Expression ',' ?Name=value? Expression[ ',' ?Name=sig? Expression[ ',' ?Name=eq_var? Expression]] ')'; | |
TTest1_t_Func= ?RetType=num? ?aggr? < ?FuncGroup=PROB? ?GroupList=PROB,AGGR? ?helpid=45250? 'TTest1_t' '(' > [SetExpression]?Name=value? Expression ')'; | |
TTest1w_t_Func= ?RetType=num? ?aggr? < ?FuncGroup=PROB? ?GroupList=PROB,AGGR? ?helpid=45252? 'TTest1w_t' '(' > [SetExpression]?Name=weight? Expression ',' ?Name=value? Expression ')'; | |
TTest1_DF_Func= ?RetType=num? ?aggr? < ?FuncGroup=PROB? ?GroupList=PROB,AGGR? ?helpid=45254? 'TTest1_DF' '(' > [SetExpression]?Name=value? Expression ')'; | |
TTest1w_DF_Func= ?RetType=num? ?aggr? < ?FuncGroup=PROB? ?GroupList=PROB,AGGR? ?helpid=45256? 'TTest1w_DF' '(' > [SetExpression]?Name=weight? Expression ',' ?Name=value? Expression ')'; | |
TTest1_Sig_Func= ?RetType=num? ?aggr? < ?FuncGroup=PROB? ?GroupList=PROB,AGGR? ?helpid=45258? 'TTest1_Sig' '(' > [SetExpression]?Name=value? Expression ')'; | |
TTest1w_Sig_Func= ?RetType=num? ?aggr? < ?FuncGroup=PROB? ?GroupList=PROB,AGGR? ?helpid=45260? 'TTest1w_Sig' '(' > [SetExpression]?Name=weight? Expression ',' ?Name=value? Expression ')'; | |
TTest1_Dif_Func= ?RetType=num? ?aggr? < ?FuncGroup=PROB? ?GroupList=PROB,AGGR? ?helpid=45262? 'TTest1_Dif' '(' > [SetExpression]?Name=value? Expression ')'; | |
TTest1w_Dif_Func= ?RetType=num? ?aggr? < ?FuncGroup=PROB? ?GroupList=PROB,AGGR? ?helpid=45264? 'TTest1w_Dif' '(' > [SetExpression]?Name=weight? Expression ',' ?Name=value? Expression ')'; | |
TTest1_StErr_Func= ?RetType=num? ?aggr? < ?FuncGroup=PROB? ?GroupList=PROB,AGGR? ?helpid=45266? 'TTest1_StErr' '(' > [SetExpression]?Name=value? Expression ')'; | |
TTest1w_StErr_Func= ?RetType=num? ?aggr? < ?FuncGroup=PROB? ?GroupList=PROB,AGGR? ?helpid=45268? 'TTest1w_StErr' '(' > [SetExpression]?Name=weight? Expression ',' ?Name=value? Expression ')'; | |
TTest1_Conf_Func= ?RetType=num? ?aggr? < ?FuncGroup=PROB? ?GroupList=PROB,AGGR? ?helpid=45270? 'TTest1_Conf' '(' > [SetExpression]?Name=value? Expression[ ',' ?Name=sig? Expression] ')'; | |
TTest1w_Conf_Func= ?RetType=num? ?aggr? < ?FuncGroup=PROB? ?GroupList=PROB,AGGR? ?helpid=45272? 'TTest1w_Conf' '(' > [SetExpression]?Name=weight? Expression ',' ?Name=value? Expression[ ',' ?Name=sig? Expression] ')'; | |
TTest1_Lower_Func= ?RetType=num? ?aggr? < ?FuncGroup=PROB? ?GroupList=PROB,AGGR? ?helpid=45274? 'TTest1_Lower' '(' > [SetExpression]?Name=value? Expression[ ',' ?Name=sig? Expression] ')'; | |
TTest1w_Lower_Func= ?RetType=num? ?aggr? < ?FuncGroup=PROB? ?GroupList=PROB,AGGR? ?helpid=45276? 'TTest1w_Lower' '(' > [SetExpression]?Name=weight? Expression ',' ?Name=value? Expression[ ',' ?Name=sig? Expression] ')'; | |
TTest1_Upper_Func= ?RetType=num? ?aggr? < ?FuncGroup=PROB? ?GroupList=PROB,AGGR? ?helpid=45278? 'TTest1_Upper' '(' > [SetExpression]?Name=value? Expression[ ',' ?Name=sig? Expression] ')'; | |
TTest1w_Upper_Func= ?RetType=num? ?aggr? < ?FuncGroup=PROB? ?GroupList=PROB,AGGR? ?helpid=45280? 'TTest1w_Upper' '(' > [SetExpression]?Name=weight? Expression ',' ?Name=value? Expression[ ',' ?Name=sig? Expression] ')'; | |
ZTest_z_Func= ?RetType=num? ?aggr? < ?FuncGroup=PROB? ?GroupList=PROB,AGGR? ?helpid=45282? 'ZTest_z' '(' > [SetExpression]?Name=value? Expression[ ',' ?Name=sigma? Expression] ')'; | |
ZTestw_z_Func= ?RetType=num? ?aggr? < ?FuncGroup=PROB? ?GroupList=PROB,AGGR? ?helpid=45284? 'ZTestw_z' '(' > [SetExpression]?Name=weight? Expression ',' ?Name=value? Expression[ ',' ?Name=sigma? Expression] ')'; | |
ZTest_Sig_Func= ?RetType=num? ?aggr? < ?FuncGroup=PROB? ?GroupList=PROB,AGGR? ?helpid=45286? 'ZTest_Sig' '(' > [SetExpression]?Name=value? Expression[ ',' ?Name=sigma? Expression] ')'; | |
ZTestw_Sig_Func= ?RetType=num? ?aggr? < ?FuncGroup=PROB? ?GroupList=PROB,AGGR? ?helpid=45288? 'ZTestw_Sig' '(' > [SetExpression]?Name=weight? Expression ',' ?Name=value? Expression[ ',' ?Name=sigma? Expression] ')'; | |
ZTest_Dif_Func= ?RetType=num? ?aggr? < ?FuncGroup=PROB? ?GroupList=PROB,AGGR? ?helpid=45290? 'ZTest_Dif' '(' > [SetExpression]?Name=value? Expression[ ',' ?Name=sigma? Expression] ')'; | |
ZTestw_Dif_Func= ?RetType=num? ?aggr? < ?FuncGroup=PROB? ?GroupList=PROB,AGGR? ?helpid=45292? 'ZTestw_Dif' '(' > [SetExpression]?Name=weight? Expression ',' ?Name=value? Expression[ ',' ?Name=sigma? Expression] ')'; | |
ZTest_StErr_Func= ?RetType=num? ?aggr? < ?FuncGroup=PROB? ?GroupList=PROB,AGGR? ?helpid=45294? 'ZTest_StErr' '(' > [SetExpression]?Name=value? Expression[ ',' ?Name=sigma? Expression] ')'; | |
ZTestw_StErr_Func= ?RetType=num? ?aggr? < ?FuncGroup=PROB? ?GroupList=PROB,AGGR? ?helpid=45296? 'ZTestw_StErr' '(' > [SetExpression]?Name=weight? Expression ',' ?Name=value? Expression[ ',' ?Name=sigma? Expression] ')'; | |
ZTest_Conf_Func= ?RetType=num? ?aggr? < ?FuncGroup=PROB? ?GroupList=PROB,AGGR? ?helpid=45298? 'ZTest_Conf' '(' > [SetExpression]?Name=value? Expression[ ',' ?Name=sigma? Expression[ ',' ?Name=sig? Expression]] ')'; | |
ZTestw_Conf_Func= ?RetType=num? ?aggr? < ?FuncGroup=PROB? ?GroupList=PROB,AGGR? ?helpid=45300? 'ZTestw_Conf' '(' > [SetExpression]?Name=weight? Expression ',' ?Name=value? Expression[ ',' ?Name=sigma? Expression[ ',' ?Name=sig? Expression]] ')'; | |
ZTest_Lower_Func= ?RetType=num? ?aggr? < ?FuncGroup=PROB? ?GroupList=PROB,AGGR? ?helpid=45302? 'ZTest_Lower' '(' > [SetExpression]?Name=value? Expression[ ',' ?Name=sigma? Expression[ ',' ?Name=sig? Expression]] ')'; | |
ZTestw_Lower_Func= ?RetType=num? ?aggr? < ?FuncGroup=PROB? ?GroupList=PROB,AGGR? ?helpid=45304? 'ZTestw_Lower' '(' > [SetExpression]?Name=weight? Expression ',' ?Name=value? Expression[ ',' ?Name=sigma? Expression[ ',' ?Name=sig? Expression]] ')'; | |
ZTest_Upper_Func= ?RetType=num? ?aggr? < ?FuncGroup=PROB? ?GroupList=PROB,AGGR? ?helpid=45306? 'ZTest_Upper' '(' > [SetExpression]?Name=value? Expression[ ',' ?Name=sigma? Expression[ ',' ?Name=sig? Expression]] ')'; | |
ZTestw_Upper_Func= ?RetType=num? ?aggr? < ?FuncGroup=PROB? ?GroupList=PROB,AGGR? ?helpid=45308? 'ZTestw_Upper' '(' > [SetExpression]?Name=weight? Expression ',' ?Name=value? Expression[ ',' ?Name=sigma? Expression[ ',' ?Name=sig? Expression]] ')'; | |
Chi2Test_p_Func= ?RetType=num? ?aggr? < ?FuncGroup=PROB? ?GroupList=PROB,AGGR? ?helpid=45310? 'Chi2Test_p' '(' > [SetExpression]?Name=col? Expression ',' ?Name=row? Expression ',' ?Name=actual_value? Expression[ ',' ?Name=expected_value? Expression] ')'; | |
Chi2Test_DF_Func= ?RetType=num? ?aggr? < ?FuncGroup=PROB? ?GroupList=PROB,AGGR? ?helpid=45312? 'Chi2Test_DF' '(' > [SetExpression]?Name=col? Expression ',' ?Name=row? Expression ',' ?Name=actual_value? Expression[ ',' ?Name=expected_value? Expression] ')'; | |
Chi2Test_Chi2_Func= ?RetType=num? ?aggr? < ?FuncGroup=PROB? ?GroupList=PROB,AGGR? ?helpid=45314? 'Chi2Test_Chi2' '(' > [SetExpression]?Name=col? Expression ',' ?Name=row? Expression ',' ?Name=actual_value? Expression[ ',' ?Name=expected_value? Expression] ')'; | |
If_Func= ?RetType=dual? ?func? < ?FuncGroup=CND? ?GroupList=CND? ?helpid=45316? 'If' '(' > ?Name=condition? Expression ',' ?Name=then_expr? Expression[ ',' ?Name=else_expr? Expression] ')'; | |
Pick_Func= ?RetType=dual? ?func? < ?FuncGroup=CND? ?GroupList=CND? ?helpid=45318? 'Pick' '(' > ?Name=position? Expression{',' Expression} ')'; | |
Match_Func= ?RetType=int? ?func? < ?FuncGroup=CND? ?GroupList=CND? ?helpid=45320? 'Match' '(' > ?Name=text? Expression ',' ?Name=mask_expr1? Expression{',' Expression} ')'; | |
MixMatch_Func= ?RetType=int? ?func? < ?FuncGroup=CND? ?GroupList=CND? ?helpid=45322? 'MixMatch' '(' > ?Name=text? Expression ',' ?Name=mask_expr1? Expression{',' Expression} ')'; | |
WildMatch_Func= ?RetType=int? ?func? < ?FuncGroup=CND? ?GroupList=CND? ?helpid=45324? 'WildMatch' '(' > ?Name=text? Expression ',' ?Name=mask_expr1? Expression{',' Expression} ')'; | |
Alt_Func= ?RetType=dual? ?func? < ?FuncGroup=CND? ?GroupList=CND? ?helpid=45326? 'Alt' '(' > ?Name=expr1? Expression{',' Expression} ')'; | |
Trim_Func= ?RetType=str? ?func? < ?FuncGroup=STR? ?GroupList=STR? ?helpid=45328? 'Trim' '(' > ?Name=text? Expression ')'; | |
LTrim_Func= ?RetType=str? ?func? < ?FuncGroup=STR? ?GroupList=STR? ?helpid=45330? 'LTrim' '(' > ?Name=text? Expression ')'; | |
RTrim_Func= ?RetType=str? ?func? < ?FuncGroup=STR? ?GroupList=STR? ?helpid=45332? 'RTrim' '(' > ?Name=text? Expression ')'; | |
PurgeChar_Func= ?RetType=str? ?func? < ?FuncGroup=STR? ?GroupList=STR? ?helpid=45334? 'PurgeChar' '(' > ?Name=text? Expression ',' ?Name=remove_chars? Expression ')'; | |
LevenshteinDist_Func= ?RetType=int? ?func? < ?FuncGroup=STR? ?GroupList=STR? ?helpid=45336? 'LevenshteinDist' '(' > ?Name=text1? Expression ',' ?Name=text2? Expression ')'; | |
KeepChar_Func= ?RetType=str? ?func? < ?FuncGroup=STR? ?GroupList=STR? ?helpid=45338? 'KeepChar' '(' > ?Name=text? Expression ',' ?Name=keep_chars? Expression ')'; | |
Left_Func= ?RetType=str? ?func? < ?FuncGroup=STR? ?GroupList=STR? ?helpid=45340? 'Left' '(' > ?Name=text? Expression ',' ?Name=count? Expression ')'; | |
Right_Func= ?RetType=str? ?func? < ?FuncGroup=STR? ?GroupList=STR? ?helpid=45342? 'Right' '(' > ?Name=text? Expression ',' ?Name=count? Expression ')'; | |
Mid_Func= ?RetType=str? ?func? < ?FuncGroup=STR? ?GroupList=STR? ?helpid=45344? 'Mid' '(' > ?Name=text? Expression ',' ?Name=start? Expression[ ',' ?Name=count? Expression] ')'; | |
SubField_Func= ?RetType=str? ?func? < ?FuncGroup=STR? ?GroupList=STR? ?helpid=45346? 'SubField' '(' > ?Name=text? Expression ',' ?Name=delimiter? Expression[ ',' ?Name=field_no? Expression] ')'; | |
TextBetween_Func= ?RetType=str? ?func? < ?FuncGroup=STR? ?GroupList=STR? ?helpid=45348? 'TextBetween' '(' > ?Name=text? Expression ',' ?Name=delimiter1? Expression ',' ?Name=delimiter2? Expression[ ',' ?Name=count? Expression] ')'; | |
Repeat_Func= ?RetType=str? ?func? < ?FuncGroup=STR? ?GroupList=STR? ?helpid=45350? 'Repeat' '(' > ?Name=text? Expression ',' ?Name=repeat_count? Expression ')'; | |
Chr_Func= ?RetType=str? ?func? < ?FuncGroup=STR? ?GroupList=STR? ?helpid=45352? 'Chr' '(' > ?Name=int? Expression ')'; | |
Class_Func= ?RetType=str? ?func? < ?FuncGroup=CND? ?GroupList=CND? ?helpid=45354? 'Class' '(' > ?Name=x? Expression ',' ?Name=class_width? Expression[ ',' ?Name=formal? Expression[ ',' ?Name=bias? Expression]] ')'; | |
Index_Func= ?RetType=int? ?func? < ?FuncGroup=STR? ?GroupList=STR? ?helpid=45356? 'Index' '(' > ?Name=text? Expression ',' ?Name=substring? Expression[ ',' ?Name=count? Expression] ')'; | |
FindOneOf_Func= ?RetType=int? ?func? < ?FuncGroup=STR? ?GroupList=STR? ?helpid=45358? 'FindOneOf' '(' > ?Name=text? Expression ',' ?Name=char_set? Expression[ ',' ?Name=count? Expression] ')'; | |
Len_Func= ?RetType=int? ?func? < ?FuncGroup=STR? ?GroupList=STR? ?helpid=45360? 'Len' '(' > ?Name=text? Expression ')'; | |
Mod_Func= ?RetType=int? ?func? < ?FuncGroup=NUM? ?GroupList=NUM? ?helpid=45362? 'Mod' '(' > ?Name=integer_number1? Expression ',' ?Name=integer_number2? Expression ')'; | |
Odd_Func= ?RetType=bool? ?func? < ?FuncGroup=NUM? ?GroupList=NUM? ?helpid=45364? 'Odd' '(' > ?Name=integer_number? Expression ')'; | |
Even_Func= ?RetType=bool? ?func? < ?FuncGroup=NUM? ?GroupList=NUM? ?helpid=45366? 'Even' '(' > ?Name=integer_number? Expression ')'; | |
UTC_Func= ?RetType=num? ?func? < ?FuncGroup=DATE? ?GroupList=DATE? ?helpid=45368? 'UTC' '(' > [?Name=realtime? Expression] ')'; | |
GMT_Func= ?RetType=num? ?func? < ?FuncGroup=DATE? ?GroupList=DATE? ?helpid=45370? 'GMT' '(' > [?Name=realtime? Expression] ')'; | |
Now_Func= ?RetType=num? ?func? < ?FuncGroup=DATE? ?GroupList=DATE? ?helpid=45372? 'Now' '(' > [?Name=timer_mode? Expression] ')'; | |
Today_Func= ?RetType=num? ?func? < ?FuncGroup=DATE? ?GroupList=DATE? ?helpid=45374? 'Today' '(' > [?Name=timer_mode? Expression] ')'; | |
ElapsedSeconds_Func= ?RetType=num? ?func? < ?FuncGroup=DATE? ?GroupList=DATE? ?helpid=45376? 'ElapsedSeconds' '(' > ')'; | |
Hour_Func= ?RetType=int? ?func? < ?FuncGroup=DATE? ?GroupList=DATE? ?helpid=45378? 'Hour' '(' > ?Name=timestamp? Expression ')'; | |
Minute_Func= ?RetType=int? ?func? < ?FuncGroup=DATE? ?GroupList=DATE? ?helpid=45380? 'Minute' '(' > ?Name=timestamp? Expression ')'; | |
Second_Func= ?RetType=int? ?func? < ?FuncGroup=DATE? ?GroupList=DATE? ?helpid=45382? 'Second' '(' > ?Name=timestamp? Expression ')'; | |
Frac_Func= ?RetType=num? ?func? < ?FuncGroup=NUM? ?GroupList=NUM? ?helpid=45384? 'Frac' '(' > ?Name=timestamp? Expression ')'; | |
Div_Func= ?RetType=int? ?func? < ?FuncGroup=NUM? ?GroupList=NUM? ?helpid=45386? 'Div' '(' > ?Name=integer_number1? Expression ',' ?Name=integer_number2? Expression ')'; | |
Dual_Func= ?RetType=dual? ?func? < ?FuncGroup=NUMI? ?GroupList=NUMI? ?helpid=45388? 'Dual' '(' > ?Name=text? Expression ',' ?Name=number? Expression ')'; | |
BitCount_Func= ?RetType=int? ?func? < ?FuncGroup=NUM? ?GroupList=NUM? ?helpid=45390? 'BitCount' '(' > ?Name=integer_number? Expression ')'; | |
Ord_Func= ?RetType=int? ?func? < ?FuncGroup=STR? ?GroupList=STR? ?helpid=45392? 'Ord' '(' > ?Name=char? Expression ')'; | |
Upper_Func= ?RetType=str? ?func? < ?FuncGroup=STR? ?GroupList=STR? ?helpid=45394? 'Upper' '(' > ?Name=text? Expression ')'; | |
ApplyCodepage_Func= ?RetType=str? ?func? < ?FuncGroup=STR? ?GroupList=STR? ?helpid=45396? 'ApplyCodepage' '(' > ?Name=text? Expression ',' ?Name=codepage? Expression ')'; | |
Lower_Func= ?RetType=str? ?func? < ?FuncGroup=STR? ?GroupList=STR? ?helpid=45398? 'Lower' '(' > ?Name=text? Expression ')'; | |
Capitalize_Func= ?RetType=str? ?func? < ?FuncGroup=STR? ?GroupList=STR? ?helpid=45400? 'Capitalize' '(' > ?Name=text? Expression ')'; | |
RGB_Func= ?RetType=int? ?func? < ?FuncGroup=CLR? ?GroupList=CLR? ?helpid=45402? 'RGB' '(' > ?Name=r_value? Expression ',' ?Name=g_value? Expression ',' ?Name=b_value? Expression ')'; | |
ARGB_Func= ?RetType=int? ?func? < ?FuncGroup=CLR? ?GroupList=CLR? ?helpid=45404? 'ARGB' '(' > ?Name=alpha_value? Expression ',' ?Name=r_value? Expression ',' ?Name=g_value? Expression ',' ?Name=b_value? Expression ')'; | |
HSL_Func= ?RetType=int? ?func? < ?FuncGroup=CLR? ?GroupList=CLR? ?helpid=45406? 'HSL' '(' > ?Name=hue? Expression ',' ?Name=saturation? Expression ',' ?Name=luminosity? Expression ')'; | |
Color_Func= ?RetType=int? ?func? < ?FuncGroup=CLR? ?GroupList=CLR? ?helpid=45408? 'Color' '(' > ?Name=palette_index? Expression ')'; | |
SysColor_Func= ?RetType=int? ?func? < ?FuncGroup=CLR? ?GroupList=CLR? ?helpid=45410? ?deprecated? 'SysColor' '(' > ?Name=sys_index? Expression ')'; | |
ColorMix1_Func= ?RetType=int? ?func? < ?FuncGroup=CLR? ?GroupList=CLR? ?helpid=45412? 'ColorMix1' '(' > ?Name=ValueBetweenZeroAndOne? Expression ',' ?Name=ColorZero? Expression ',' ?Name=ColorOne? Expression ')'; | |
ColorMix2_Func= ?RetType=int? ?func? < ?FuncGroup=CLR? ?GroupList=CLR? ?helpid=45414? 'ColorMix2' '(' > ?Name=ValueBetweenMinusOneAndOne? Expression ',' ?Name=ColorMinusOne? Expression ',' ?Name=ColorOne? Expression[ ',' ?Name=ColorZero? Expression] ')'; | |
ColorMapJet_Func= ?RetType=int? ?func? < ?FuncGroup=CLR? ?GroupList=CLR? ?helpid=45416? 'ColorMapJet' '(' > ?Name=ValueBetweenZeroAndOne? Expression ')'; | |
ColorMapHue_Func= ?RetType=int? ?func? < ?FuncGroup=CLR? ?GroupList=CLR? ?helpid=45418? 'ColorMapHue' '(' > ?Name=ValueBetweenZeroAndOne? Expression ')'; | |
IsNull_Func= ?RetType=bool? ?func? < ?FuncGroup=NULL? ?GroupList=NULL,LOG? ?helpid=45420? 'IsNull' '(' > ?Name=expr? Expression ')'; | |
IsNum_Func= ?RetType=bool? ?func? < ?FuncGroup=LOG? ?GroupList=LOG? ?helpid=45422? 'IsNum' '(' > ?Name=expr? Expression ')'; | |
IsText_Func= ?RetType=bool? ?func? < ?FuncGroup=LOG? ?GroupList=LOG? ?helpid=45424? 'IsText' '(' > ?Name=expr? Expression ')'; | |
RowNo_Func= ?RetType=int? ?func? < ?FuncGroup=RCRD? ?GroupList=RCRD? ?helpid=45432? 'RowNo' '(' > ['TOTAL'] ')'; | |
NoOfRows_Func= ?RetType=int? ?func? < ?FuncGroup=TBL? ?GroupList=TBL? ?helpid=45433? 'NoOfRows' '(' > ['TOTAL'] ')'; | |
ColumnNo_Func= ?RetType=int? ?func? < ?FuncGroup=RCRD? ?GroupList=RCRD? ?helpid=45434? 'ColumnNo' '(' > ['TOTAL'] ')'; | |
NoOfColumns_Func= ?RetType=int? ?func? < ?FuncGroup=TBL? ?GroupList=TBL? ?helpid=45435? 'NoOfColumns' '(' > ['TOTAL'] ')'; | |
Column_Func= ?RetType=dual? ?func? < ?FuncGroup=TBL? ?GroupList=TBL? ?helpid=45436? 'Column' '(' > ?Name=ColumnNo? Expression ')'; | |
Dimensionality_Func= ?RetType=int? ?func? < ?FuncGroup=RCRD? ?GroupList=RCRD? ?helpid=45437? 'Dimensionality' '(' > ')'; | |
SecondaryDimensionality_Func= ?RetType=int? ?func? < ?FuncGroup=RCRD? ?GroupList=RCRD? ?helpid=45438? 'SecondaryDimensionality' '(' > ')'; | |
Timestamp_Func= ?RetType=dual? ?func? < ?FuncGroup=NUMI? ?GroupList=NUMI? ?helpid=45440? 'Timestamp' '(' > ?Name=number? Expression[ ',' ?Name=format? Expression] ')'; | |
Date_Func= ?RetType=dual? ?func? < ?FuncGroup=NUMI? ?GroupList=NUMI? ?helpid=45442? 'Date' '(' > ?Name=number? Expression[ ',' ?Name=format? Expression] ')'; | |
Time_Func= ?RetType=dual? ?func? < ?FuncGroup=NUMI? ?GroupList=NUMI? ?helpid=45444? 'Time' '(' > ?Name=number? Expression[ ',' ?Name=format? Expression] ')'; | |
Interval_Func= ?RetType=dual? ?func? < ?FuncGroup=NUMI? ?GroupList=NUMI? ?helpid=45446? 'Interval' '(' > ?Name=number? Expression[ ',' ?Name=format? Expression] ')'; | |
Num_Func= ?RetType=dual? ?func? < ?FuncGroup=NUMI? ?GroupList=NUMI? ?helpid=45448? 'Num' '(' > ?Name=number? Expression[ ',' ?Name=format? Expression[ ',' ?Name=dec_sep? Expression[ ',' ?Name=thou_sep? Expression]]] ')'; | |
Money_Func= ?RetType=dual? ?func? < ?FuncGroup=NUMI? ?GroupList=NUMI? ?helpid=45450? 'Money' '(' > ?Name=number? Expression[ ',' ?Name=format? Expression[ ',' ?Name=dec_sep? Expression[ ',' ?Name=thou_sep? Expression]]] ')'; | |
Text_Func= ?RetType=dual? ?func? < ?FuncGroup=NUMI? ?GroupList=NUMI? ?helpid=45452? 'Text' '(' > ?Name=expr? Expression ')'; | |
Timestamp#_Func= ?RetType=dual? ?func? < ?FuncGroup=NUMI? ?GroupList=NUMI? ?helpid=45454? 'Timestamp#' '(' > ?Name=text? Expression[ ',' ?Name=format? Expression] ')'; | |
Date#_Func= ?RetType=dual? ?func? < ?FuncGroup=NUMI? ?GroupList=NUMI? ?helpid=45456? 'Date#' '(' > ?Name=text? Expression[ ',' ?Name=format? Expression] ')'; | |
Time#_Func= ?RetType=dual? ?func? < ?FuncGroup=NUMI? ?GroupList=NUMI? ?helpid=45458? 'Time#' '(' > ?Name=text? Expression[ ',' ?Name=format? Expression] ')'; | |
Interval#_Func= ?RetType=dual? ?func? < ?FuncGroup=NUMI? ?GroupList=NUMI? ?helpid=45460? 'Interval#' '(' > ?Name=text? Expression[ ',' ?Name=format? Expression] ')'; | |
Num#_Func= ?RetType=dual? ?func? < ?FuncGroup=NUMI? ?GroupList=NUMI? ?helpid=45462? 'Num#' '(' > ?Name=text? Expression[ ',' ?Name=format? Expression[ ',' ?Name=dec_sep? Expression[ ',' ?Name=thou_sep? Expression]]] ')'; | |
Money#_Func= ?RetType=dual? ?func? < ?FuncGroup=NUMI? ?GroupList=NUMI? ?helpid=45464? 'Money#' '(' > ?Name=text? Expression[ ',' ?Name=format? Expression[ ',' ?Name=dec_sep? Expression[ ',' ?Name=thou_sep? Expression]]] ')'; | |
Month_Func= ?RetType=int? ?func? < ?FuncGroup=DATE? ?GroupList=DATE? ?helpid=45466? 'Month' '(' > ?Name=timestamp? Expression ')'; | |
Day_Func= ?RetType=int? ?func? < ?FuncGroup=DATE? ?GroupList=DATE? ?helpid=45468? 'Day' '(' > ?Name=timestamp? Expression ')'; | |
Week_Func= ?RetType=int? ?func? < ?FuncGroup=DATE? ?GroupList=DATE? ?helpid=45470? 'Week' '(' > ?Name=timestamp? Expression[ ',' ?Name=first_week_day? Expression[ ',' ?Name=broken_weeks? Expression[ ',' ?Name=reference_day? Expression]]] ')'; | |
WeekDay_Func= ?RetType=int? ?func? < ?FuncGroup=DATE? ?GroupList=DATE? ?helpid=45472? 'WeekDay' '(' > ?Name=timestamp? Expression[ ',' ?Name=first_week_day? Expression] ')'; | |
WeekYear_Func= ?RetType=int? ?func? < ?FuncGroup=DATE? ?GroupList=DATE? ?helpid=45474? 'WeekYear' '(' > ?Name=timestamp? Expression ')'; | |
Year_Func= ?RetType=int? ?func? < ?FuncGroup=DATE? ?GroupList=DATE? ?helpid=45476? 'Year' '(' > ?Name=timestamp? Expression ')'; | |
Age_Func= ?RetType=int? ?func? < ?FuncGroup=DATE? ?GroupList=DATE? ?helpid=45478? 'Age' '(' > ?Name=timestamp? Expression ',' ?Name=date_of_birth? Expression ')'; | |
NetWorkDays_Func= ?RetType=int? ?func? < ?FuncGroup=DATE? ?GroupList=DATE? ?helpid=45480? 'NetWorkDays' '(' > ?Name=start_date? Expression ',' ?Name=end_date? Expression[ ',' ?Name=holiday? Expression{',' Expression}] ')'; | |
LastWorkDate_Func= ?RetType=int? ?func? < ?FuncGroup=DATE? ?GroupList=DATE? ?helpid=45482? 'LastWorkDate' '(' > ?Name=start_date? Expression ',' ?Name=no_of_workdays? Expression[ ',' ?Name=holiday? Expression{',' Expression}] ')'; | |
FirstWorkDate_Func= ?RetType=int? ?func? < ?FuncGroup=DATE? ?GroupList=DATE? ?helpid=45484? 'FirstWorkDate' '(' > ?Name=end_date? Expression ',' ?Name=no_of_workdays? Expression[ ',' ?Name=holiday? Expression{',' Expression}] ')'; | |
MakeDate_Func= ?RetType=dual? ?func? < ?FuncGroup=DATE? ?GroupList=DATE? ?helpid=45486? 'MakeDate' '(' > ?Name=year_number? Expression[ ',' ?Name=month_number? Expression[ ',' ?Name=day_number? Expression]] ')'; | |
MakeWeekDate_Func= ?RetType=dual? ?func? < ?FuncGroup=DATE? ?GroupList=DATE? ?helpid=45488? 'MakeWeekDate' '(' > ?Name=weekyear_number? Expression ',' ?Name=week_number? Expression[ ',' ?Name=weekday_number? Expression] ')'; | |
AddMonths_Func= ?RetType=dual? ?func? < ?FuncGroup=DATE? ?GroupList=DATE? ?helpid=45490? 'AddMonths' '(' > ?Name=date? Expression ',' ?Name=no_of_months? Expression[ ',' ?Name=mode? Expression] ')'; | |
AddYears_Func= ?RetType=dual? ?func? < ?FuncGroup=DATE? ?GroupList=DATE? ?helpid=45492? 'AddYears' '(' > ?Name=date? Expression ',' ?Name=no_of_years? Expression ')'; | |
MakeTime_Func= ?RetType=dual? ?func? < ?FuncGroup=DATE? ?GroupList=DATE? ?helpid=45494? 'MakeTime' '(' > ?Name=hour? Expression[ ',' ?Name=minute? Expression[ ',' ?Name=second? Expression]] ')'; | |
NumSum_Func= ?RetType=num? ?func? < ?FuncGroup=LEG? ?GroupList=LEG? ?helpid=45496? ?deprecated? 'NumSum' '(' > ?Name=first_expr? Expression{',' Expression} ')'; | |
NumMin_Func= ?RetType=num? ?func? < ?FuncGroup=LEG? ?GroupList=LEG? ?helpid=45498? ?deprecated? 'NumMin' '(' > ?Name=first_expr? Expression{',' Expression} ')'; | |
NumMax_Func= ?RetType=num? ?func? < ?FuncGroup=LEG? ?GroupList=LEG? ?helpid=45500? ?deprecated? 'NumMax' '(' > ?Name=first_expr? Expression{',' Expression} ')'; | |
NumAvg_Func= ?RetType=num? ?func? < ?FuncGroup=LEG? ?GroupList=LEG? ?helpid=45502? ?deprecated? 'NumAvg' '(' > ?Name=first_expr? Expression{',' Expression} ')'; | |
NumCount_Func= ?RetType=int? ?func? < ?FuncGroup=LEG? ?GroupList=LEG? ?helpid=45504? ?deprecated? 'NumCount' '(' > ?Name=first_expr? Expression{',' Expression} ')'; | |
RangeNumericCount_Func= ?RetType=int? ?func? < ?FuncGroup=RNG? ?GroupList=RNG? ?helpid=45506? 'RangeNumericCount' '(' > ?Name=first_expr? Expression{',' Expression} ')'; | |
RangeSum_Func= ?RetType=num? ?func? < ?FuncGroup=RNG? ?GroupList=RNG? ?helpid=45508? 'RangeSum' '(' > ?Name=first_expr? Expression{',' Expression} ')'; | |
RangeMin_Func= ?RetType=num? ?func? < ?FuncGroup=RNG? ?GroupList=RNG? ?helpid=45510? 'RangeMin' '(' > ?Name=first_expr? Expression{',' Expression} ')'; | |
RangeMax_Func= ?RetType=num? ?func? < ?FuncGroup=RNG? ?GroupList=RNG? ?helpid=45512? 'RangeMax' '(' > ?Name=first_expr? Expression{',' Expression} ')'; | |
RangeAvg_Func= ?RetType=num? ?func? < ?FuncGroup=RNG? ?GroupList=RNG? ?helpid=45514? 'RangeAvg' '(' > ?Name=first_expr? Expression{',' Expression} ')'; | |
RangeStDev_Func= ?RetType=num? ?func? < ?FuncGroup=RNG? ?GroupList=RNG? ?helpid=45516? 'RangeStDev' '(' > ?Name=first_expr? Expression{',' Expression} ')'; | |
RangeSkew_Func= ?RetType=num? ?func? < ?FuncGroup=RNG? ?GroupList=RNG? ?helpid=45518? 'RangeSkew' '(' > ?Name=first_expr? Expression{',' Expression} ')'; | |
RangeKurtosis_Func= ?RetType=num? ?func? < ?FuncGroup=RNG? ?GroupList=RNG? ?helpid=45520? 'RangeKurtosis' '(' > ?Name=first_expr? Expression{',' Expression} ')'; | |
RangeNullCount_Func= ?RetType=int? ?func? < ?FuncGroup=RNG? ?GroupList=RNG,NULL? ?helpid=45522? 'RangeNullCount' '(' > ?Name=first_expr? Expression{',' Expression} ')'; | |
RangeTextCount_Func= ?RetType=int? ?func? < ?FuncGroup=RNG? ?GroupList=RNG? ?helpid=45524? 'RangeTextCount' '(' > ?Name=first_expr? Expression{',' Expression} ')'; | |
RangeMissingCount_Func= ?RetType=int? ?func? < ?FuncGroup=RNG? ?GroupList=RNG? ?helpid=45526? 'RangeMissingCount' '(' > ?Name=first_expr? Expression{',' Expression} ')'; | |
RangeCount_Func= ?RetType=int? ?func? < ?FuncGroup=RNG? ?GroupList=RNG? ?helpid=45528? 'RangeCount' '(' > ?Name=first_expr? Expression{',' Expression} ')'; | |
RangeOnly_Func= ?RetType=dual? ?func? < ?FuncGroup=RNG? ?GroupList=RNG? ?helpid=45530? 'RangeOnly' '(' > ?Name=first_expr? Expression{',' Expression} ')'; | |
RangeMinString_Func= ?RetType=str? ?func? < ?FuncGroup=RNG? ?GroupList=RNG? ?helpid=45532? 'RangeMinString' '(' > ?Name=first_expr? Expression{',' Expression} ')'; | |
RangeMaxString_Func= ?RetType=str? ?func? < ?FuncGroup=RNG? ?GroupList=RNG? ?helpid=45534? 'RangeMaxString' '(' > ?Name=first_expr? Expression{',' Expression} ')'; | |
RangeMode_Func= ?RetType=num? ?func? < ?FuncGroup=RNG? ?GroupList=RNG? ?helpid=45536? 'RangeMode' '(' > ?Name=first_expr? Expression{',' Expression} ')'; | |
RangeFractile_Func= ?RetType=num? ?func? < ?FuncGroup=RNG? ?GroupList=RNG? ?helpid=45538? 'RangeFractile' '(' > ?Name=fractile? Expression ',' ?Name=first_expr? Expression{',' Expression} ')'; | |
Rank_Func= ?RetType=dual? ?func? < ?FuncGroup=RNK? ?GroupList=RNK? ?helpid=45542? 'Rank' '(' > ['TOTAL']?Name=expr? Expression[ ',' ?Name=mode? Expression[ ',' ?Name=fmt? Expression]] ')'; | |
VRank_Func= ?RetType=dual? ?func? < ?FuncGroup=RNK? ?GroupList=RNK? ?helpid=45543? ?deprecated? 'VRank' '(' > ['TOTAL']?Name=expr? Expression[ ',' ?Name=mode? Expression[ ',' ?Name=fmt? Expression]] ')'; | |
HRank_Func= ?RetType=dual? ?func? < ?FuncGroup=RNK? ?GroupList=RNK? ?helpid=45544? 'HRank' '(' > ['TOTAL']?Name=expr? Expression[ ',' ?Name=mode? Expression[ ',' ?Name=fmt? Expression]] ')'; | |
Top_Func= ?RetType=dual? ?func? < ?FuncGroup=RCRD? ?GroupList=RCRD? ?helpid=45545? 'Top' '(' > ['TOTAL']?Name=expr? Expression[ ',' ?Name=offset? Expression[ ',' ?Name=count? Expression]] ')'; | |
Bottom_Func= ?RetType=dual? ?func? < ?FuncGroup=RCRD? ?GroupList=RCRD? ?helpid=45546? 'Bottom' '(' > ['TOTAL']?Name=expr? Expression[ ',' ?Name=offset? Expression[ ',' ?Name=count? Expression]] ')'; | |
Above_Func= ?RetType=dual? ?func? < ?FuncGroup=RCRD? ?GroupList=RCRD? ?helpid=45547? 'Above' '(' > ['TOTAL']?Name=expr? Expression[ ',' ?Name=offset? Expression[ ',' ?Name=count? Expression]] ')'; | |
Below_Func= ?RetType=dual? ?func? < ?FuncGroup=RCRD? ?GroupList=RCRD? ?helpid=45548? 'Below' '(' > ['TOTAL']?Name=expr? Expression[ ',' ?Name=offset? Expression[ ',' ?Name=count? Expression]] ')'; | |
First_Func= ?RetType=dual? ?func? < ?FuncGroup=RCRD? ?GroupList=RCRD? ?helpid=45549? 'First' '(' > ['TOTAL']?Name=expr? Expression[ ',' ?Name=offset? Expression[ ',' ?Name=count? Expression]] ')'; | |
Before_Func= ?RetType=dual? ?func? < ?FuncGroup=RCRD? ?GroupList=RCRD? ?helpid=45550? 'Before' '(' > ['TOTAL']?Name=expr? Expression[ ',' ?Name=offset? Expression[ ',' ?Name=count? Expression]] ')'; | |
After_Func= ?RetType=dual? ?func? < ?FuncGroup=RCRD? ?GroupList=RCRD? ?helpid=45551? 'After' '(' > ['TOTAL']?Name=expr? Expression[ ',' ?Name=offset? Expression[ ',' ?Name=count? Expression]] ')'; | |
Last_Func= ?RetType=dual? ?func? < ?FuncGroup=RCRD? ?GroupList=RCRD? ?helpid=45552? 'Last' '(' > ['TOTAL']?Name=expr? Expression[ ',' ?Name=offset? Expression[ ',' ?Name=count? Expression]] ')'; | |
Info_Func= ?RetType=str? ?func? < ?FuncGroup=STR? ?GroupList=STR? ?helpid=45554? 'Info' '(' > ?Name=field_name? Expression ')'; | |
FieldValue_Func= ?RetType=dual? ?func? < ?FuncGroup=TBL? ?GroupList=TBL? ?helpid=45556? 'FieldValue' '(' > ?Name=field_name? Expression ',' ?Name=elem_no? Expression ')'; | |
FieldValueCount_Func= ?RetType=int? ?func? < ?FuncGroup=TBL? ?GroupList=TBL? ?helpid=45558? 'FieldValueCount' '(' > ?Name=field_name? Expression ')'; | |
FieldIndex_Func= ?RetType=int? ?func? < ?FuncGroup=TBL? ?GroupList=TBL? ?helpid=45560? 'FieldIndex' '(' > ?Name=field_name? Expression ',' ?Name=value? Expression ')'; | |
FieldElemNo_Func= ?RetType=int? ?func? < ?FuncGroup=TBL? ?GroupList=TBL? ?helpid=45562? 'FieldElemNo' '(' > ?Name=field_name? Expression ')'; | |
GetPossibleCount_Func= ?RetType=int? ?func? < ?FuncGroup=TBL? ?GroupList=TBL? ?helpid=45563? 'GetPossibleCount' '(' > ?Name=field_name? Expression ')'; | |
GetSelectedCount_Func= ?RetType=int? ?func? < ?FuncGroup=TBL? ?GroupList=TBL? ?helpid=45564? 'GetSelectedCount' '(' > ?Name=field_name? Expression[ ',' ?Name=include_excluded? Expression[ ',' ?Name=state_name? Expression]] ')'; | |
GetNotSelectedCount_Func= ?RetType=int? ?func? < ?FuncGroup=TBL? ?GroupList=TBL? ?helpid=45565? 'GetNotSelectedCount' '(' > ?Name=field_name? Expression[ ',' ?Name=include_excluded? Expression] ')'; | |
GetExcludedCount_Func= ?RetType=int? ?func? < ?FuncGroup=TBL? ?GroupList=TBL? ?helpid=45566? 'GetExcludedCount' '(' > ?Name=field_name? Expression ')'; | |
GetAlternativeCount_Func= ?RetType=int? ?func? < ?FuncGroup=TBL? ?GroupList=TBL? ?helpid=45567? 'GetAlternativeCount' '(' > ?Name=field_name? Expression ')'; | |
GetFieldSelections_Func= ?RetType=str? ?func? < ?FuncGroup=TBL? ?GroupList=TBL? ?helpid=45568? 'GetFieldSelections' '(' > ?Name=field_name? Expression[ ',' ?Name=value_sep? Expression[ ',' ?Name=max_values? Expression[ ',' ?Name=state_name? Expression]]] ')'; | |
GetCurrentSelections_Func= ?RetType=str? ?func? < ?FuncGroup=TBL? ?GroupList=TBL? ?helpid=45569? 'GetCurrentSelections' '(' > [?Name=record_sep? Expression[ ',' ?Name=tag_sep? Expression[ ',' ?Name=value_sep? Expression[ ',' ?Name=max_values? Expression[ ',' ?Name=state_name? Expression]]]]] ')'; | |
StateName_Func= ?RetType=str? ?func? < ?FuncGroup=SYS? ?GroupList=SYS? ?helpid=45570? 'StateName' '(' > ')'; | |
Hash128_Func= ?RetType=str? ?func? < ?FuncGroup=STR? ?GroupList=STR? ?helpid=45575? 'Hash128' '(' > ?Name=expr? Expression{',' Expression} ')'; | |
Hash160_Func= ?RetType=str? ?func? < ?FuncGroup=STR? ?GroupList=STR? ?helpid=45577? 'Hash160' '(' > ?Name=expr? Expression{',' Expression} ')'; | |
Hash256_Func= ?RetType=str? ?func? < ?FuncGroup=STR? ?GroupList=STR? ?helpid=45579? 'Hash256' '(' > ?Name=expr? Expression{',' Expression} ')'; | |
Replace_Func= ?RetType=str? ?func? < ?FuncGroup=STR? ?GroupList=STR? ?helpid=45583? 'Replace' '(' > ?Name=text? Expression ',' ?Name=from_str? Expression ',' ?Name=to_str? Expression ')'; | |
SubStringCount_Func= ?RetType=num? ?func? < ?FuncGroup=STR? ?GroupList=STR? ?helpid=45585? 'SubStringCount' '(' > ?Name=text? Expression ',' ?Name=sub_string? Expression ')'; | |
OSUser_Func= ?RetType=str? ?func? < ?FuncGroup=SYS? ?GroupList=SYS? ?helpid=45588? 'OSUser' '(' > ')'; | |
GetDataModelHash_Func= ?RetType=str? ?func? < ?FuncGroup=SYS? ?GroupList=SYS? ?helpid=45590? 'GetDataModelHash' '(' > ')'; | |
DocumentPath_Func= ?RetType=str? ?func? < ?FuncGroup=SYS? ?GroupList=SYS? ?helpid=45592? 'DocumentPath' '(' > ')'; | |
DocumentName_Func= ?RetType=str? ?func? < ?FuncGroup=SYS? ?GroupList=SYS? ?helpid=45594? 'DocumentName' '(' > ')'; | |
DocumentTitle_Func= ?RetType=str? ?func? < ?FuncGroup=SYS? ?GroupList=SYS? ?helpid=45596? 'DocumentTitle' '(' > ')'; | |
GetCollationLocale_Func= ?RetType=str? ?func? < ?FuncGroup=SYS? ?GroupList=SYS? ?helpid=45601? 'GetCollationLocale' '(' > ')'; | |
QlikViewVersion_Func= ?RetType=str? ?func? < ?FuncGroup=LEG? ?GroupList=LEG? ?helpid=45603? ?deprecated? 'QlikViewVersion' '(' > ')'; | |
ProductVersion_Func= ?RetType=str? ?func? < ?FuncGroup=SYS? ?GroupList=SYS? ?helpid=45605? 'ProductVersion' '(' > ')'; | |
EngineVersion_Func= ?RetType=str? ?func? < ?FuncGroup=SYS? ?GroupList=SYS? ?helpid=45607? 'EngineVersion' '(' > ')'; | |
QVUser_Func= ?RetType=str? ?func? < ?FuncGroup=LEG? ?GroupList=LEG? ?helpid=45609? ?deprecated? 'QVUser' '(' > ')'; | |
ComputerName_Func= ?RetType=str? ?func? < ?FuncGroup=SYS? ?GroupList=SYS? ?helpid=45611? 'ComputerName' '(' > ')'; | |
Author_Func= ?RetType=str? ?func? < ?FuncGroup=SYS? ?GroupList=SYS? ?helpid=45613? 'Author' '(' > ')'; | |
ReloadTime_Func= ?RetType=dual? ?func? < ?FuncGroup=SYS? ?GroupList=SYS? ?helpid=45615? 'ReloadTime' '(' > ')'; | |
GetObjectField_Func= ?RetType=str? ?func? < ?FuncGroup=TBL? ?GroupList=TBL? ?helpid=45617? 'GetObjectField' '(' > [?Name=index? Expression[ ',' ?Name=objectid? Expression]] ')'; | |
GetObjectDimension_Func= ?RetType=str? ?func? < ?FuncGroup=TBL? ?GroupList=TBL? ?helpid=45618? 'GetObjectDimension' '(' > [?Name=index? Expression[ ',' ?Name=objectid? Expression]] ')'; | |
GetObjectMeasure_Func= ?RetType=str? ?func? < ?FuncGroup=TBL? ?GroupList=TBL? ?helpid=45619? 'GetObjectMeasure' '(' > [?Name=index? Expression[ ',' ?Name=objectid? Expression]] ')'; | |
ClientPlatform_Func= ?RetType=str? ?func? < ?FuncGroup=SYS? ?GroupList=SYS? ?helpid=45621? 'ClientPlatform' '(' > ')'; | |
DayNumberOfYear_Func= ?RetType=int? ?func? < ?FuncGroup=DATE? ?GroupList=DATE? ?helpid=45623? 'DayNumberOfYear' '(' > ?Name=timestamp? Expression[ ',' ?Name=start_month? Expression] ')'; | |
DayNumberOfQuarter_Func= ?RetType=int? ?func? < ?FuncGroup=DATE? ?GroupList=DATE? ?helpid=45625? 'DayNumberOfQuarter' '(' > ?Name=timestamp? Expression[ ',' ?Name=start_month? Expression] ')'; | |
Year2Date_Func= ?RetType=bool? ?func? < ?FuncGroup=DATE? ?GroupList=DATE? ?helpid=45627? ?deprecated? 'Year2Date' '(' > ?Name=timestamp? Expression[ ',' ?Name=year_offset? Expression[ ',' ?Name=start_month? Expression[ ',' ?Name=ref_timestamp? Expression]]] ')'; | |
YearToDate_Func= ?RetType=bool? ?func? < ?FuncGroup=DATE? ?GroupList=DATE? ?helpid=45629? 'YearToDate' '(' > ?Name=timestamp? Expression[ ',' ?Name=year_offset? Expression[ ',' ?Name=start_month? Expression[ ',' ?Name=ref_timestamp? Expression]]] ')'; | |
InYear_Func= ?RetType=bool? ?func? < ?FuncGroup=DATE? ?GroupList=DATE? ?helpid=45631? 'InYear' '(' > ?Name=timestamp? Expression ',' ?Name=base_date? Expression ',' ?Name=period_no? Expression[ ',' ?Name=first_month_of_year? Expression] ')'; | |
InYearToDate_Func= ?RetType=bool? ?func? < ?FuncGroup=DATE? ?GroupList=DATE? ?helpid=45633? 'InYearToDate' '(' > ?Name=timestamp? Expression ',' ?Name=base_date? Expression ',' ?Name=period_no? Expression[ ',' ?Name=first_month_of_year? Expression] ')'; | |
InQuarter_Func= ?RetType=bool? ?func? < ?FuncGroup=DATE? ?GroupList=DATE? ?helpid=45635? 'InQuarter' '(' > ?Name=timestamp? Expression ',' ?Name=base_date? Expression ',' ?Name=period_no? Expression[ ',' ?Name=first_month_of_year? Expression] ')'; | |
InQuarterToDate_Func= ?RetType=bool? ?func? < ?FuncGroup=DATE? ?GroupList=DATE? ?helpid=45637? 'InQuarterToDate' '(' > ?Name=timestamp? Expression ',' ?Name=base_date? Expression ',' ?Name=period_no? Expression[ ',' ?Name=first_month_of_year? Expression] ')'; | |
InMonth_Func= ?RetType=bool? ?func? < ?FuncGroup=DATE? ?GroupList=DATE? ?helpid=45639? 'InMonth' '(' > ?Name=timestamp? Expression ',' ?Name=base_date? Expression ',' ?Name=period_no? Expression[ ',' ?Name=first_month_of_year? Expression] ')'; | |
InMonthToDate_Func= ?RetType=bool? ?func? < ?FuncGroup=DATE? ?GroupList=DATE? ?helpid=45641? 'InMonthToDate' '(' > ?Name=timestamp? Expression ',' ?Name=base_date? Expression ',' ?Name=period_no? Expression[ ',' ?Name=first_month_of_year? Expression] ')'; | |
InMonths_Func= ?RetType=bool? ?func? < ?FuncGroup=DATE? ?GroupList=DATE? ?helpid=45643? 'InMonths' '(' > ?Name=n_months? Expression ',' ?Name=timestamp? Expression ',' ?Name=base_date? Expression ',' ?Name=period_no? Expression[ ',' ?Name=first_month_of_year? Expression] ')'; | |
InMonthsToDate_Func= ?RetType=bool? ?func? < ?FuncGroup=DATE? ?GroupList=DATE? ?helpid=45645? 'InMonthsToDate' '(' > ?Name=n_months? Expression ',' ?Name=timestamp? Expression ',' ?Name=base_date? Expression ',' ?Name=period_no? Expression[ ',' ?Name=first_month_of_year? Expression] ')'; | |
InWeek_Func= ?RetType=bool? ?func? < ?FuncGroup=DATE? ?GroupList=DATE? ?helpid=45647? 'InWeek' '(' > ?Name=timestamp? Expression ',' ?Name=base_date? Expression ',' ?Name=period_no? Expression[ ',' ?Name=first_week_day? Expression] ')'; | |
InWeekToDate_Func= ?RetType=bool? ?func? < ?FuncGroup=DATE? ?GroupList=DATE? ?helpid=45649? 'InWeekToDate' '(' > ?Name=timestamp? Expression ',' ?Name=base_date? Expression ',' ?Name=period_no? Expression[ ',' ?Name=first_week_day? Expression] ')'; | |
InLunarWeek_Func= ?RetType=bool? ?func? < ?FuncGroup=DATE? ?GroupList=DATE? ?helpid=45651? 'InLunarWeek' '(' > ?Name=timestamp? Expression ',' ?Name=base_date? Expression ',' ?Name=period_no? Expression[ ',' ?Name=first_week_day? Expression] ')'; | |
InLunarWeekToDate_Func= ?RetType=bool? ?func? < ?FuncGroup=DATE? ?GroupList=DATE? ?helpid=45653? 'InLunarWeekToDate' '(' > ?Name=timestamp? Expression ',' ?Name=base_date? Expression ',' ?Name=period_no? Expression[ ',' ?Name=first_week_day? Expression] ')'; | |
InDay_Func= ?RetType=bool? ?func? < ?FuncGroup=DATE? ?GroupList=DATE? ?helpid=45655? 'InDay' '(' > ?Name=timestamp? Expression ',' ?Name=base_timestamp? Expression ',' ?Name=period_no? Expression[ ',' ?Name=day_start? Expression] ')'; | |
InDayToTime_Func= ?RetType=bool? ?func? < ?FuncGroup=DATE? ?GroupList=DATE? ?helpid=45657? 'InDayToTime' '(' > ?Name=timestamp? Expression ',' ?Name=base_timestamp? Expression ',' ?Name=period_no? Expression[ ',' ?Name=day_start? Expression] ')'; | |
YearStart_Func= ?RetType=dual? ?func? < ?FuncGroup=DATE? ?GroupList=DATE? ?helpid=45659? 'YearStart' '(' > ?Name=date? Expression[ ',' ?Name=period_no? Expression[ ',' ?Name=first_month_of_year? Expression]] ')'; | |
QuarterStart_Func= ?RetType=dual? ?func? < ?FuncGroup=DATE? ?GroupList=DATE? ?helpid=45661? 'QuarterStart' '(' > ?Name=date? Expression[ ',' ?Name=period_no? Expression[ ',' ?Name=first_month_of_year? Expression]] ')'; | |
MonthStart_Func= ?RetType=dual? ?func? < ?FuncGroup=DATE? ?GroupList=DATE? ?helpid=45663? 'MonthStart' '(' > ?Name=date? Expression[ ',' ?Name=period_no? Expression] ')'; | |
MonthsStart_Func= ?RetType=dual? ?func? < ?FuncGroup=DATE? ?GroupList=DATE? ?helpid=45665? 'MonthsStart' '(' > ?Name=n_months? Expression ',' ?Name=date? Expression[ ',' ?Name=period_no? Expression[ ',' ?Name=first_month_of_year? Expression]] ')'; | |
WeekStart_Func= ?RetType=dual? ?func? < ?FuncGroup=DATE? ?GroupList=DATE? ?helpid=45667? 'WeekStart' '(' > ?Name=date? Expression[ ',' ?Name=period_no? Expression[ ',' ?Name=first_week_day? Expression]] ')'; | |
LunarWeekStart_Func= ?RetType=dual? ?func? < ?FuncGroup=DATE? ?GroupList=DATE? ?helpid=45669? 'LunarWeekStart' '(' > ?Name=date? Expression[ ',' ?Name=period_no? Expression[ ',' ?Name=first_week_day? Expression]] ')'; | |
DayStart_Func= ?RetType=dual? ?func? < ?FuncGroup=DATE? ?GroupList=DATE? ?helpid=45671? 'DayStart' '(' > ?Name=time? Expression[ ',' ?Name=period_no? Expression[ ',' ?Name=day_start? Expression]] ')'; | |
YearEnd_Func= ?RetType=dual? ?func? < ?FuncGroup=DATE? ?GroupList=DATE? ?helpid=45673? 'YearEnd' '(' > ?Name=date? Expression[ ',' ?Name=period_no? Expression[ ',' ?Name=first_month_of_year? Expression]] ')'; | |
QuarterEnd_Func= ?RetType=dual? ?func? < ?FuncGroup=DATE? ?GroupList=DATE? ?helpid=45675? 'QuarterEnd' '(' > ?Name=date? Expression[ ',' ?Name=period_no? Expression[ ',' ?Name=first_month_of_year? Expression]] ')'; | |
MonthEnd_Func= ?RetType=dual? ?func? < ?FuncGroup=DATE? ?GroupList=DATE? ?helpid=45677? 'MonthEnd' '(' > ?Name=date? Expression[ ',' ?Name=period_no? Expression] ')'; | |
MonthsEnd_Func= ?RetType=dual? ?func? < ?FuncGroup=DATE? ?GroupList=DATE? ?helpid=45679? 'MonthsEnd' '(' > ?Name=n_months? Expression ',' ?Name=date? Expression[ ',' ?Name=period_no? Expression[ ',' ?Name=first_month_of_year? Expression]] ')'; | |
WeekEnd_Func= ?RetType=dual? ?func? < ?FuncGroup=DATE? ?GroupList=DATE? ?helpid=45681? 'WeekEnd' '(' > ?Name=date? Expression[ ',' ?Name=period_no? Expression[ ',' ?Name=first_week_day? Expression]] ')'; | |
LunarWeekEnd_Func= ?RetType=dual? ?func? < ?FuncGroup=DATE? ?GroupList=DATE? ?helpid=45683? 'LunarWeekEnd' '(' > ?Name=date? Expression[ ',' ?Name=period_no? Expression[ ',' ?Name=first_week_day? Expression]] ')'; | |
DayEnd_Func= ?RetType=dual? ?func? < ?FuncGroup=DATE? ?GroupList=DATE? ?helpid=45685? 'DayEnd' '(' > ?Name=time? Expression[ ',' ?Name=period_no? Expression[ ',' ?Name=day_start? Expression]] ')'; | |
YearName_Func= ?RetType=dual? ?func? < ?FuncGroup=DATE? ?GroupList=DATE? ?helpid=45687? 'YearName' '(' > ?Name=date? Expression[ ',' ?Name=period_no? Expression[ ',' ?Name=first_month_of_year? Expression]] ')'; | |
QuarterName_Func= ?RetType=dual? ?func? < ?FuncGroup=DATE? ?GroupList=DATE? ?helpid=45689? 'QuarterName' '(' > ?Name=date? Expression[ ',' ?Name=period_no? Expression[ ',' ?Name=first_month_of_year? Expression]] ')'; | |
MonthName_Func= ?RetType=dual? ?func? < ?FuncGroup=DATE? ?GroupList=DATE? ?helpid=45691? 'MonthName' '(' > ?Name=date? Expression[ ',' ?Name=period_no? Expression] ')'; | |
MonthsName_Func= ?RetType=dual? ?func? < ?FuncGroup=DATE? ?GroupList=DATE? ?helpid=45693? 'MonthsName' '(' > ?Name=n_months? Expression ',' ?Name=date? Expression[ ',' ?Name=period_no? Expression[ ',' ?Name=first_month_of_year? Expression]] ')'; | |
WeekName_Func= ?RetType=dual? ?func? < ?FuncGroup=DATE? ?GroupList=DATE? ?helpid=45695? 'WeekName' '(' > ?Name=date? Expression[ ',' ?Name=period_no? Expression[ ',' ?Name=first_week_day? Expression]] ')'; | |
LunarWeekName_Func= ?RetType=dual? ?func? < ?FuncGroup=DATE? ?GroupList=DATE? ?helpid=45697? 'LunarWeekName' '(' > ?Name=date? Expression[ ',' ?Name=period_no? Expression[ ',' ?Name=first_week_day? Expression]] ')'; | |
DayName_Func= ?RetType=dual? ?func? < ?FuncGroup=DATE? ?GroupList=DATE? ?helpid=45699? 'DayName' '(' > ?Name=time? Expression[ ',' ?Name=period_no? Expression[ ',' ?Name=day_start? Expression]] ')'; | |
SetDateYear_Func= ?RetType=dual? ?func? < ?FuncGroup=DATE? ?GroupList=DATE? ?helpid=45701? 'SetDateYear' '(' > ?Name=timestamp? Expression ',' ?Name=year? Expression ')'; | |
SetDateYearMonth_Func= ?RetType=dual? ?func? < ?FuncGroup=DATE? ?GroupList=DATE? ?helpid=45703? 'SetDateYearMonth' '(' > ?Name=timestamp? Expression ',' ?Name=year? Expression ',' ?Name=month? Expression ')'; | |
LocalTime_Func= ?RetType=dual? ?func? < ?FuncGroup=DATE? ?GroupList=DATE? ?helpid=45705? 'LocalTime' '(' > [?Name=place? Expression[ ',' ?Name=ignore_dst? Expression]] ')'; | |
ConvertToLocalTime_Func= ?RetType=dual? ?func? < ?FuncGroup=DATE? ?GroupList=DATE? ?helpid=45707? 'ConvertToLocalTime' '(' > ?Name=timestamp? Expression[ ',' ?Name=place? Expression[ ',' ?Name=ignore_dst? Expression]] ')'; | |
Aggr_Func= ?RetType=dual? ?func? < ?FuncGroup=ARRAY? ?GroupList=ARRAY? ?helpid=45724? 'Aggr' '(' > { ['DISTINCT']['NODISTINCT'] } ?Name=expr? Expression ',' StructuredParameter{',' StructuredParameter} ')'; | |
ValueList_Func= ?RetType=dual? ?func? < ?FuncGroup=ARRAY? ?GroupList=ARRAY? ?helpid=45725? 'ValueList' '(' > ?Name=v1? Expression{',' Expression} ')'; | |
ValueLoop_Func= ?RetType=dual? ?func? < ?FuncGroup=ARRAY? ?GroupList=ARRAY? ?helpid=45726? 'ValueLoop' '(' > ?Name=from? Expression[ ',' ?Name=to? Expression[ ',' ?Name=step? Expression]] ')'; | |
Sum_Func= ?RetType=num? ?aggr? < ?FuncGroup=AGGR? ?GroupList=AGGR? ?helpid=45728? 'Sum' '(' > { [SetExpression]['DISTINCT']['ALL']['TOTAL' ['<' ?Name=fld? ExpressionFieldRef {',' ?Name=fld? ExpressionFieldRef} '>'] ] } ?Name=expr? Expression ')'; | |
Min_Func= ?RetType=num? ?aggr? < ?FuncGroup=AGGR? ?GroupList=AGGR? ?helpid=45730? 'Min' '(' > { [SetExpression]['ALL']['TOTAL' ['<' ?Name=fld? ExpressionFieldRef {',' ?Name=fld? ExpressionFieldRef} '>'] ] } ?Name=expr? Expression[ ',' ?Name=rank? Expression] ')'; | |
Max_Func= ?RetType=num? ?aggr? < ?FuncGroup=AGGR? ?GroupList=AGGR? ?helpid=45732? 'Max' '(' > { [SetExpression]['ALL']['TOTAL' ['<' ?Name=fld? ExpressionFieldRef {',' ?Name=fld? ExpressionFieldRef} '>'] ] } ?Name=expr? Expression[ ',' ?Name=rank? Expression] ')'; | |
Avg_Func= ?RetType=num? ?aggr? < ?FuncGroup=AGGR? ?GroupList=AGGR? ?helpid=45734? 'Avg' '(' > { [SetExpression]['DISTINCT']['ALL']['TOTAL' ['<' ?Name=fld? ExpressionFieldRef {',' ?Name=fld? ExpressionFieldRef} '>'] ] } ?Name=expr? Expression ')'; | |
StDev_Func= ?RetType=num? ?aggr? < ?FuncGroup=AGGR? ?GroupList=AGGR? ?helpid=45736? 'StDev' '(' > { [SetExpression]['DISTINCT']['ALL']['TOTAL' ['<' ?Name=fld? ExpressionFieldRef {',' ?Name=fld? ExpressionFieldRef} '>'] ] } ?Name=expr? Expression ')'; | |
Skew_Func= ?RetType=num? ?aggr? < ?FuncGroup=AGGR? ?GroupList=AGGR? ?helpid=45738? 'Skew' '(' > { [SetExpression]['DISTINCT']['ALL']['TOTAL' ['<' ?Name=fld? ExpressionFieldRef {',' ?Name=fld? ExpressionFieldRef} '>'] ] } ?Name=expr? Expression ')'; | |
Kurtosis_Func= ?RetType=num? ?aggr? < ?FuncGroup=AGGR? ?GroupList=AGGR? ?helpid=45740? 'Kurtosis' '(' > { [SetExpression]['DISTINCT']['ALL']['TOTAL' ['<' ?Name=fld? ExpressionFieldRef {',' ?Name=fld? ExpressionFieldRef} '>'] ] } ?Name=expr? Expression ')'; | |
NumericCount_Func= ?RetType=int? ?aggr? < ?FuncGroup=AGGR? ?GroupList=AGGR? ?helpid=45742? 'NumericCount' '(' > { [SetExpression]['DISTINCT']['ALL']['TOTAL' ['<' ?Name=fld? ExpressionFieldRef {',' ?Name=fld? ExpressionFieldRef} '>'] ] } ?Name=expr? Expression ')'; | |
NullCount_Func= ?RetType=int? ?aggr? < ?FuncGroup=AGGR? ?GroupList=AGGR? ?helpid=45744? 'NullCount' '(' > { [SetExpression]['DISTINCT']['ALL']['TOTAL' ['<' ?Name=fld? ExpressionFieldRef {',' ?Name=fld? ExpressionFieldRef} '>'] ] } ?Name=expr? Expression ')'; | |
TextCount_Func= ?RetType=int? ?aggr? < ?FuncGroup=AGGR? ?GroupList=AGGR? ?helpid=45746? 'TextCount' '(' > { [SetExpression]['DISTINCT']['ALL']['TOTAL' ['<' ?Name=fld? ExpressionFieldRef {',' ?Name=fld? ExpressionFieldRef} '>'] ] } ?Name=expr? Expression ')'; | |
Count_Func= ?RetType=int? ?aggr? < ?FuncGroup=AGGR? ?GroupList=AGGR? ?helpid=45748? 'Count' '(' > { [SetExpression]['DISTINCT']['ALL']['TOTAL' ['<' ?Name=fld? ExpressionFieldRef {',' ?Name=fld? ExpressionFieldRef} '>'] ] } ?Name=expr? Expression ')'; | |
MissingCount_Func= ?RetType=int? ?aggr? < ?FuncGroup=AGGR? ?GroupList=AGGR? ?helpid=45750? 'MissingCount' '(' > { [SetExpression]['DISTINCT']['ALL']['TOTAL' ['<' ?Name=fld? ExpressionFieldRef {',' ?Name=fld? ExpressionFieldRef} '>'] ] } ?Name=expr? Expression ')'; | |
MinString_Func= ?RetType=dual? ?aggr? < ?FuncGroup=AGGR? ?GroupList=AGGR? ?helpid=45752? 'MinString' '(' > { [SetExpression]['TOTAL' ['<' ?Name=fld? ExpressionFieldRef {',' ?Name=fld? ExpressionFieldRef} '>'] ] } ?Name=expr? Expression ')'; | |
MaxString_Func= ?RetType=dual? ?aggr? < ?FuncGroup=AGGR? ?GroupList=AGGR? ?helpid=45754? 'MaxString' '(' > { [SetExpression]['TOTAL' ['<' ?Name=fld? ExpressionFieldRef {',' ?Name=fld? ExpressionFieldRef} '>'] ] } ?Name=expr? Expression ')'; | |
Only_Func= ?RetType=dual? ?aggr? < ?FuncGroup=AGGR? ?GroupList=AGGR? ?helpid=45756? 'Only' '(' > { [SetExpression]['TOTAL' ['<' ?Name=fld? ExpressionFieldRef {',' ?Name=fld? ExpressionFieldRef} '>'] ] } ?Name=expr? Expression ')'; | |
Mode_Func= ?RetType=dual? ?aggr? < ?FuncGroup=AGGR? ?GroupList=AGGR? ?helpid=45758? 'Mode' '(' > { [SetExpression]['TOTAL' ['<' ?Name=fld? ExpressionFieldRef {',' ?Name=fld? ExpressionFieldRef} '>'] ] } ?Name=expr? Expression ')'; | |
Fractile_Func= ?RetType=num? ?aggr? < ?FuncGroup=AGGR? ?GroupList=AGGR? ?helpid=45760? 'Fractile' '(' > { [SetExpression]['TOTAL' ['<' ?Name=fld? ExpressionFieldRef {',' ?Name=fld? ExpressionFieldRef} '>'] ]['ALL']['DISTINCT'] } ?Name=expr? Expression ',' ?Name=fraction? Expression ')'; | |
Median_Func= ?RetType=num? ?aggr? < ?FuncGroup=AGGR? ?GroupList=AGGR? ?helpid=45762? 'Median' '(' > { [SetExpression]['TOTAL' ['<' ?Name=fld? ExpressionFieldRef {',' ?Name=fld? ExpressionFieldRef} '>'] ]['ALL']['DISTINCT'] } ?Name=expr? Expression ')'; | |
StErr_Func= ?RetType=num? ?aggr? < ?FuncGroup=AGGR? ?GroupList=AGGR? ?helpid=45766? 'StErr' '(' > { [SetExpression]['DISTINCT']['TOTAL' ['<' ?Name=fld? ExpressionFieldRef {',' ?Name=fld? ExpressionFieldRef} '>'] ] } ?Name=expr? Expression ')'; | |
Concat_Func= ?RetType=str? ?aggr? < ?FuncGroup=AGGR? ?GroupList=AGGR? ?helpid=45768? 'Concat' '(' > { [SetExpression]['DISTINCT']['TOTAL' ['<' ?Name=fld? ExpressionFieldRef {',' ?Name=fld? ExpressionFieldRef} '>'] ] } ?Name=string? Expression[ ',' ?Name=delimiter? Expression[ ',' ?Name=sort_weight? Expression]] ')'; | |
FirstSortedValue_Func= ?RetType=dual? ?aggr? < ?FuncGroup=AGGR? ?GroupList=AGGR? ?helpid=45770? 'FirstSortedValue' '(' > { [SetExpression]['DISTINCT']['ALL']['TOTAL' ['<' ?Name=fld? ExpressionFieldRef {',' ?Name=fld? ExpressionFieldRef} '>'] ] } ?Name=value? Expression ',' ?Name=sort_weight? Expression[ ',' ?Name=rank? Expression] ')'; | |
Npv_Func= ?RetType=num? ?aggr? < ?FuncGroup=FIN? ?GroupList=FIN,AGGR? ?helpid=45771? 'Npv' '(' > { [SetExpression]['TOTAL' ['<' ?Name=fld? ExpressionFieldRef {',' ?Name=fld? ExpressionFieldRef} '>'] ] } ?Name=discount_rate? Expression ',' ?Name=value? Expression ')'; | |
Irr_Func= ?RetType=num? ?aggr? < ?FuncGroup=FIN? ?GroupList=FIN,AGGR? ?helpid=45772? 'Irr' '(' > { [SetExpression]['TOTAL' ['<' ?Name=fld? ExpressionFieldRef {',' ?Name=fld? ExpressionFieldRef} '>'] ] } ?Name=value? Expression ')'; | |
Xnpv_Func= ?RetType=num? ?aggr? < ?FuncGroup=FIN? ?GroupList=FIN,AGGR? ?helpid=45773? 'Xnpv' '(' > { [SetExpression]['TOTAL' ['<' ?Name=fld? ExpressionFieldRef {',' ?Name=fld? ExpressionFieldRef} '>'] ] } ?Name=discount_rate? Expression ',' ?Name=pmt? Expression ',' ?Name=date? Expression ')'; | |
Xirr_Func= ?RetType=num? ?aggr? < ?FuncGroup=FIN? ?GroupList=FIN,AGGR? ?helpid=45774? 'Xirr' '(' > { [SetExpression]['TOTAL' ['<' ?Name=fld? ExpressionFieldRef {',' ?Name=fld? ExpressionFieldRef} '>'] ] } ?Name=pmt? Expression ',' ?Name=date? Expression ')'; | |
FPSum_Func= ?RetType=num? ?aggr? < ?FuncGroup=AGGR? ?GroupList=AGGR? ?helpid=45780? 'FPSum' '(' > [SetExpression]?Name=value1? Expression ')'; | |
Correl_Func= ?RetType=num? ?aggr? < ?FuncGroup=AGGR? ?GroupList=AGGR? ?helpid=45782? 'Correl' '(' > { [SetExpression]['TOTAL' ['<' ?Name=fld? ExpressionFieldRef {',' ?Name=fld? ExpressionFieldRef} '>'] ] } ?Name=value1? Expression ',' ?Name=value2? Expression ')'; | |
StEYX_Func= ?RetType=num? ?aggr? < ?FuncGroup=AGGR? ?GroupList=AGGR? ?helpid=45784? 'StEYX' '(' > { [SetExpression]['TOTAL' ['<' ?Name=fld? ExpressionFieldRef {',' ?Name=fld? ExpressionFieldRef} '>'] ] } ?Name=y_value? Expression ',' ?Name=x_value? Expression ')'; | |
LinEst_B_Func= ?RetType=num? ?aggr? < ?FuncGroup=AGGR? ?GroupList=AGGR? ?helpid=45786? 'LinEst_B' '(' > { [SetExpression]['TOTAL' ['<' ?Name=fld? ExpressionFieldRef {',' ?Name=fld? ExpressionFieldRef} '>'] ] } ?Name=y_value? Expression ',' ?Name=x_value? Expression[ ',' ?Name=y0_const? Expression[ ',' ?Name=x0_const? Expression]] ')'; | |
LinEst_DF_Func= ?RetType=num? ?aggr? < ?FuncGroup=AGGR? ?GroupList=AGGR? ?helpid=45788? 'LinEst_DF' '(' > { [SetExpression]['TOTAL' ['<' ?Name=fld? ExpressionFieldRef {',' ?Name=fld? ExpressionFieldRef} '>'] ] } ?Name=y_value? Expression ',' ?Name=x_value? Expression[ ',' ?Name=y0_const? Expression[ ',' ?Name=x0_const? Expression]] ')'; | |
LinEst_F_Func= ?RetType=num? ?aggr? < ?FuncGroup=AGGR? ?GroupList=AGGR? ?helpid=45790? 'LinEst_F' '(' > { [SetExpression]['TOTAL' ['<' ?Name=fld? ExpressionFieldRef {',' ?Name=fld? ExpressionFieldRef} '>'] ] } ?Name=y_value? Expression ',' ?Name=x_value? Expression[ ',' ?Name=y0_const? Expression[ ',' ?Name=x0_const? Expression]] ')'; | |
LinEst_M_Func= ?RetType=num? ?aggr? < ?FuncGroup=AGGR? ?GroupList=AGGR? ?helpid=45792? 'LinEst_M' '(' > { [SetExpression]['TOTAL' ['<' ?Name=fld? ExpressionFieldRef {',' ?Name=fld? ExpressionFieldRef} '>'] ] } ?Name=y_value? Expression ',' ?Name=x_value? Expression[ ',' ?Name=y0_const? Expression[ ',' ?Name=x0_const? Expression]] ')'; | |
LinEst_R2_Func= ?RetType=num? ?aggr? < ?FuncGroup=AGGR? ?GroupList=AGGR? ?helpid=45794? 'LinEst_R2' '(' > { [SetExpression]['TOTAL' ['<' ?Name=fld? ExpressionFieldRef {',' ?Name=fld? ExpressionFieldRef} '>'] ] } ?Name=y_value? Expression ',' ?Name=x_value? Expression[ ',' ?Name=y0_const? Expression[ ',' ?Name=x0_const? Expression]] ')'; | |
LinEst_SEB_Func= ?RetType=num? ?aggr? < ?FuncGroup=AGGR? ?GroupList=AGGR? ?helpid=45796? 'LinEst_SEB' '(' > { [SetExpression]['TOTAL' ['<' ?Name=fld? ExpressionFieldRef {',' ?Name=fld? ExpressionFieldRef} '>'] ] } ?Name=y_value? Expression ',' ?Name=x_value? Expression[ ',' ?Name=y0_const? Expression[ ',' ?Name=x0_const? Expression]] ')'; | |
LinEst_SEM_Func= ?RetType=num? ?aggr? < ?FuncGroup=AGGR? ?GroupList=AGGR? ?helpid=45798? 'LinEst_SEM' '(' > { [SetExpression]['TOTAL' ['<' ?Name=fld? ExpressionFieldRef {',' ?Name=fld? ExpressionFieldRef} '>'] ] } ?Name=y_value? Expression ',' ?Name=x_value? Expression[ ',' ?Name=y0_const? Expression[ ',' ?Name=x0_const? Expression]] ')'; | |
LinEst_SEY_Func= ?RetType=num? ?aggr? < ?FuncGroup=AGGR? ?GroupList=AGGR? ?helpid=45800? 'LinEst_SEY' '(' > { [SetExpression]['TOTAL' ['<' ?Name=fld? ExpressionFieldRef {',' ?Name=fld? ExpressionFieldRef} '>'] ] } ?Name=y_value? Expression ',' ?Name=x_value? Expression[ ',' ?Name=y0_const? Expression[ ',' ?Name=x0_const? Expression]] ')'; | |
LinEst_SSReg_Func= ?RetType=num? ?aggr? < ?FuncGroup=AGGR? ?GroupList=AGGR? ?helpid=45802? 'LinEst_SSReg' '(' > { [SetExpression]['TOTAL' ['<' ?Name=fld? ExpressionFieldRef {',' ?Name=fld? ExpressionFieldRef} '>'] ] } ?Name=y_value? Expression ',' ?Name=x_value? Expression[ ',' ?Name=y0_const? Expression[ ',' ?Name=x0_const? Expression]] ')'; | |
LinEst_SSResid_Func= ?RetType=num? ?aggr? < ?FuncGroup=AGGR? ?GroupList=AGGR? ?helpid=45804? 'LinEst_SSResid' '(' > { [SetExpression]['TOTAL' ['<' ?Name=fld? ExpressionFieldRef {',' ?Name=fld? ExpressionFieldRef} '>'] ] } ?Name=y_value? Expression ',' ?Name=x_value? Expression[ ',' ?Name=y0_const? Expression[ ',' ?Name=x0_const? Expression]] ')'; | |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment