topic Re: Function and its usages in QlikView

Function and its usages

prma7799 — Mon, 26 Jan 2026 18:19:17 GMT

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

Re: Function and its usages

tresB — Fri, 12 Dec 2014 05:57:01 GMT

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

its_anandrjs — Fri, 12 Dec 2014 06:02:38 GMT

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

Re: Function and its usages

prma7799 — Fri, 12 Dec 2014 06:08:37 GMT

Thanks Tresesco.

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

Regards

Re: Function and its usages

ashfaq_haseeb — Sun, 14 Dec 2014 07:24:34 GMT

Hi,

Check this

FirstSortedValue() Archives - QlikView Blog, QlikView Videos and Tips at QlikShare

Regards

ASHFAQ