Re: diff functions

senpradip007 — Wed, 08 Jul 2015 07:16:05 GMT

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

topic Re: diff functions in QlikView

diff functions

Re: diff functions

Re: diff functions

Re: diff functions

Re: diff functions

Re: diff functions

Re: diff functions