topic Rank in QlikView

Rank

Thu, 09 Dec 2010 14:22:50 GMT

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

Rank

Thu, 09 Dec 2010 14:50:45 GMT

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.

Rank

Thu, 09 Dec 2010 14:56:06 GMT

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.

Rank

boorgura — Thu, 09 Dec 2010 14:59:04 GMT

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.

Rank

mazacini — Thu, 09 Dec 2010 15:06:51 GMT

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=true

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

Rank

Thu, 09 Dec 2010 16:43:23 GMT

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

Rank

Miguel_Angel_Baeyens — Thu, 09 Dec 2010 17:13:46 GMT

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.

Rank

mazacini — Fri, 10 Dec 2010 11:03:33 GMT

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

Rank

Fri, 10 Dec 2010 11:43:00 GMT

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.

Rank

Mon, 13 Dec 2010 08:27:19 GMT

Any help pls for charts...