topic Sort and number dates by customer in QlikView

Sort and number dates by customer

Thu, 30 Jul 2009 19:59:05 GMT

I need sort dates and number by Cu_Id like Tr_Id, then use it for count days between the dates for the same Cu_id and add the number as a new column then view

- Average by Cu_Id

The new table should look like this.

Cu_Id	Tr_Id	Date	Date - Above(Date)	Sum by Cu_Id	Average by Cu_Id
1234	1	03/12/2006	0	0
1234	2	18/12/2006	15	15
1234	3	05/01/2007	18	33
1234	4	09/01/2007	4	37	9
2345	1	10/03/2009	0	0
2345	2	12/04/2009	33	33
2345	3	06/05/2009	24	57	19

Tks!

Sort and number dates by customer

Thu, 30 Jul 2009 20:43:22 GMT

Hi Shariel,

the part "Sum by Cu_Id" is finished.

For the second part "Average" I have no idea yet.

Rainer

Sort and number dates by customer

Fri, 31 Jul 2009 19:35:25 GMT

Hi Shariel,

here are the table you want to have.

Happy qlicking!

Rainer

Sort and number dates by customer

Tue, 04 Aug 2009 21:10:34 GMT

Thanks Rainer! it´s just i need, but one more question, i have two tables without the number "Tr_Id" how can i generate it or sort by client?

Regards!

Sort and number dates by customer

Wed, 05 Aug 2009 12:33:18 GMT

Shariel,

this is the only part in our script we used the field "Tr_Id". Instead of "Tr_Id" try to count the field "Date".

CountTrId:
Load
Cu_Id,
Count(Tr_Id) as CountedTrId
Resident RealData
Group By Cu_Id

Ia´m not sure if I understand your question correctly.

If possible prepare a short example of the tables you have.

So I and the other colleagues are able to thing about a solution.

Rainer