Hi Jana,
Below are mostly used functions in qlikview:
Date Functions
Aggregate functions
sum([distinct]expression)
min( expression[, rank] )
max( expression[, rank] )
only(expression )
mode(expression )
firstsortedvalue ([ distinct ] expression [, sort-weight [, n ]])
concat ([ distinct ] expression [, delimiter [, sort-weight]])
count([distinct ] expression | * )
String Functions
mid(s, n1[, n2 ])
index(s1 , s2[ , n])
trim(s )
subfield(s, 'delimiter' [ , index ] )
KeepChar(s1 , s2)
PurgeChar(s1, s2)
capitalize(s )
Replace(s, fromstring ,tostring)
Chart Range Functions
rangesum(expr1 [ , expr2, ... exprN ])
rangeavg(expr1 [ , expr2, ... exprN ])
rangecount(expr1 [ , expr2, ... exprN ] )
Chart Inter Record Functions
above([ total ] expression [ , offset [,n ]])
below([ total ] expression [ , offset [,n ]])
Numeric functions
div(x1 , x2)
mod(x1 , x2)
ceil(x [ , base [ , offset ]])
floor(x [ , base [ , offset ]])
round(x [ , step [ , offset ]])
Counter functions
RecNo( )
RowNo( )
IterNo( )
autonumber(expression[ , AutoID])
autonumberhash128(expression {, expression})
autonumberhash256(expression {, expression})
fieldvaluecount(fieldname)
Conditional functions
if(condition , then , else)
alt(case1[ , case2 , case3 , ...] , else)
pick(n, expr1[ , expr2,...exprN]
match( str, expr1 [ , expr2,...exprN ] )
class(expression, interval [ , label [ , offset ]])
Formatting functions
Interpretation Functions
Num#
Date#
Dual
Money#
Timestamp#
Interval#
Text
Inter Record Functions
exists(field [ , expression ] )
previous(expression )
peek(fieldname [ , row [ , tablename ] ] )
lookup(fieldname, matchfieldname, matchfieldvalue [, tablename])
Mapping Functions
applymap('mapname', expr [ , defaultexpr ] )
mapsubstring('mapname', expr)
etc.
Please Refer to qlikview help file (F1), For more functions and their explanation
Regards
Neetha
