topic Min/max in QlikView https://community.qlik.com/t5/QlikView/Min-max/m-p/148567#M26844 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>i have a pivot table with 1 dimensions: firm.</P><P>I need to retrieve the min value of costs: i create a text object with the formula --&gt;</P><P></P><P></P><P>=</P><P><B>num</B>((<B>min</B>(<B>aggr</B>(<B>sum</B>(<B>Cost</B>), <B>Firm</B>))), '#.##0,##', ',' , '.')</P><P>How can i display the name of the firm connected with the min value in the same formula ?</P><P>Thank you</P><P>Paolo</P><BR /><BR /> <BR /><BR /></BODY></HTML> Mon, 06 Jul 2009 18:48:35 GMT 2009-07-06T18:48:35Z Min/max https://community.qlik.com/t5/QlikView/Min-max/m-p/148567#M26844 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>i have a pivot table with 1 dimensions: firm.</P><P>I need to retrieve the min value of costs: i create a text object with the formula --&gt;</P><P></P><P></P><P>=</P><P><B>num</B>((<B>min</B>(<B>aggr</B>(<B>sum</B>(<B>Cost</B>), <B>Firm</B>))), '#.##0,##', ',' , '.')</P><P>How can i display the name of the firm connected with the min value in the same formula ?</P><P>Thank you</P><P>Paolo</P><BR /><BR /> <BR /><BR /></BODY></HTML> Mon, 06 Jul 2009 18:48:35 GMT https://community.qlik.com/t5/QlikView/Min-max/m-p/148567#M26844 2009-07-06T18:48:35Z Min/max https://community.qlik.com/t5/QlikView/Min-max/m-p/148568#M26845 <HTML><HEAD></HEAD><BODY><P></P><P>= <B>Firm &amp;</B> num((<B>min</B>(<B>aggr</B>(<B>sum</B>(<B>Cost</B>), <B>Firm</B>))), '#.##0,##', ',' , '.')</P><P style="font-weight: bold">Is this what you're after?</P><P>Jamie</P><BR /><BR /></BODY></HTML> Mon, 06 Jul 2009 19:11:52 GMT https://community.qlik.com/t5/QlikView/Min-max/m-p/148568#M26845 2009-07-06T19:11:52Z Min/max https://community.qlik.com/t5/QlikView/Min-max/m-p/148569#M26846 <HTML><HEAD></HEAD><BODY><P>I have tried but don't work. The name of the firm dont' appear.</P></BODY></HTML> Mon, 06 Jul 2009 19:20:51 GMT https://community.qlik.com/t5/QlikView/Min-max/m-p/148569#M26846 2009-07-06T19:20:51Z Min/max https://community.qlik.com/t5/QlikView/Min-max/m-p/148570#M26847 <HTML><HEAD></HEAD><BODY><P>Instead of a Text Object, you could use a Straight Table chart to calculate and display this information.</P><P>Set the expression to no totals, on Presentation Properties, set Max Number to 1, sort by the expression column Ascending, disallow Interactive Sort, remove the Caption, etc.</P><P>Phil Bishop</P></BODY></HTML> Mon, 06 Jul 2009 21:37:49 GMT https://community.qlik.com/t5/QlikView/Min-max/m-p/148570#M26847 2009-07-06T21:37:49Z