Skip to main content
Announcements
Qlik Acquires Upsolver to Advance Iceberg Solutions: READ MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
prma7799
Master 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

Labels (2)
4 Replies
tresesco
MVP

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
Master III
Author

Thanks Tresesco.

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

Regards