Getting Max date (YYYYMM format) for each account number in Qlik on front end

[default_the_pig]

Hello! Currently, we have a dashboard that displays account information. However, it is bringing back dupes. We have a request from the stakeholder to get rid of the dupes. Basically, we want to keep the latest record based on time month key (YYYYMM format) in this case for each account number. It is possible that the account numbers could have different latest time month keys. 

Is it possible to do this on the front end as a measure or a dimension and use that as a filter? Basically filter out the dupes on the front end. If so, how? 

[vinieme12 · Accepted solution]

If you need to use it as a filter I would suggest you create a new field in your load script

Left join(TableA)

Load Accountnumber,max(DateField) as maxdate

Resident TableA

Group by Accountnumber;

On the front end you can try below 

Aggr(Max(DateField),AccountNumber)