Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
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