Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

Grouping and Ranking

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.

Please Help!

1 Reply
Not applicable

Re: Grouping and Ranking

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.

Hope this helps

Community Browser