Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
“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
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
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
Thankyou, Matheus