topic Re: Get name of the key with max date in App Development

Get name of the key with max date

Imbue20 — Wed, 19 Jul 2023 17:36:32 GMT

Required is the Name of the key with Max date

th Max dat

Re: Get name of the key with max date

BrunPierre — Wed, 19 Jul 2023 18:01:10 GMT

This can be one way.

Dimensions: Key & Date

Measure: Aggr(FirstSortedValue(Name,-Date), Key)

Re: Get name of the key with max date

Imbue20 — Thu, 20 Jul 2023 02:25:24 GMT

Thanks Brun ,

But this didn't solve my query, if I tried this

Firstsortedvalue(Name,-aggr(Date,Key))

I am getting name whose key is having only 1 record, but if there are 2-3 records for that key am not getting any value.

REGARDS.

Re: Get name of the key with max date

PrashantSangle — Thu, 20 Jul 2023 05:13:37 GMT

where do you want this?? in front end or back end??

Re: Get name of the key with max date

PrashantSangle — Thu, 20 Jul 2023 05:29:44 GMT

try this code

Test:

Load *, Key&'_'&new_Date as max_key_date;

Load Name,Key,Date(Date#(Date,'DD/MM/YYYY')) as new_Date inline [

Name, Key, Date

SK153, AKU_KK, 7/11/2023

SK150, AKU_KK, 7/4/2023

SK981, AKU_KK, 3/7/2023

SK154, AKU_KU, 7/4/2023

SK982, AKU_KU, 3/7/2023

];

NoConcatenate

max_key_date:

Load Key&'_'&Date(max_date) as max_key_date;

Load Key,

max(new_Date) as max_date

Resident Test

Group by Key;

Left Join

Final:

Load Name, max_key_date Resident Test

;

drop table Test;

Re: Get name of the key with max date

Imbue20 — Thu, 20 Jul 2023 05:51:28 GMT

Hi Prashant,

I need it back end

Re: Get name of the key with max date

Imbue20 — Thu, 20 Jul 2023 05:52:44 GMT

Can you help me to achieve this in front end ?

Re: Get name of the key with max date

PrashantSangle — Thu, 20 Jul 2023 06:29:50 GMT

in back end. Logic which I provided in my earlier reply will work.

For Front end what you want to do? From earlier logic remove Left join part and use that max_key_date table for flagging and use that flag in front end

Re: Get name of the key with max date

Imbue20 — Thu, 20 Jul 2023 06:49:26 GMT

I want to make these Names as default selection with i open the sheet in front end.