Skip to main content
Announcements
Qlik Community Office Hours, March 20th. Former Talend Community users, ask your questions live. SIGN UP
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

First Sorted Value

Hi all What is the use of First Sorted Value Function ?

1 Solution

Accepted Solutions
5 Replies
francoiscave
Partner - Creator III
Partner - Creator III

Hi Janaki,

See the Help QlikView description below:

firstsortedvalue ([ distinct ] expression [, sort-weight [, n ]])

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. Sort-weight should return a numeric value where the lowest value will render the corresponding value of expression to be sorted first. By preceding the sort-value expression with a minus sign, the function will return the last value instead. If more than one value of expression share the same lowest sort-order, the function will return NULL. By stating an n larger than 1, the nth value in order will be returned. If the word distinct occurs before the expression, all duplicates will be disregarded.

François

dickelsa
Creator
Creator

Not applicable
Author

Can you give me any real time example  ? that would be helpful ..thank you.

its_anandrjs

Hi,

Check this post

http://community.qlik.com/message/384704#384704

Regards

Anand

Not applicable
Author

great ...Thank you.