Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
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