Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
Umer1
Contributor
Contributor

KPI

“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

Labels (5)
1 Solution

Accepted Solutions
MatheusC
Specialist
Specialist

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 

Did you find a solution to your question? Mark the solution as accepted and if you found it useful, press the like button!

View solution in original post

2 Replies
MatheusC
Specialist
Specialist

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 

Did you find a solution to your question? Mark the solution as accepted and if you found it useful, press the like button!
Umer1
Contributor
Contributor
Author

Thankyou, Matheus