Rank

[#1]

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...

[#2]

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.

[#3]

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]

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]

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

[#6]

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

[Miguel_Angel_Baeyens]

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]

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

[#9]

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.

[#10]

Any help pls for charts...