utilisation of firstsortedvalue

[#1]

Hello,

I'm new to qlikview and i'm having trouble using firstsortedvalue.

This is what i'm working on:

CUSTOMER	PRODUCT	BUYING DATE
CUSTOMER 1	PRODUCT 1	22/11/2009
CUSTOMER 1	PRODUCT 2	24/05/2012
CUSTOMER 1	PRODUCT 3	12/02/2010
CUSTOMER 2	PRODUCT 1	13/07/2007
CUSTOMER 3	PRODUCT 1	30/04/2002
CUSTOMER 3	PRODUCT 2	01/04/2000
CUSTOMER 3	PRODUCT 3	08/08/2008

i would like to know the product that each customer bought in the first place.

So what i would like to see is:

CUSTOMER	PRODUCT
CUSTOMER 1	PRODUCT 1
CUSTOMER 2	PRODUCT 1
COSTOMER 3	PRODUCT 2

How should i do this?

Thanks a lot!

[swuehl · Accepted solution]

Create a chart with dimension CUSTOMER and as expression

=FirstSortedValue(PRODUCT, [BUYING DATE])

take care that buying date field has a numeric representation (i.e. is interpreted as date by QV).