topic How to find max Trans ID. in QlikView

How to find max Trans ID.

Wed, 25 Nov 2020 16:16:04 GMT

Hi All.

i need to find Max Trans ID of a customer at Max date for this i did group customer ID and Max Trans date.i got it but how to get Max Trans ID of a customer.

Thanks

Re: How to find max Trans ID.

Mon, 25 Jul 2016 17:20:59 GMT

use in you dimension customer and on expression use max(tran date).

Re: How to find max Trans ID.

Mon, 25 Jul 2016 17:25:50 GMT

Thank Sliva,

I need Max(Trans ID) and Max(Trans Date) of that customer

Re: How to find max Trans ID.

sunny_talwar — Mon, 25 Jul 2016 17:27:31 GMT

Like this?

Customer:

LOAD [Customer ID],

[Tran Date],

[Trans ID]

FROM

[Book1.xlsx]

(ooxml, embedded labels, table is Sheet1);

Customer_G:

LOAD [Customer ID],

Max(Date([Tran Date])) as Max_Trans_Date,

MaxString([Trans ID]) as Max_Trans_ID

Resident Customer

Group By [Customer ID], [Tran Date];

Re: How to find max Trans ID.

Mon, 25 Jul 2016 17:31:29 GMT

use maxstring(Trans ID)