Top 10 and worest 10

[Anonymous]

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.

[krishna20 · Accepted solution]

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

[#3]

Hi Venkat,

use

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

hope it works.

Regards

Sam

[Gysbert_Wassenaar]

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.

[krishna20]

Hi ,

You can achieve it by using Dimension Limits also.

Regards

Krishna

[Anonymous]

Thank u...

[ashfaq_haseeb]

Hi,

Check this attached file.

Regards

ASHFAQ

[ashfaq_haseeb]

Hi,

Check this attached file.

Regards

ASHFAQ

[Anonymous]

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

[Anonymous]

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