Qlik Sense Show Min value in KPI if more than one value available

[Oguzhan]

Hello,

I have a question, I want to show most actual dates of a Milestone in a project in a KPI/ Textbox.

My dataset look like this but there are hundreds of data for each product_serial_no

Activity_ID	Processcode	Milestone_Text	Date	Productserial
A1000080	E.698	A20	17.11.2021	100
A1000200	F.598	A30	26.11.2021	101
A1000300	H.698	A40	28.11.2021	100
A1000360	I.598	A50	30.11.2021	100
A1000380	F.598	A30	26.11.2021	102

Everything works well if there are not more than a unique date value but for,

= min({<Processcode = {'F.598'}, Milestone_Text = {'A30'} >} Date) 

the result is ' - ' because there are two minimum dates one is for Productserial  =  '101' and for '102'.

But I expect ,no matter which Productserial, the most actual date and that is 26.11.2021, shown in the KPI / Textbox Diagramm.

Any Ideas how to solve this problem ? I am thankfull for any help incoming.

Best Regards

Oguzhan

[Rohan]

Try :

min({<product_serial_no=>}Date) as measure in the KPI

[Oguzhan]

That didn't work, how does this expression tells me wich Milestone is relevant. My Goal is to list the Milestone like below in a Textbox, but for milestone A30 i still get  -  as a result because there are two min dates for that milestone

Milestone    Date                   Product

A20                 17.11.2021      100

A30                 26.11.2021      101, 102

A40                 28.11.2021      100

A50                30.11.2021       100