Function and its usages

[prma7799]

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

[tresesco]

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

[its_anandrjs]

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]

Thanks Tresesco.

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

Regards

[ashfaq_haseeb]

Hi,

Check this

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

Regards

ASHFAQ