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