topic Top 10 low values in QlikView https://community.qlik.com/t5/QlikView/Top-10-low-values/m-p/665340#M1074194 <HTML><HEAD></HEAD><BODY><P>Hi</P><P>i want to display top 10 lowest value based on sales</P><P></P><P>any one help? thanks,....</P></BODY></HTML> Mon, 28 Jul 2014 12:37:02 GMT arulsettu 2014-07-28T12:37:02Z Top 10 low values https://community.qlik.com/t5/QlikView/Top-10-low-values/m-p/665340#M1074194 <HTML><HEAD></HEAD><BODY><P>Hi</P><P>i want to display top 10 lowest value based on sales</P><P></P><P>any one help? thanks,....</P></BODY></HTML> Mon, 28 Jul 2014 12:37:02 GMT https://community.qlik.com/t5/QlikView/Top-10-low-values/m-p/665340#M1074194 arulsettu 2014-07-28T12:37:02Z Re: Top 10 low values https://community.qlik.com/t5/QlikView/Top-10-low-values/m-p/665341#M1074195 <HTML><HEAD></HEAD><BODY><P>Something like below</P><P></P><P>1)</P><P>Dimension</P><P>Customer</P><P></P><P>Expression<BR />SUM({&lt;Customer = {"=Rank(-SUM(Sales),4)&lt;=10"}&gt;}Sales)</P><P></P><P></P><P>2)</P><P>Dimension</P><P>Customer</P><P></P><P>Expression </P><P>SUM(Sales)</P><P></P><P>Dimension Limits</P><P>Tick Restrict which values are ....</P><P>Show Only Smallest 10 Values</P><P>Untick Show Others</P><P></P><P></P><P>3)</P><P>Calculated Dimension</P><P>=IF(Aggr(Rank(-SUM(Sales),4),Customer)&lt;=10,Customer)</P><P>Tick Suppress When Value is NULL</P><P></P><P>Expression</P><P>SUM(Sales)</P></BODY></HTML> Mon, 28 Jul 2014 12:38:57 GMT https://community.qlik.com/t5/QlikView/Top-10-low-values/m-p/665341#M1074195 MK_QSL 2014-07-28T12:38:57Z