topic Resident Load Last Transaction & Corresponding Details in QlikView

Resident Load Last Transaction & Corresponding Details

Thu, 14 Aug 2014 08:01:37 GMT

Morning All,

I have an Excel table that I am trying to load into QlikView. It has the columns Date, Customer No., Balance On Act. and a number of other descriptive columns.

I am looking for assistance with a resident load which will pick 1. Distinct Customer number, 2. Last Date recorded, 3. Balance as at that date, i.e. the balance that corresponds with that date, and all other descriptive columns relating to that date.

Many thanks

Re: Resident Load Last Transaction & Corresponding Details

jagan — Thu, 14 Aug 2014 08:47:56 GMT

Hi,

Try like this

Data:

LOAD

Date([Last Date]) AS DateFormatted

FROM DataSource;

INNER JOIN

LOAD

[Customer Number],

Date(Max(DateFormatted)) AS DateFormatted

RESIDENT Data

GROUP BY [Customer Number];

Hope this helps you.

Regards,

Jagan.

Re: Resident Load Last Transaction & Corresponding Details

Thu, 14 Aug 2014 11:23:48 GMT

Thanks Jagan,

Spot on, much appreciated.