Top 20 values from expression

[rsdhavle]

Hi,

I need to show top 25 values from an expression. What is the correct approach. Lets say i am calculating Sum(Sales) for 50 clients and i want to show top 25 clients how can i show that correctly?. Dimension limits does not work correctly

[MK_QSL]

Check my reply on below thread. Might be useful to you...

in qlikview i want take top 10 salaries how to wright ?

If you want something different, please upload your sample data file along with your requirements.

[#3]

Hi,

To show top 25 clients, first go to the sort tab and in Expression option write the same expression you have used for calculating sales and make the sort order as descending.

After that go to the Dimension limits tab and for Client Dimension select show first 25 values.

This will display only first 25 clients.

Hope this will help you..!!

[its_anandrjs]

There are many ways do show this by Dimension limit you can do this very well

1. From load script you can find top N

2. From SET analysis expression.

3. From any variables in expression by input box.

4. From chart properties Dimension limits.

4. In any Bar charts also.

Regards

[Anonymous]

Hey,

1)load the clients as dimension

2) Sum(Sales) as expression

3) Sort by y-value descending

4) dimension limits to whatever number u want(Eg: show only largest 5)

5) unselect show others in dimension limits.

Done.

Hope this helps u.