topic Re: WHat is the FirstSortedValue() in QlikView

WHat is the FirstSortedValue()

nikhilgarg — Mon, 22 Sep 2014 10:25:44 GMT

Hey,

WHat is the FirstSortedValue() ?? Can anyone explain with example ??

Thanks

Re: WHat is the FirstSortedValue()

Mon, 22 Sep 2014 10:27:56 GMT

firstsortedvalue([{set_expression}][ distinct ] [ total [<fld {, fld}>]] expression [, sort_weight [, n]])

returns the first value of expression sorted by corresponding sort-weight when expression is iterated over the chart dimension(s). 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, you will get the nth value in order.

Examples:

firstsortedvalue ( PurchasedArticle, OrderDate )

firstsortedvalue ( PurchasedArticle, -OrderDate, 2 )

firstsortedvalue ( A/B, X*Y/3 )

firstsortedvalue ( distinct PurchasedArticle, OrderDate )

firstsortedvalue ( total PurchasedArticle, OrderDate )

firstsortedvalue ( total <Grp> PurchasedArticle, OrderDate )

Re: WHat is the FirstSortedValue()

Mon, 22 Sep 2014 10:29:13 GMT

see link

FirstSortedValue()

Re: WHat is the FirstSortedValue()

ashfaq_haseeb — Mon, 22 Sep 2014 10:32:25 GMT

Hi,

Check this

http://qlikshare.com/tag/firstsortedvalue/

Regards

ASHFAQ

Re: WHat is the FirstSortedValue()

Mon, 22 Sep 2014 10:37:33 GMT

it will give the first value of expression based on the sort wait .sort wait should be numeric

ex:

table1:

table2:

if u write the expression firstsortedvalue(table1,table2) output is D i.e is 4

if u go for firstsortedvalue(table1,-table2) then lowest value A i.e is 1

Re: WHat is the FirstSortedValue()

nikhilgarg — Mon, 22 Sep 2014 10:41:07 GMT

HEy,

If i use

firstsortedvalue ( PurchasedArticle, OrderDate )

then does it return PurchasedArticle value on basis of Minimum OrderDate ??

And if i use firstsortedvalue ( PurchasedArticle, -OrderDate )

then does it return PurchasedArticle value on basis of Maximum OrderDate ??

Is it so ??

Re: WHat is the FirstSortedValue()

Mon, 22 Sep 2014 10:43:38 GMT

if u use - symbol then it gives minimum value

if u have no symbol then it gives maximum value

Re: WHat is the FirstSortedValue()

Mon, 22 Sep 2014 10:57:20 GMT

firstsortedvalue(ValueField, WeightField)

It will give you the first sorted value of the ValueField depending on the specified WeightField.

eg. firstsortedvalue(AccountBalance,ReportDate)

This will return the value of AccountBalance on the first date as per the date variable.

Hope this helps

Re: WHat is the FirstSortedValue()

nikhilgarg — Mon, 22 Sep 2014 11:04:18 GMT

Hey,

firstsortedvalue(AccountBalance,ReportDate)

will return AccountBalance corresponding to Maximum Report Date ??

Re: WHat is the FirstSortedValue()

Mon, 22 Sep 2014 11:42:27 GMT

no, it will return for minimum report date, if you want it to return for maximum report date then you can edit the expression as firstsortedvalue(AccountBalance,-ReportDate)

and the variable for weight may not necessarily be a date variable, you can use any other variable also.

Re: WHat is the FirstSortedValue()

Mon, 22 Sep 2014 12:01:15 GMT

If you got your answer, kindly mark helpful or correct answer and close the post.

Regards

Re: WHat is the FirstSortedValue()

Mon, 22 Sep 2014 12:36:25 GMT

hi,

firstsortedvalue () , is nothing but we can work on two perameters .

1). string value

2). numeric value,(only stright table & pivot table) it ;ll work.

For Example:

1).firstsortedvalue(name,-sales) it 'll display the lowest value in the sales

2).firstsortedvalue(name,sales) it 'll display the highest value in the sales

Re: WHat is the FirstSortedValue()

Mon, 22 Sep 2014 12:53:17 GMT

nerchukuntunnara leka working in any org?

Re: WHat is the FirstSortedValue()

Mon, 22 Sep 2014 12:56:47 GMT

em enduku ..............

Re: WHat is the FirstSortedValue()

Mon, 22 Sep 2014 12:57:28 GMT

urkane brother

Re: WHat is the FirstSortedValue()

jerem1234 — Mon, 22 Sep 2014 13:51:48 GMT

Just to clear up the use of the "-" symbol in the second parameter. When the negative symbol is used, it will sort the maximum to be first. If it is left out, it sorts the minimum to be first.

So for something like:

Group Day Value

A 1 100

A 2 75

A 3 20

if we do:

FirstSortedValue(Day, Value) ------- returns 3

FirstSortedValue(Day, -Value) ------- returns 1

From Qlikview Help:

firstsortedvalue([{set_expression}][ distinct ] [ total [<fld {, fld}>]] expression [, sort_weight [, n]])

returns the first value of expression sorted by corresponding sort-weight when expression is iterated over the chart dimension(s). 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, you will get the nth value in order.

Hope this helps!