Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

Top 10 and worest 10

Hello Community,

I have a requirement to show top 10 records according to sales in one chart(stright table with 10 columns) and worest 10 in another....

Thanks in Advance.

Regards,

Venkat.

1 Solution

Accepted Solutions
Highlighted
Specialist II
Specialist II

Hi,

Goto presentation tab in straight table select MAX value as  20and goto sort tab select Descending for top 20 and select Ascending for worst 20 in another table.

Regards

Krishna

View solution in original post

9 Replies
Highlighted
Specialist II
Specialist II

Hi,

Goto presentation tab in straight table select MAX value as  20and goto sort tab select Descending for top 20 and select Ascending for worst 20 in another table.

Regards

Krishna

View solution in original post

Highlighted
Not applicable

Hi Venkat,

use

if(Rank(Sum(Sales))<=10,Sum(Sales)). this is for top 10

hope it works.

Regards

Sam


Highlighted
MVP & Luminary
MVP & Luminary

You can use Dimension Limits to do this. There are tons of discussions on this subject: http://community.qlik.com/search.jspa?q=dimension+limits

Try reading some and see if you can solve your problem yourself.


talk is cheap, supply exceeds demand
Highlighted
Specialist II
Specialist II

Hi ,

You can achieve it by using Dimension Limits also.

Regards

Krishna

Highlighted
Creator
Creator

Thank u...

Hi,

Check this attached file.

Regards

ASHFAQ

Highlighted

Hi,

Check this attached file.

Regards

ASHFAQ

Highlighted
Creator
Creator

i am using personal editor Ashfaq.... i cannot open qvw file...

Highlighted
Creator
Creator

dimension limits would work on dimensions only...if we want to show expression values we have to use rank or presentation of max records(in chart-->presentation).i guess....