Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Not applicable

Rank

is there anything possible in QV like other reporting tool to have ranked data.

let say if i want ot have top 5 or bottom 5 revenue based on a particular dimension, how do I achieve in QV 10?

Thanks...

9 Replies
Not applicable

Rank

Yes, U can

we have Rank Function which accepts parameters try to use the function

if u want further help , let me know i will send a sample application.

Not applicable

Rank

Thanks Bhaskar,

yes I'm aware about rank function but would be great help if you send me some examples as m confused in diff. syntax.

boorgura
Valued Contributor

Rank

Yes you can achieve that using a condition on the dimension.

=if(aggr(rank(<expression>), <dimension>) <= 5, <dimension>, 'Others')

You can use the above format to show the top 5 values in the chart and the rest bucketed as others, if you do not want to show Others, just do not enter the else condition as 'Others' (also, you will have to supress nulls on this calculated dimension.

Let me know if you have any questions.

mazacini
Contributor III

Rank

Hi

Have you checked out the Executive Dashboard available as a Qlikdemo here:

http://demo.qlik.com/QvAJAXZfc/opendoc.htm?document=Executive%20Dashboard.qvw&host=Demo10&anonymous=...

If you go into the 80:20 table on the Sales Analyis sheet, it will show you how to order the Customers by Sales value ie Dimension by expression.

To only show top 5, go to Presentation tab in Properties, and for your dimension, change the Max Number to 5on the RHS - it will limit the display to the first 5.

For lowest, just change the sort order to ascending.

Hope this helps.

Joe

Not applicable

Rank

How do you look at the properties of these demos? Is there a way you can download them?

MVP
MVP

Rank

Hello,

I did something very similar in an application you can download and check the properties in the chart of this post.

Hope that helps.

mazacini
Contributor III

Rank

Hi

If you follow this link

http://demo.qlik.com/

Some of the demos have a link (DOWNLOAD . QVW) to download the .qvw file. You can then save them to your hard drive and view at your leisure. Some demos do not have this link, and can only be viewed in your browser.

Joe

Not applicable

Rank

Thanks All.

I got the idea but stil not able to show the proper results.

Requiremetns -

- need to show ranked measure on line chart -- where I need year on X , USD on Y and other dimension on which my rank should be based on third one.

- with the current expression my ranked thing is there on Y but the requirement is revenue should appear for top 5 only, I have used below expression - (aggr(rank(Sum ([USD])),[Vendor]) <= 5)

also with this i dont know result is quite weird with ranking ref. points as -1 and all the things pointing to that only.

Please assist, let me know any further clarifications needed.

Not applicable

Rank

Any help pls for charts...

Community Browser