Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

diff functions

hi can u say tell me diff types of

UI FUNCTIONS and  script level functions

thanks

6 Replies
Not applicable
Author

Refer the below link.

Qlikview Functions

senpradip007
Specialist III
Specialist III

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( )

awhitfield
Partner - Champion
Partner - Champion

HI Naveen,

all of listed may be found in the QV Help

HTH - Andy

avinashelite

Hi Naveen,

Refer Qlikview help and Qlikview reference manual those are the best source

jagan
Luminary Alumni
Luminary Alumni

Hi,

Refer Qlikview Reference Manual for details and example of all functions.  The below some of the function types available in Qlikview

  • Ø String Functions
  • Ø Math Functions
  • Ø Aggregation Functions
  • Ø Conditional Functions
  • Ø Color Functions
  • Ø Date and Time Functions
  • Ø Counter Functions
  • Ø Exponential and Logarithmic Functions
  • Ø Formatting Functions
  • Ø General Numeric Functions
  • Ø Inter record Functions
  • Ø Logical Functions
  • Ø Mapping Functions
  • Ø Number Interpretation Functions
  • Ø Ranking Functions
  • Ø Range Functions
  • Ø System Functions
  • Ø Table Functions
  • Ø File Functions

Regards,

Jagan.

Siva_Sankar
Master II
Master II

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