https://community.qlik.com/t5/QlikView/Get-Min-value-by-dimension-in-KPI/m-p/1774342#M591122 <P>if you want the min value to be displayed use this exprssion<BR />min(aggr(measurement, machine))<BR />if you want to display the machine name use this :<BR />firstsortedvalue (machine, aggr(measurement,machine))</P> Thu, 14 Jan 2021 11:40:03 GMT lironbaram 2021-01-14T11:40:03Z https://community.qlik.com/t5/QlikView/Get-Min-value-by-dimension-in-KPI/m-p/1774317#M591121 <P>Hi, I have some Master Item measurement, witch I use for bar chart and KPI. The measurement is SUM(.....). But this sum could be brake down by dimension machine. This I use in bar chart, where I use machine as dimension and same measurement. My question is, if I want to have another KPI, that portray the Min() value of this measurement by machine. (So the machine with lowest measurement) If I only do min(measurement,..) it will return the same value as previous KPI, because for him it is only one value, so min of one value is the same value. Any suggestions?</P> Thu, 14 Jan 2021 10:45:42 GMT https://community.qlik.com/t5/QlikView/Get-Min-value-by-dimension-in-KPI/m-p/1774317#M591121 TuckerSteven 2021-01-14T10:45:42Z https://community.qlik.com/t5/QlikView/Get-Min-value-by-dimension-in-KPI/m-p/1774342#M591122 <P>if you want the min value to be displayed use this exprssion<BR />min(aggr(measurement, machine))<BR />if you want to display the machine name use this :<BR />firstsortedvalue (machine, aggr(measurement,machine))</P> Thu, 14 Jan 2021 11:40:03 GMT https://community.qlik.com/t5/QlikView/Get-Min-value-by-dimension-in-KPI/m-p/1774342#M591122 lironbaram 2021-01-14T11:40:03Z