- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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).
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Thanks Tresesco.
I know that function present in help but I want related docs for it.
Regards
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi,
Check this
FirstSortedValue() Archives - QlikView Blog, QlikView Videos and Tips at QlikShare
Regards
ASHFAQ