topic Re: Top 5 & Bottom 5 Values in QlikView https://community.qlik.com/t5/QlikView/Top-5-Bottom-5-Values/m-p/995706#M967151 <HTML><HEAD></HEAD><BODY><P>Sorry, if you need it inside a graphe please use Dimension Limits as <A href="https://community.qlik.com/qlik-users/95643">akrepistman</A>‌ told</P></BODY></HTML> Mon, 05 Oct 2015 13:23:02 GMT Clever_Anjos 2015-10-05T13:23:02Z Top 5 & Bottom 5 Values https://community.qlik.com/t5/QlikView/Top-5-Bottom-5-Values/m-p/995701#M967146 <HTML><HEAD></HEAD><BODY><P>Hi Experts,</P><P></P><P>I want top 5 and bottom 5 customers. How to write the expression</P><P>Please help me</P><P></P><P></P><P></P><P>Thanks in Advance</P></BODY></HTML> Mon, 05 Oct 2015 12:20:36 GMT https://community.qlik.com/t5/QlikView/Top-5-Bottom-5-Values/m-p/995701#M967146 2015-10-05T12:20:36Z Re: Top 5 & Bottom 5 Values https://community.qlik.com/t5/QlikView/Top-5-Bottom-5-Values/m-p/995702#M967147 <HTML><HEAD></HEAD><BODY><P>There´s a function called FirstSortedValue that can do what you need</P><P></P><P>Bottom customers:</P><P>FirstSortedValue(Customer, Aggr(Sum(Sales),Customer),1)</P><P><SPAN style="font-size: 13.3333px; line-height: 1.5em;">FirstSortedValue(Customer, Aggr(Sum(Sales),Customer),2)</SPAN></P><P><SPAN style="font-size: 13.3333px; line-height: 1.5em;">...<BR /></SPAN></P><P><SPAN style="line-height: 1.5em; font-size: 13.3333px;">FirstSortedValue(Customer, Aggr(Sum(Sales),Customer),5)</SPAN></P><P><SPAN style="line-height: 1.5em; font-size: 13.3333px;"><BR /></SPAN></P><P style="font-size: 13.3333px;">Topcustomers:</P><P style="font-size: 13.3333px;">FirstSortedValue(Customer, -Aggr(Sum(Sales),Customer),1)</P><P style="font-size: 13.3333px;"><SPAN style="font-size: 13.3333px;">FirstSortedValue(Customer, -Aggr(Sum(Sales),Customer),2)</SPAN></P><P style="font-size: 13.3333px;"><SPAN style="font-size: 13.3333px;">...<BR /></SPAN></P><P style="font-size: 13.3333px;"><SPAN style="font-size: 13.3333px;">FirstSortedValue(Customer, -Aggr(Sum(Sales),Customer),5)</SPAN></P></BODY></HTML> Mon, 05 Oct 2015 12:44:51 GMT https://community.qlik.com/t5/QlikView/Top-5-Bottom-5-Values/m-p/995702#M967147 Clever_Anjos 2015-10-05T12:44:51Z Re: Top 5 & Bottom 5 Values https://community.qlik.com/t5/QlikView/Top-5-Bottom-5-Values/m-p/995703#M967148 <HTML><HEAD></HEAD><BODY><P style="font-size: 13.3333px;">Hi Abhi,</P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;">Please check my <A href="https://community.qlik.com/docs/DOC-9265">Firstsortedvalue Vs FirstValue Example</A></P></BODY></HTML> Mon, 05 Oct 2015 12:57:37 GMT https://community.qlik.com/t5/QlikView/Top-5-Bottom-5-Values/m-p/995703#M967148 qlikviewwizard 2015-10-05T12:57:37Z Re: Top 5 & Bottom 5 Values https://community.qlik.com/t5/QlikView/Top-5-Bottom-5-Values/m-p/995704#M967149 <HTML><HEAD></HEAD><BODY><P>Hi Clever,</P><P></P><P>Its not working. I want to display top and bottom 5 customers in Bar chart.</P><P></P><P></P><P>Thanks in Advance</P></BODY></HTML> Mon, 05 Oct 2015 13:07:42 GMT https://community.qlik.com/t5/QlikView/Top-5-Bottom-5-Values/m-p/995704#M967149 2015-10-05T13:07:42Z Re: Top 5 & Bottom 5 Values https://community.qlik.com/t5/QlikView/Top-5-Bottom-5-Values/m-p/995705#M967150 <HTML><HEAD></HEAD><BODY><P>depending on what you are trying to accomplish, you may be able to use your standard expression and use Dimension limits tab</P></BODY></HTML> Mon, 05 Oct 2015 13:12:20 GMT https://community.qlik.com/t5/QlikView/Top-5-Bottom-5-Values/m-p/995705#M967150 2015-10-05T13:12:20Z Re: Top 5 & Bottom 5 Values https://community.qlik.com/t5/QlikView/Top-5-Bottom-5-Values/m-p/995706#M967151 <HTML><HEAD></HEAD><BODY><P>Sorry, if you need it inside a graphe please use Dimension Limits as <A href="https://community.qlik.com/qlik-users/95643">akrepistman</A>‌ told</P></BODY></HTML> Mon, 05 Oct 2015 13:23:02 GMT https://community.qlik.com/t5/QlikView/Top-5-Bottom-5-Values/m-p/995706#M967151 Clever_Anjos 2015-10-05T13:23:02Z Re: Top 5 & Bottom 5 Values https://community.qlik.com/t5/QlikView/Top-5-Bottom-5-Values/m-p/995707#M967152 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-size: 13.3333px;">It would be easier if you post a sample of your application</SPAN></P></BODY></HTML> Mon, 05 Oct 2015 13:23:50 GMT https://community.qlik.com/t5/QlikView/Top-5-Bottom-5-Values/m-p/995707#M967152 Clever_Anjos 2015-10-05T13:23:50Z Re: Top 5 & Bottom 5 Values https://community.qlik.com/t5/QlikView/Top-5-Bottom-5-Values/m-p/995708#M967153 <HTML><HEAD></HEAD><BODY><P>Please find attached if fits your needs</P><P><IMG __jive_id="100983" alt="Capturar.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/100983_Capturar.PNG" style="height: 179px; width: 620px;" /></P></BODY></HTML> Mon, 05 Oct 2015 14:01:00 GMT https://community.qlik.com/t5/QlikView/Top-5-Bottom-5-Values/m-p/995708#M967153 Clever_Anjos 2015-10-05T14:01:00Z Re: Top 5 & Bottom 5 Values https://community.qlik.com/t5/QlikView/Top-5-Bottom-5-Values/m-p/995709#M967154 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Try this</P></BODY></HTML> Mon, 05 Oct 2015 17:32:09 GMT https://community.qlik.com/t5/QlikView/Top-5-Bottom-5-Values/m-p/995709#M967154 Anonymous 2015-10-05T17:32:09Z