topic Re: Top 10 values in QlikView https://community.qlik.com/t5/QlikView/Top-10-values/m-p/751863#M1035985 <HTML><HEAD></HEAD><BODY><P>See this example</P></BODY></HTML> Thu, 08 Jan 2015 06:30:42 GMT ecolomer 2015-01-08T06:30:42Z Top 10 values https://community.qlik.com/t5/QlikView/Top-10-values/m-p/751860#M1035982 <HTML><HEAD></HEAD><BODY><P>I am creating a bar chart that is showing comparison between&nbsp;&nbsp; Actual margin and Quoted margin for top 10 highest revenue giving products</P><P></P><P>Dimension limit restriction is not working because it restricts on the basis of first expression and my first expression is calculating margin</P><P>please suggest</P><P></P><P>Thanks in advance</P></BODY></HTML> Thu, 08 Jan 2015 06:17:59 GMT https://community.qlik.com/t5/QlikView/Top-10-values/m-p/751860#M1035982 2015-01-08T06:17:59Z Re: Top 10 values https://community.qlik.com/t5/QlikView/Top-10-values/m-p/751861#M1035983 <HTML><HEAD></HEAD><BODY><P>Could you please upload sample qvw......</P></BODY></HTML> Thu, 08 Jan 2015 06:23:48 GMT https://community.qlik.com/t5/QlikView/Top-10-values/m-p/751861#M1035983 senpradip007 2015-01-08T06:23:48Z Re: Top 10 values https://community.qlik.com/t5/QlikView/Top-10-values/m-p/751862#M1035984 <HTML><HEAD></HEAD><BODY><P>you can use rank function</P></BODY></HTML> Thu, 08 Jan 2015 06:27:58 GMT https://community.qlik.com/t5/QlikView/Top-10-values/m-p/751862#M1035984 arulsettu 2015-01-08T06:27:58Z Re: Top 10 values https://community.qlik.com/t5/QlikView/Top-10-values/m-p/751863#M1035985 <HTML><HEAD></HEAD><BODY><P>See this example</P></BODY></HTML> Thu, 08 Jan 2015 06:30:42 GMT https://community.qlik.com/t5/QlikView/Top-10-values/m-p/751863#M1035985 ecolomer 2015-01-08T06:30:42Z Re: Top 10 values https://community.qlik.com/t5/QlikView/Top-10-values/m-p/751864#M1035986 <HTML><HEAD></HEAD><BODY><P>Hi Prashant,</P><P></P><P>In dimension limit select 'Show Only first 10 values ' option for Product dimension .</P><P>In Sort, write your second expression in 'Expression' and sort it descending.</P></BODY></HTML> Thu, 08 Jan 2015 15:26:24 GMT https://community.qlik.com/t5/QlikView/Top-10-values/m-p/751864#M1035986 pradnyat 2015-01-08T15:26:24Z Re: Top 10 values https://community.qlik.com/t5/QlikView/Top-10-values/m-p/751865#M1035987 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>my example use it freely</P><P></P><P>Regards</P><P></P><P>André Gomes</P></BODY></HTML> Thu, 08 Jan 2015 15:35:36 GMT https://community.qlik.com/t5/QlikView/Top-10-values/m-p/751865#M1035987 agomes1971 2015-01-08T15:35:36Z Re: Top 10 values https://community.qlik.com/t5/QlikView/Top-10-values/m-p/751866#M1035988 <HTML><HEAD></HEAD><BODY><P>Hi Andre,</P><P></P><P>Try to use Expression sorting:</P><P><IMG alt="Untitled.png" class="image-1 jive-image" src="https://community.qlik.com/legacyfs/online/74862_Untitled.png" style="height: 237px; width: 620px;" /></P><P></P><P>Best regards,</P><P>Janusz</P></BODY></HTML> Thu, 08 Jan 2015 16:01:39 GMT https://community.qlik.com/t5/QlikView/Top-10-values/m-p/751866#M1035988 Anonymous 2015-01-08T16:01:39Z