Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi can u say tell me diff types of
UI FUNCTIONS and script level functions
thanks
Refer the below link.
Do you want this?
Basic Aggregation Functions:
----------------------------
sum()
min()
max()
only()
mode()
firstsortedvalue ([ distinct ] expression [, sort-weight [, n ]])
String Aggregation Functions:
-----------------------------
MinString()
MaxString()
FirstValue(expression)
LastValue(expression)
concat ([ distinct ] expression [, delimiter [, sort-weight]])
Counter Aggregation Functions:
-------------------------------
count([distinct ] expression | * )
NumericCount([ distinct ] expression )
TextCount([ distinct ] expression)
NullCount([ distinct ] expression )
MissingCount([ distinct ] expression )
Advanced Aggregation
--------------------
aggr ([ distinct | nodistinct ] [{set_expression}]expression {,dimension})
Statistical Aggregation Functions in Script:
-------------------------------------------
fractile(expression, fractile)
fractile( Grade, 0.75 )
kurtosis([distinct ] expression )
correl(x-expression, y-expression)
avg([distinct] expression)
stdev([distinct] expression)
skew([ distinct] expression)
median (expression)
sterr ([distinct] expression)
steyx (y-expression, x-expression)
linest_m (y-expression, x-expression [, y0 [, x0 ]])
linest_b (y-expression, x-expression [, y0 [, x0 ]])
linest_r2 (y-expression, x-expression [, y0 [, x0 ]])
linest_sem (y-expression, x-expression [, y0 [, x0 ]])
linest_seb (y-expression, x-expression [, y0 [, x0 ]])
linest_sey (y-expression, x-expression [, y0 [, x0 ]])
linest_df (y-expression, x-expression [, y0 [, x0 ]])
linest_ssreg (y-expression, x-expression [, y0 [, x0 ]])
linest_f (y-expression, x-expression [, y0 [, x0 ]])
linest_ssresid (y-expression, x-expression [, y0 [, x0 ]])
Financial Aggregation Functions in Script:
------------------------------------------
irr(expression)
xirr (valueexpression, dateexpression )
npv (rate, expression)
xnpv (rate, valueexpression, dateexpression)
Statistical Test Functions in Script:
------------------------------------
chi2test_p (col, row, observed_value [, expected_value])
chi2test_df (col, row, observed_value [, expected_value])
chi2test_chi2 (col, row, observed_value [, expected_value])
TTest_t (group, value [, eq_var = true])
TTest_df (group, value [, eq_var = true])
TTest_sig (group, value [, eq_var = true])
TTest_dif (group, value [, eq_var = true])
TTest_sterr (group, value [, eq_var = true])
TTest_conf (group, value [, sig = 0.025 [, eq_var = true]])
TTest_lower (group, value [, sig = 0.025 [, eq_var = true]])
TTest_upper (group, value [, sig = 0.025 [, eq_var = true]])
TTestw_t (weight, group, value [, eq_var = true])
TTestw_df (weight, group, value [, eq_var = true])
TTestw_sig (weight, group, value [, eq_var = true])
TTestw_dif (weight, group, value [, eq_var = true])
TTestw_sterr (weight, group, value [, eq_var = true])
TTestw_conf (weight, group, value [, sig = 0.025 [, eq_var =true]])
TTestw_lower (weight, group, value [, sig = 0.025 [, eq_var =true]])
TTestw_upper (weight, group, value [, sig = 0.025 [, eq_var =true]])
TTest1_t (value)
TTest1_df (value)
TTest1_sig (value)
TTest1_dif (value)
TTest1_sterr (value)
TTest1_conf (value [, sig = 0.025 ])
TTest1_lower (value [, sig = 0.025 ])
TTest1_upper (value [, sig = 0.025 ])
TTest1w_t (weight, value)
TTest1w_df (weight, value)
TTest1w_sig (weight, value)
TTest1w_dif (weight, value)
TTest1w_sterr (weight, value)
TTest1w_conf ( weight, value [, sig = 0.025 ])
TTest1w_lower (weight, value [, sig = 0.025 ])
TTest1w_upper (weight, value [, sig = 0.025 ])
ZTest_z (value [, sigma])
ZTest_sig (value [, sigma])
ZTest_dif (value [, sigma])
ZTest_sterr (value [, sigma] )
ZTest_conf (value [, sigma [, sig = 0.025 ])
ZTestw_z (weight, value [, sigma])
ZTestw_sig (weight, value [, sigma])
ZTestw_sterr (weight, value [, sigma])
Chart General Numeric Functions:
--------------------------------
div(x1 , x2)
mod(x1 , x2)
fmod(x1 , x2)
ceil(x [ , base [ , offset ]])
floor(x [ , base [ , offset ]])
frac(x)
round( x [ , base [ , offset ]])
fabs(x)
numsum( expr1 [ , expr2, ... exprN ])
numcount(expr1 [ , expr2, ... exprN ])
numavg(expr1 [ , expr2, ... exprN ])
nummin(expr1 [ , expr2, ... exprN ])
nummax(expr1 [ , expr2, ... exprN ])
fact(n)
combin(n1, n2)
permut(n1, n2)
even(n)
odd(n)
sign(x)
bitcount(i )
Chart Range Functions:
----------------------
rangesum(expr1 [ , expr2, ... exprN ])
rangeavg(expr1 [ , expr2, ... exprN ])
rangecount(expr1 [ , expr2, ... exprN ] )
rangemin(expr1 [ , expr2, ... exprN ])
rangemax(expr1 [ , expr2, ... exprN ])
rangestdev(expr1 [ , expr2, ... exprN ])
rangeskew(expr1 [ , expr2, ... exprN ])
rangekurtosis(expr1 [ , expr2, ... exprN ])
rangefractile(fractile ,expr1 [ , expr2, ... exprN ])
rangenumericcount(expr1 [ , expr2, ... exprN ])
rangetextcount(expr1 [ , expr2, ... exprN ])
rangenullcount(expr1 [ , expr2, ... exprN ])
rangemissingcount(expr1 [ , expr2, ... exprN ])
rangeminstring(expr1 [ , expr2, ... exprN ])
rangemaxstring(expr1 [ , expr2, ... exprN ])
rangemode(expr1 [ , expr2, ... exprN ])
rangeonly(expr1 [ , expr2, ... exprN ])
rangecorrel(x-value , y-value { , x-value , y-value})
rangeirr(value { ,value} )
rangenpv (rate, value { ,value} )
rangexirr(value, date { ,value, date} )
rangexnpv(rate, value, date { ,value, date} )
Exponential and Logarithmic Functions:
-------------------------------------
exp(x )
log(x )
log10(x )
sqrt(x )
sqr (x )
pow(x,y )
Trigonometric and Hyperbolic Functions:
----------------------------------------
cos( x )
acos(x )
sin(x )
asin(x )
tan( x )
atan(x )
atan2( y,x )
cosh(x )
sinh(x )
tanh(x )
Statistical Distribution Functions:
-----------------------------------
chidist (value, degrees_freedom)
chiinv (prob, degrees_freedom)
normdist (value, mean, standard_dev)
norminv (prob, mean, standard_dev)
tdist (value, degrees_freedom, tails)
tinv (prob, degrees_freedom)
fdist (value, degrees_freedom1, degrees_freedom2)
finv (prob, degrees_freedom1, degrees_freedom2)
Financial Functions:
--------------------
fv(rate, nper, pmt [ ,pv [ , type ] ])
nper(rate, pmt, pv [ ,fv [ , type ] ])
pmt(rate, nper, pv [ ,fv [ , type ] ] )
pv(rate, nper, pmt [ ,fv [ , type ] ])
rate(nper, pmt , pv [ ,fv [ , type ] ])
Black and Schole:
-----------------
BlackAndSchole(strike , time_left , underlying_price , vol , risk_free_rate , type)
Mathematical Constants and Parameter-Free Functions:
----------------------------------------------------
e( )
pi( )
rand( )
true( )
false( )
Counter Functions:
------------------
RecNo( )
RowNo( )
autonumber(expression[ , AutoID])
autonumberhash128(expression {, expression})
autonumberhash256(expression {, expression})
fieldvaluecount(fieldname)
String Functions
----------------
ord( s )
chr( n )
len( s )
left( s , n )
right( s , n )
mid(s, n1[, n2 ])
index(s1 , s2[ , n])
upper(textexpression)
lower( textexpression )
repeat( s, n)
subfield(s, 'delimiter' [ , index ] )
ltrim(s )
rtrim(s )
trim(s )
KeepChar(s1 , s2)
PurgeChar(s1, s2)
capitalize(s )
evaluate(s )
TextBetween(s , beforetext , aftertext [, n ])
Replace(s, fromstring ,tostring)
FindOneOf(text , characterset [ , n])
hash256(expression {, expression} )
hash160(expression {, expression})
hash128(expression {, expression})
Mapping Functions:
------------------
applymap('mapname', expr [ , defaultexpr ] )
mapsubstring('mapname', expr)
Inter Record Functions:
------------------------
exists(field [ , expression ])
previous(expression )
peek(fieldname [ , row [ , tablename ] ] )
FieldValue(fieldname , n )
FieldIndex(fieldname , value )
lookup(fieldname, matchfieldname, matchfieldvalue [, tablename])
Conditional Functions:
-----------------------
if(condition , then , else)
alt(case1[ , case2 , case3 , ...] , else)
pick(n, expr1[ , expr2,...exprN])
match( str, expr1 [ , expr2,...exprN ] )
mixmatch( str, expr1 [ , expr2,...exprN ] )
wildmatch( str, expr1 [ , expr2,...exprN ] )
class(expression, interval [ , label [ , offset ]])
Logical Functions:
-----------------
IsNum( expr)
IsText(expr)
IsPartialReload( )
NULL Functions:
----------------
Null( )
IsNull(expr )
System Functions:
----------------
ClientPlatform( )
OSuser( )
QVuser( )
ComputerName( )
ReloadTime( )
GetActiveSheetID()
GetCurrentField(groupname)
GetCurrentSelections([ recordsep [, tagsep [, valuesep [, maxvalues=6 ]]]])
GetFieldSelections(fieldname [, valuesep [, maxvalues=6 ]])
GetSelectedCount(fieldname [, includeexcluded=false])
GetPossibleCount(fieldname)
GetExcludedCount(fieldname)
GetAlternativeCount(fieldname)
GetNotSelectedCount(fieldname [, includeexcluded=false])
GetRegistryString(path, key)
qlikviewversion()
MsgBox(str msg [, str caption [, mb_buttons [, mb_icons[, mb_defbutton]]]])
Input(str cue [, str caption])
DocumentName( )
DocumentPath( )
DocumentTitle( )
GetObjectField ([index])
GetExtendedProperty (name[, objectid])
File Functions in Script:
-------------------------
Attribute(filename, attributename)
ConnectString()
filebasename()
filedir()
fileextension()
filename()
filepath()
filesize()
filetime([ filename ])
GetFolderPath()
QvdCreateTime(filename)
QvdNoOfRecords(filename)
QvdNoOfFields(filename)
QvdFieldName(filename , fieldno)
QvdTableName(filename)
Table Functions:
---------------
FieldName(nr ,'TableName')
FieldNumber('field ' ,'TableName')
NoOfFields([ 'TableName ' ])
NoOfRows(['TableName ' ])
NoOfTables()
TableName([ 'TableNumber' ])
TableNumber([ 'TableName' ])
Document Functions:
------------------
ReportComment(report_number)
ReportName(report_number)
ReportID(report_number)
ReportNumber(report_id_or_name)
NoOfReports()
Date and Time Functions:
-----------------------
second(expr)
minute(expr)
hour(expr)
day(date)
week(date)
month(date)
year(date)
weekyear(date)
weekday(date)
now([ timer_mode])today([timer_mode] )
LocalTime([timezone [, ignoreDST ]])
MakeDate(YYYY [ , MM [ , DD ] ] )
MakeWeekDate(YYYY [ , WW [ , D ] ] )
MakeTime(hh [ , mm [ , ss [ .fff ] ] ] )
AddMonths(startdate, n , [ , mode] )
YearToDate(date [ , yearoffset [ , firstmonth [ , todaydate] ] ])
TimeZone( )
GMT( )
UTC( )
DaylightSaving( )
SetDateYear (timestamp, year)
SetDateYearMonth (timestamp, year, month)
InYear (date, basedate , shift [, first_month_of_year = 1])
InYearToDate (date, basedate , shift [, first_month_of_year = 1])
InQuarter (date, basedate , shift [, first_month_of_year = 1])
InQuarterToDate (date, basedate , shift [, first_month_of_year =1])
InMonth (date, basedate , shift)
InMonthToDate (date, basedate , shift)
InMonths (n, date, basedate , shift [, first_month_of_year = 1])
InMonthsToDate (n, date, basedate , shift [, first_month_of_year =1])
InWeek (date, basedate , shift [, weekstart])
InWeekToDate (date, basedate , shift [, weekstart])
InLunarWeek (date, basedate , shift [, weekstart])
InLunarWeekToDate (date, basedate , shift [, weekstart])
InDay (timestamp, basetimestamp , shift [, daystart])
InDayToTime (timestamp, basetimestamp , shift [, daystart])
YearStart( date [, shift = 0 [, first_month_of_year = 1]])
YearEnd( date [, shift = 0 [, first_month_of_year = 1]])
Number Interpretation Variables:
-------------------------------
ThousandSep
DecimalSep
MoneyThousandSep
MoneyDecimalSep
MoneyFormat
TimeFormat
DateFormat
TimestampFormat
MonthNames
LongMonthNames
DayNames
LongDayNames
Formatting Functions:
---------------------
num(expression [ , format-code [ , decimal-sep [ , thousands-sep ]
money(expression [ , format-code [ , decimal-sep [ , thousands-sep] ] ])
date(expression [ , format-code ])
time(expression [ , format-code ])
dual( s , x )
interval(expression [ , format-code ])
timestamp(expression [ , format-code ])
Color Functions:
-----------------
color (n)
RGB (e1, e2, e3 )
ARGB(alpha, e1, e2, e3)
HSL (hue, saturation, luminosity)
black( )
darkgray( )
lightgray( )
white( )
blue( )
lightblue( )
green( )
lightgreen( )
cyan( )
lightcyan( )
red( )
lightred( )
magenta( )
lightmagenta( )
brown( )
yellow( )
qliktechgray( )
Colormix1(Value , ColorZero , ColorOne)
syscolor(nr)
qliktechblue( )
HI Naveen,
all of listed may be found in the QV Help
HTH - Andy
Hi Naveen,
Refer Qlikview help and Qlikview reference manual those are the best source
Hi,
Refer Qlikview Reference Manual for details and example of all functions. The below some of the function types available in Qlikview
Regards,
Jagan.
Naveen,
Qlikview has 359 functions:
1. Front End (UI) and
2. Back End(Script)
They are grouped into 23 categories:
Inter-record |
Trigonometric and Hyperbolic |
Date & Time |
None |
Conditional |
String |
Mapping |
Color |
System |
Counter Functions |
Aggregation |
General Numeric |
Financial |
Formating |
Number Interpretation |
Mathematical constatns and Parameter free Functions |
Exponential and Logarithmic |
Rank |
Null |
Logical |
Range |
File |
Table |