I'm new to qlikview and i'm having trouble using firstsortedvalue.
This is what i'm working on:
|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 1||PRODUCT 1|
|CUSTOMER 2||PRODUCT 1|
|COSTOMER 3||PRODUCT 2|
How should i do this?
Thanks a lot!