Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Adjusting list of values in Qlikview

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!

1 Reply
nirav_bhimani
Partner - Specialist
Partner - Specialist

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