Max Values

[asinghal0412]

Dear Qlik Community,

As you can see in the table below (Current Table), in the last field 'Status_MFG' we have multiple values. I want to limit it to one value corresponding to the 'max Calendar_ID' for each 'status_MFG' as seen in the 'Result Table'. Can someone help me?

Current Table:-

MFG_KPI_Generic_ID	MFG_KPI_ID	PROJECT_RECORD	HISTORY_MFG	CALENDAR_ID	status_MFG
AL-17788_9999999_2021-08-28	AL-17788	AL-3337	9999999	44436	SOP
AL-17788_1699025_2021-06-19	AL-17788	AL-3337	1699025	44366	MPT
AL-17788_1526206_2021-02-06	AL-17788	AL-3337	1526206	44233	PT
AL-17788_1526201_2021-02-06	AL-17788	AL-3337	1526201	44233	MPT
AL-17788_1409737_2020-12-12	AL-17788	AL-3337	1409737	44177	PT
AL-17788_1409733_2020-12-12	AL-17788	AL-3337	1409733	44177	MPT
AL-17788_1409649_2020-12-12	AL-17788	AL-3337	1409649	44177	PT
AL-17788_1397665_2020-12-05	AL-17788	AL-3337	1397665	44170	MPT
AL-17788_1396704_2020-12-05	AL-17788	AL-3337	1396704	44170	PT
AL-17788_1396700_2020-12-05	AL-17788	AL-3337	1396700	44170	MPT
AL-17788_1390967_2020-11-28	AL-17788	AL-3337	1390967	44163	PT
AL-17788_1390961_2020-11-28	AL-17788	AL-3337	1390961	44163	Open

Desired Result Table:

MFG_KPI_Generic_ID	MFG_KPI_ID	PROJECT_RECORD	HISTORY_MFG	CALENDAR_ID	status_MFG
AL-17788_9999999_2021-08-28	AL-17788	AL-3337	9999999	44436	SOP
AL-17788_1699025_2021-06-19	AL-17788	AL-3337	1699025	44366	MPT
AL-17788_1526206_2021-02-06	AL-17788	AL-3337	1526206	44233	PT
AL-17788_1390961_2020-11-28	AL-17788	AL-3337	1390961	44163	Open

[Taoufiq_Zarra]

@asinghal0412  can you elaborate

how the CALENDAR_ID does not appear all only 4

44163
44170
44177
44233
44366
44436

[asinghal0412]

Hi @Taoufiq_Zarra ,

The 4 Calendar ID table is the one that I want to achieve. My current table is the first one.

I hope the doubt is clear.

[Taoufiq_Zarra]

Hi @asinghal0412 

My question is how you get the second table from the first.

for example  for the case AL-17788_1526206_2021-02-06

[asinghal0412]

@Taoufiq_Zarra ,

I have not got the second table, I only have the First table.

I want to get the second table and I am asking this community if they can help me how to get the second table. I do not know.

Best,

Akash