topic Re: How to show 1st three in Minimum values in Straight table? in QlikView https://community.qlik.com/t5/QlikView/How-to-show-1st-three-in-Minimum-values-in-Straight-table/m-p/356237#M1172331 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>1. Go to the properties of Straight Table and tick on the Maximum Number check box and put there 3 then</P><P>2.sort your expression in Ascending order in Sort tab.</P><P></P><P>then you will get 3 rows with min values.</P><P></P><P>Regards</P><P>Apurva </P></BODY></HTML> Mon, 18 Jun 2012 07:22:05 GMT 2012-06-18T07:22:05Z How to show 1st three in Minimum values in Straight table? https://community.qlik.com/t5/QlikView/How-to-show-1st-three-in-Minimum-values-in-Straight-table/m-p/356236#M1172330 <HTML><HEAD></HEAD><BODY><P>Hi Everyone,</P><P></P><P>I have two fileds like below</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" width="128"><TBODY><TR><TD class="xl68" height="20" width="64">Name</TD><TD class="xl68" width="64">Cost</TD></TR><TR><TD height="20">AAA</TD><TD align="right">100</TD></TR><TR><TD height="20">BBB</TD><TD align="right">200</TD></TR><TR><TD height="20">CCC</TD><TD align="right">300</TD></TR><TR><TD height="20">DDD</TD><TD align="right">400</TD></TR><TR><TD height="20">EEE</TD><TD align="right">500</TD></TR><TR><TD height="20">FFF</TD><TD align="right">600</TD></TR></TBODY></TABLE><P></P><P>I want to show first 3 minimuvalues in straight table. ie AAA-100,BBB-200, CCC-300</P><P></P><P>Can anyone suggest me how to do this?</P><P></P><P>Best,</P><P>Siva</P></BODY></HTML> Mon, 18 Jun 2012 04:26:24 GMT https://community.qlik.com/t5/QlikView/How-to-show-1st-three-in-Minimum-values-in-Straight-table/m-p/356236#M1172330 siva_boggarapu 2012-06-18T04:26:24Z Re: How to show 1st three in Minimum values in Straight table? https://community.qlik.com/t5/QlikView/How-to-show-1st-three-in-Minimum-values-in-Straight-table/m-p/356237#M1172331 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>1. Go to the properties of Straight Table and tick on the Maximum Number check box and put there 3 then</P><P>2.sort your expression in Ascending order in Sort tab.</P><P></P><P>then you will get 3 rows with min values.</P><P></P><P>Regards</P><P>Apurva </P></BODY></HTML> Mon, 18 Jun 2012 07:22:05 GMT https://community.qlik.com/t5/QlikView/How-to-show-1st-three-in-Minimum-values-in-Straight-table/m-p/356237#M1172331 2012-06-18T07:22:05Z