1 Reply Latest reply: Feb 7, 2013 12:40 PM by Stefan Wühl RSS

    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!