topic Re: Top 20 values from expression in QlikView

Top 20 values from expression

rsdhavle — Tue, 08 Apr 2014 07:46:40 GMT

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

Re: Top 20 values from expression

MK_QSL — Tue, 08 Apr 2014 08:42:37 GMT

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.

Re: Top 20 values from expression

Tue, 08 Apr 2014 09:09:10 GMT

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..!!

Re: Top 20 values from expression

its_anandrjs — Tue, 08 Apr 2014 09:14:43 GMT

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

Re: Top 20 values from expression

Anonymous — Tue, 08 Apr 2014 09:19:10 GMT

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.