topic Re: How to solve this?? in QlikView

How to solve this??

ecabanas — Thu, 17 Sep 2015 08:45:41 GMT

I have a table with my sales like:

and I want to create a table with the customer and the date of his first order like this:

Anyone knows how to do it?

Many many thank's

Eduard

alexandros17 — Thu, 17 Sep 2015 08:53:14 GMT

if your table's name is for example MyTab then:

Load Customer. Min(Date) as FirstOrder resident myTab Group by Customer;

let me know

MK_QSL — Thu, 17 Sep 2015 08:54:39 GMT

Create a Straight Table

Dimension

Customer

Expression

Date(Min(Date))

ecabanas — Thu, 17 Sep 2015 09:21:21 GMT

Great!!! many thank's