topic Grouping and Ranking in QlikView https://community.qlik.com/t5/QlikView/Grouping-and-Ranking/m-p/444903#M487744 <HTML><HEAD></HEAD><BODY><P>I have QV11 and I am trying to get a list of 10 revenues by Region. In a straight table and a pivot table.. Need to get the same ranking as in the attched file in QV and I have no idea how to do it. </P><P></P><P>Please Help!</P></BODY></HTML> Tue, 22 Jan 2013 20:28:33 GMT 2013-01-22T20:28:33Z Grouping and Ranking https://community.qlik.com/t5/QlikView/Grouping-and-Ranking/m-p/444903#M487744 <HTML><HEAD></HEAD><BODY><P>I have QV11 and I am trying to get a list of 10 revenues by Region. In a straight table and a pivot table.. Need to get the same ranking as in the attched file in QV and I have no idea how to do it. </P><P></P><P>Please Help!</P></BODY></HTML> Tue, 22 Jan 2013 20:28:33 GMT https://community.qlik.com/t5/QlikView/Grouping-and-Ranking/m-p/444903#M487744 2013-01-22T20:28:33Z Re: Grouping and Ranking https://community.qlik.com/t5/QlikView/Grouping-and-Ranking/m-p/444904#M487745 <HTML><HEAD></HEAD><BODY><P>You can use the dimension limits to select only the Top X elements from a dimension based on the first expression. Also you could use the Expression in the sort order for the same dimension, in descending order. This way you will have a top 10 list ordered.</P><P></P><P>Hope this helps</P></BODY></HTML> Tue, 22 Jan 2013 23:44:20 GMT https://community.qlik.com/t5/QlikView/Grouping-and-Ranking/m-p/444904#M487745 2013-01-22T23:44:20Z