Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

utilisation of firstsortedvalue

Hello,

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

This is what i'm working on:

CUSTOMERPRODUCTBUYING DATE
CUSTOMER 1PRODUCT 122/11/2009
CUSTOMER 1PRODUCT 224/05/2012
CUSTOMER 1PRODUCT 312/02/2010
CUSTOMER 2PRODUCT 113/07/2007
CUSTOMER 3 PRODUCT 130/04/2002
CUSTOMER 3PRODUCT 201/04/2000
CUSTOMER 3PRODUCT 308/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:

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

How should i do this?

Thanks a lot!

1 Solution

Accepted Solutions
MVP
MVP

Re: utilisation of firstsortedvalue

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).

1 Reply
MVP
MVP

Re: utilisation of firstsortedvalue

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).

Community Browser