Qlik Community

Qlik Education Discussions

Discussion Board for collaboration related to Qlik Education.

Not applicable

First Sorted Value

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

1 Solution

Accepted Solutions
dickelsa
Contributor

Re: First Sorted Value

5 Replies
francoiscave
Contributor III

Re: First Sorted Value

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
Contributor

Re: First Sorted Value

Not applicable

Re: First Sorted Value

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

Re: First Sorted Value

Hi,

Check this post

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

Regards

Anand

Not applicable

Re: First Sorted Value

great ...Thank you.

Community Browser