Functions

Tue, 02 Dec 2014 09:22:49 GMT

What are all the most important functions used in qlikview?

Re: Functions

anbu1984 — Tue, 02 Dec 2014 09:25:50 GMT

QV10 Functions Cheatsheet.pdf

String Functions

Re: Functions

sujeetsingh — Tue, 02 Dec 2014 09:34:44 GMT

Follow the reference manual it contains all the functions and key words.

Re: Functions

Tue, 02 Dec 2014 10:30:31 GMT

All the functions in backend as well as in front end used depend on the requirements.

Open help file for your reference

Re: Functions

Tue, 02 Dec 2014 10:53:32 GMT

Thanks all for your reply....

Re: Re: Functions

its_anandrjs — Tue, 02 Dec 2014 11:25:42 GMT

Hi,

Go for Qlik reference manual you can find all details about the functions

Regards

Anand

Re: Re: Functions

Tue, 02 Dec 2014 12:16:45 GMT

Hi Anand,

I couldnt open the file..

Re: Re: Functions

its_anandrjs — Tue, 02 Dec 2014 12:26:56 GMT

Try to open the url and save the document in the new page

Regards,

Anand

Re: Functions

Anonymous — Tue, 02 Dec 2014 12:35:19 GMT

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

topic Re: Re: Functions in QlikView

Functions

Re: Functions

Re: Functions

Re: Functions

Re: Functions

Re: Re: Functions

Re: Re: Functions

Re: Re: Functions

Re: Functions