# QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
cancel
Showing results for
Did you mean:
Not applicable

## Numbering Dimensions on a Chart

We are attempting to prepare a barchart with a large number of dimension values, let's say 200.  To simplify this, we are liming the display to the "Top 5" and then show others using the options under Dimension Limits property of the chart.  When the user clicks on "Other", they see the next 5.  After clicking on other a couple of times, it is hard to remember how far into the list you are.  So we would like to number the entire list so you would see the first 5 as 1, 2, 3, ,4, 5.  When selecting "Other", you would see 6, 7, 8, 9, 10.  And so on as you drilled into the other intil you get to the last screen where you would see 195, 196, 197, 198, 199, 200.

I.e., I would like to generate the handwritten numbers in the following image.

Any thoughts about how to accomplish this will be appreciated.

1 Solution

Accepted Solutions
Not applicable
Author

Thank you Anjos for putting me on the right track.  While it didn’t work quite as needed, it only took a few minutes to get from your idea to where we needed to be.  This is the expression that works precisely as intended:

=aggr(rank( sum({\$<Dim2=>}Expression1)),Dim2) & ' - ' & Dim2

In this case, we were trying to rank agencies within a particular fiscal year.  If I understand Set Analysis, your expression ranked the agencies based on all expenditures loaded.

Thanks again

4 Replies
Not applicable
Author

Would it not be better to show the first 5, but then to display a scroll bar?

Employee

Use an Calculated Dimension

=aggr(rank( sum({1}Expression1)),Dim2) & ' - ' & Dim2

PFA

Not applicable
Author

Thank you Anjos for putting me on the right track.  While it didn’t work quite as needed, it only took a few minutes to get from your idea to where we needed to be.  This is the expression that works precisely as intended:

=aggr(rank( sum({\$<Dim2=>}Expression1)),Dim2) & ' - ' & Dim2

In this case, we were trying to rank agencies within a particular fiscal year.  If I understand Set Analysis, your expression ranked the agencies based on all expenditures loaded.

Thanks again

Employee

Hi, good to know you have resolved

Your expression differs on mine that mine disregards ANY selection and your only Dim2 selections.