Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

Highlighted
prma7799
Honored Contributor III

Function and its usages

Hi Experts,

Anybody can have any documents on list Function and its usages which is frequently used in Qlikview data modelling.

Like:

FirstSortedValue :-

Returns the first value of expression sorted by corresponding sort-weight when expression is iterated over a number of records as defined by a group by clause.

Example:

Load Customer,

firstsortedvalue(PurchasedArticle, OrderDate) as FirstProductBought from abc.csv

group by Customer;

Thanks,

Prashant

Tags (4)
Labels (2)
4 Replies
MVP
MVP

Re: Function and its usages

Some of the fucntions I use frequently are:

Sum, Count, Concat, FirstSortedValue, Dual, Max, Maxstring, Aggr, Date, Date#, SubField,  Mid, Index, substringcount, Intervalmatch, hierarchy, applymap, crosstable,valuelist, valueloop, peek, above, iterno, rangesum, num, floor, ceil, match, wildmatch, pick.... (to mention few)

search them in the reference manual or help(open qv desktop -> f1).

Re: Function and its usages

Hi,

From some of this thread you can found some definitions

http://community.qlik.com/message/591156#591156

http://community.qlik.com/docs/DOC-6907

Regards

Anand

prma7799
Honored Contributor III

Re: Function and its usages

Thanks Tresesco.

I know that function present in help but I want related docs for it.

Regards

Re: Function and its usages