topic Re: First Sorted Value in Qlik Learning Discussions

First Sorted Value

Fri, 12 Dec 2014 13:52:48 GMT

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

Re: First Sorted Value

francoiscave — Fri, 12 Dec 2014 14:01:54 GMT

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

Re: First Sorted Value

dickelsa — Fri, 12 Dec 2014 14:03:40 GMT

see thread below

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

Regards

Dick

Re: First Sorted Value

Fri, 12 Dec 2014 14:06:28 GMT

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

Re: First Sorted Value

its_anandrjs — Fri, 12 Dec 2014 14:07:38 GMT

Hi,

Check this post

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

Regards

Anand

Re: First Sorted Value

Fri, 12 Dec 2014 14:07:47 GMT

great ...Thank you.