topic Re: Get Min() value by dimension in KPI in QlikView https://community.qlik.com/t5/QlikView/Get-Min-value-by-dimension-in-KPI/m-p/5336#M608162 <HTML><HEAD></HEAD><BODY><P><SPAN style="color: #ff0000;">Min( AGGR</SPAN> (&nbsp; YourExpression&nbsp; , DimensionToAggregateBy <SPAN style="color: #ff0000;">) )</SPAN></P></BODY></HTML> Tue, 23 Jan 2018 09:38:39 GMT vinieme12 2018-01-23T09:38:39Z Get Min() value by dimension in KPI https://community.qlik.com/t5/QlikView/Get-Min-value-by-dimension-in-KPI/m-p/5335#M608161 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have some Master Item measurement, witch I use for bar chart and KPI.</P><P></P><P>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. </P><P></P><P>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)</P><P></P><P>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.</P><P></P><P>Any suggestions?</P><P></P><P>Marko Zadravec</P></BODY></HTML> Tue, 23 Jan 2018 09:33:58 GMT https://community.qlik.com/t5/QlikView/Get-Min-value-by-dimension-in-KPI/m-p/5335#M608161 Anonymous 2018-01-23T09:33:58Z Re: Get Min() value by dimension in KPI https://community.qlik.com/t5/QlikView/Get-Min-value-by-dimension-in-KPI/m-p/5336#M608162 <HTML><HEAD></HEAD><BODY><P><SPAN style="color: #ff0000;">Min( AGGR</SPAN> (&nbsp; YourExpression&nbsp; , DimensionToAggregateBy <SPAN style="color: #ff0000;">) )</SPAN></P></BODY></HTML> Tue, 23 Jan 2018 09:38:39 GMT https://community.qlik.com/t5/QlikView/Get-Min-value-by-dimension-in-KPI/m-p/5336#M608162 vinieme12 2018-01-23T09:38:39Z Re: Get Min() value by dimension in KPI https://community.qlik.com/t5/QlikView/Get-Min-value-by-dimension-in-KPI/m-p/1765090#M608163 <P>If dimension was a cycle group and we want to have aggr for each part of group how wee could get this?</P> Sun, 29 Nov 2020 07:08:22 GMT https://community.qlik.com/t5/QlikView/Get-Min-value-by-dimension-in-KPI/m-p/1765090#M608163 marjan_it 2020-11-29T07:08:22Z