Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

diff functions

hi can u say tell me diff types of

UI FUNCTIONS and  script level functions

thanks

6 Replies
Not applicable

Re: diff functions

Refer the below link.

Qlikview Functions

senpradip007
Valued Contributor III

Re: diff functions

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

Partner
Partner

Re: diff functions

HI Naveen,

all of listed may be found in the QV Help

HTH - Andy

Re: diff functions

Hi Naveen,

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

MVP & Luminary
MVP & Luminary

Re: diff functions

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
Honored Contributor

Re: diff functions

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