Skip to content

Instantly share code, notes, and snippets.

@theredpea
Last active June 14, 2019 20:26
Show Gist options
  • Save theredpea/d17d74de87e4563037b4aabd74cae2a0 to your computer and use it in GitHub Desktop.
Save theredpea/d17d74de87e4563037b4aabd74cae2a0 to your computer and use it in GitHub Desktop.
(******************************************************************************)
(* 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