Adjusting list of values in Qlikview

[#1]

Hi,

I am very new to Qlikview and I'm struggling with some basic chart creations.

I would like to create something similar to the sample Salesforce.com app that you can find in Qlikview demos.

Basically I want to display the top 5 objects in each category/dimension, but I'm not

sure how exactly to code that.

For example:

There should be a listbox with the top 5 sales reps, top 5 schools, top 5 cities etc.

I know that you can go to the "dimension limits tab when creating a chart , but, unfortunately

that doesn't seem to work for listboxes.

Thanks!

[nirav_bhimani]

Hi,

Try this expression in your listbox dimesion.

= if (aggr (rank(sum(Sales)), Item)<=2 , Item)

see the attchment for the reference.

Regards,

Nirav Bhimani