Discussion Board for collaboration related to QlikView Deployment.
Anybody can have any documents on list Function and its usages which is frequently used in Qlikview data modelling.
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.
firstsortedvalue(PurchasedArticle, OrderDate) as FirstProductBought from abc.csv
group by Customer;
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).
From some of this thread you can found some definitions
I know that function present in help but I want related docs for it.
FirstSortedValue() Archives - QlikView Blog, QlikView Videos and Tips at QlikShare