Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for 
Search instead for 
Did you mean: 
asinghal0412
Partner
Partner

Max Values

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_IDMFG_KPI_IDPROJECT_RECORDHISTORY_MFGCALENDAR_IDstatus_MFG
AL-17788_9999999_2021-08-28AL-17788AL-3337999999944436SOP
AL-17788_1699025_2021-06-19AL-17788AL-3337169902544366MPT
AL-17788_1526206_2021-02-06AL-17788AL-3337152620644233PT
AL-17788_1526201_2021-02-06AL-17788AL-3337152620144233MPT
AL-17788_1409737_2020-12-12AL-17788AL-3337140973744177PT
AL-17788_1409733_2020-12-12AL-17788AL-3337140973344177MPT
AL-17788_1409649_2020-12-12AL-17788AL-3337140964944177PT
AL-17788_1397665_2020-12-05AL-17788AL-3337139766544170MPT
AL-17788_1396704_2020-12-05AL-17788AL-3337139670444170PT
AL-17788_1396700_2020-12-05AL-17788AL-3337139670044170MPT
AL-17788_1390967_2020-11-28AL-17788AL-3337139096744163PT
AL-17788_1390961_2020-11-28AL-17788AL-3337139096144163Open

 

Desired Result Table:

MFG_KPI_Generic_IDMFG_KPI_IDPROJECT_RECORDHISTORY_MFGCALENDAR_IDstatus_MFG
AL-17788_9999999_2021-08-28AL-17788AL-3337999999944436SOP
AL-17788_1699025_2021-06-19AL-17788AL-3337169902544366MPT
AL-17788_1526206_2021-02-06AL-17788AL-3337152620644233PT
AL-17788_1390961_2020-11-28AL-17788AL-3337139096144163Open
4 Replies
Taoufiq_Zarra

@asinghal0412  can you elaborate

how the CALENDAR_ID does not appear all only 4

44163
44170
44177
44233
44366
44436

Regards,
Taoufiq ZARRA

"Please LIKE posts and "Accept as Solution" if the provided solution is helpful "

(you can mark up to 3 "solutions") 😉
asinghal0412
Partner
Partner
Author

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

Regards,
Taoufiq ZARRA

"Please LIKE posts and "Accept as Solution" if the provided solution is helpful "

(you can mark up to 3 "solutions") 😉
asinghal0412
Partner
Partner
Author

@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