Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
What are all the most important functions used in qlikview?
Follow the reference manual it contains all the functions and key words.
All the functions in backend as well as in front end used depend on the requirements.
Open help file for your reference
Thanks all for your reply....
Hi,
Go for Qlik reference manual you can find all details about the functions
Regards
Anand
Hi Anand,
I couldnt open the file..
Try to open the url and save the document in the new page
Regards,
Anand
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