KPI

[Umer1]

“min(aggr(minvalue,[shed.id], medvacname”

Above expression is use to get the minimum loss by the medicine
in this expression ‘minvalue’ is a master measure which is

if(Min(aggr(Sum(Cumm_CulledMedicine)+sum(Cumm_MortalityMedicine),[shed.id],medvacname))>0,min(aggr(Sum(Cumm_CulledMedicine)+sum(Cumm_MortalityMedicine),[shed.id],medvacname)))

What I actually wants a name associated with the above expression(“min(aggr(minvalue,[shed.id], medvacname))”) but it is not working and I did not understand the problem. How can I get the medvacname where the minvalue in minimum but it should be greater than  zero

[MatheusC · Accepted solution]

Maybe using the FirstSortedValue function

https://help.qlik.com/pt-BR/sense/February2024/Subsystems/Hub/Content/Sense_Hub/ChartFunctions/Basic...

FirstSortedValue(medvacname,aggr(minvalue,medvacname))

Regarts, Matheus 

[Umer1 · Accepted solution]

Thankyou, Matheus