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

FirstSortedValue()

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

1 Solution

Accepted Solutions
Anonymous
Not applicable
Author

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

View solution in original post

12 Replies
Anonymous
Not applicable
Author

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.

Anonymous
Not applicable
Author

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

Not applicable
Author

Thanks Johannes

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

now what about this numeric value?

abhishek_bigdat
Contributor III
Contributor III

Go through this link

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

Will help you learn it better.

Not applicable
Author

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

Not applicable
Author

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.

santoshrai
Contributor II
Contributor II

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;

qlikview979
Specialist
Specialist

Hi ,

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

mvaugusto
Creator
Creator

Nice!