Display Max transaction or max tran date in calculated dimension

[Anonymous]

Hi Guys,

     Assuming i have this table.

CCTYPE	TranNo	amount	TranDate
K902329AB	2	1000	01/02/2010
K902329AB	4	1000	02/02/2010
K902329AB	7	1000	05/02/2010
K902330AB	1	1000	11/02/2010
K902330AB	2	1000	12/02/2010
K902330AB	5	1000	13/02/2010
K902331AC	1	1000	22/02/2010
K902331AC	3	1000	23/02/2010
K902331AC	4	1000	24/02/2010
K902331AC	6	1000	25/02/2010

I'm trying to achieve these result in calculated dimension as per below in pivot table or straight table.

1st desired result

CCTYPE	Max(tranno)	=SUM(Amount)
K902329AB	7	3000
K902330AB	5	3000
K902331AC	6	4000

2nd Desired result

CCTYPE	date of Max(tranno)	=SUM(Amount)
K902329AB	05/02/2010	3000
K902330AB	13/02/2010	3000
K902331AC	25/02/2010	4000

Any idea how?

[Anonymous]

Say if the table for the transaction is Many to Many?  the firstsortedvalue cant work?

Later i will try to replicate using a few samples and see if this can be done.

[Anonymous]

hi, i did load a sample of the data in new to qliksense,

can u access it and see how the firstsortedvalue can work in that many to one or many to many data set???