topic Re: FirstSortedValue() in QlikView

FirstSortedValue()

Fri, 24 Jun 2011 01:38:21 GMT

Hi all,

i am new to qlikview just want to know that

how FirstSortedValue() works in Qlikview... Can any one ive me a example ?

Load Customer,

firstsortedvalue(PurchasedArticle, OrderDate) as FirstProductBought from abc.csv

group by Customer;

???? i am unable to understand this through help also

Message was edited by: rohitkoul

FirstSortedValue()

Anonymous — Fri, 24 Jun 2011 03:27:18 GMT

Imagine you have the following table:

FieldA, FieldB

A, 3

B, 4

C, 1

D, 2

If you run a FirstSortedValue(FieldA, FieldB) you'll get the first sorted value from FieldA based on the sorting of FieldB. Value 1 is the first value for FieldB so the function will in this example return C.

FirstSortedValue()

Anonymous — Fri, 24 Jun 2011 04:07:19 GMT

In that example it loads the instance of the PurchasedArticle based on the earliest OrderDate, i.e. the first product bought.

FirstSortedValue()

Fri, 24 Jun 2011 04:34:58 GMT

Thanks Johannes

if if(FirstSortedValue( likes ,-record_date,8)<>'',FirstSortedValue( likes ,-record_date)-FirstSortedValue( likes ,-record_date,2))

now what about this numeric value?

Re: FirstSortedValue()

abhishek_bigdat — Wed, 16 Jul 2014 09:37:02 GMT

Go through this link

http://www.learnqlickview.com/first-sorted-value-function-in-qlikview/

Will help you learn it better.

Re: FirstSortedValue()

Fri, 21 Nov 2014 17:48:59 GMT

Hi Johannes

I woud like to get the last value for each customer.

If i use the firstSortedValue function, it return the first value but i need to get the last purchase for each customer.

For example

Customer orderDate

Miguel 21/01/2014

Jose 20/06/2013

Carlos 20/06/2013

Miguel 20/11/2014

I want the output table look like this

Customer orderDate

Miguel 20/11/2014

Jose 20/06/2013

Carlos 20/06/2013

Re: FirstSortedValue()

Wed, 02 Sep 2015 16:48:27 GMT

You can solve by

firstsortedvalue(Customer,-orderDate)

if we write - sign before the sort-weight i.e. orderDate here, it will return the last value.

Re: FirstSortedValue()

santoshrai — Sat, 19 Dec 2015 06:02:20 GMT

hi...Julisy...

I guess in your case only group by function will solve your purpose...to get desired out put...

try this

old:

LOAD customer,

orderdate

FROM

(ooxml, embedded labels, table is [group by]);

new:

LOAD

Distinct customer,

max (date (orderdate))

resident old

Group by customer;

DROP Table old;

Re: FirstSortedValue()

qlikview979 — Mon, 16 May 2016 06:39:17 GMT

Hi ,

I am not able to open this link. can anyone give with example.

Re: FirstSortedValue()

mvaugusto — Wed, 14 Dec 2016 17:09:16 GMT

Nice!

Re: FirstSortedValue()

prasadmundewadi — Tue, 10 Jan 2017 19:20:03 GMT

What happens if there are null values in the data. are those going to come first or those go to the end.

E.g.

FieldA, FieldB

A, 3

B, 4

C, //note FieldB has null for C

D, 2

Re: FirstSortedValue()

sonysree88 — Wed, 16 Aug 2017 10:22:30 GMT

We can able to suppress the nulls as per the measure filed

Re: FirstSortedValue()

ramcena306 — Sat, 11 Nov 2017 10:23:51 GMT

Hi Prasad,

In that case , if C= Null, then it returns D value. i,e. 2