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

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

default_the_pig — Tue, 03 May 2022 16:08:45 GMT

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?

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

vinieme12 — Tue, 03 May 2022 17:00:03 GMT

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)